events.py

import sqlite3
import os
from user import *

class Event():
    def __init__(self, id, club_id, event_title, event_content, event_start, event_start_time, event_end, event_end_time, event_tags, people_interested, isApproved):
        self.id = id
        self.club_id = club_id
        self.event_title = event_title
        self.event_content = event_content
        self.event_start = event_start
        self.event_start_time = event_start_time
        self.event_end = event_end
        self.event_end_time = event_end_time
        self.event_tags = event_tags
        self.people_interested = people_interested
        self.isApproved = isApproved
#### BEFORE APPROVAL
## EVENT CREATION FUNCTIONS
def create_event(club_id, event_title, event_content, event_start, event_start_time, event_end, event_end_time, event_tags):
    db = sqlite3.connect('db/database.db')
    db_cursor = db.cursor()

    new_event = Event(None, club_id, event_title, event_content, event_start, event_start_time, event_end, event_end_time, event_tags, None, None)

    try: 
        db_cursor.execute(
            """INSERT INTO events
            (event_title, event_content, event_start, event_start_time, event_end, event_end_time, event_tags, club_id) VALUES (?,?,?,?,?,?,?,?)""",
            (new_event.event_title, new_event.event_content, new_event.event_start, new_event.event_start_time, new_event.event_end, new_event.event_end_time, new_event.event_tags, new_event.club_id,)
        )
        db.commit()
    except Exception as e:
        db.rollback()
## EVENT EDITING FUNCTIONS (needs to do before approval)
def edit_event(event_content, event_start_date, event_end_date, event_tags):
    pass

#### EVENT SEARCHING FUNCTIONS
def search_event():
    db = sqlite3.connect('db/database.db')
    db_cursor = db.cursor()
    db_cursor.execute("")

#get event by club
def get_event_by_club(club_id):
    db = sqlite3.connect('db/database.db')
    db_cursor = db.cursor()
    db_cursor.execute("SELECT * FROM events WHERE club_id=? AND isApproved=1", (club_id,))
    data = db_cursor.fetchall()
    if data == None:
        data = []
    db.close()
    return data  

#get the approved events
def get_approved_events():
    db = sqlite3.connect('db/database.db')
    db_cursor = db.cursor()
    db_cursor.execute("SELECT * FROM events WHERE isApproved=1")
    data = db_cursor.fetchall()
    db.close()
    return data 

#admin functionality
def get_all_events():
    db = sqlite3.connect('db/database.db')
    db_cursor = db.cursor()
    db_cursor.execute("SELECT * FROM events")
    data = db_cursor.fetchall()
    db.close()
    return data