utils.py

# Description: This file contains all the functions that are used to validate the data that is being sent to the database
import datetime

# All validator functions

'''
    Handling all is validators
'''

# Check if its a valid SIG


def isValidSigName(db_GDSC, sig_name):
    sig_collection = db_GDSC["sigs"]
    x = sig_collection.find_one({"sig_name": sig_name})
    if x == None:
        return 0  # Dint find such a SIG
    else:
        return 1  # Found the SIG

# Check if its a valid discord username on WEC database


def isValidDiscordUsername(db_GDSC, discord_username):
    user_collection = db_GDSC["users"]
    x = user_collection.find_one({"discord_username": discord_username})
    if x == None:
        return 0  # Dint find such a discord_username
    else:
        return 1  # Found the discord_username

# Check if person is a head


def isHead(db_GDSC, discord_username):
    user_collection = db_GDSC['users']
    x = user_collection.find_one({'discord_username': discord_username})
    if x['head'] == True:
        return 1  # If user is head
    else:
        return 0  # User not head


def isDiscordUsernameOnDatabase(db_GDSC, discord_username):
    user_collection = db_GDSC['users']
    x = user_collection.find_one({'discord_username': discord_username})
    if x == None:
        # not in WEC
        return 0
    else:
        # in WEC
        return 1


def isExecutive(db_GDSC, discord_username):
    user_collection = db_GDSC['users']
    x = user_collection.find_one({'discord_username': discord_username})
    # EM-Executive Member
    if x['role'] == "EM":
        return 1  # If executive Member
    else:
        return 0  # Not an executive Member


'''
    Handling all finder functions
'''


def findUserInfo(db_GDSC, discord_username):
    user_collection = db_GDSC["users"]
    x = user_collection.find_one({"discord_username": discord_username})
    if (x['role'] == 'EM'):
        role = 'Executive Member'
    else:
        role = 'Member'
    return f'''
        Name: {x["username"]}\nRole: {role}\nEmail: {x["email"]}\nGithub: {x["github"]}\nSIG: {x["sig"]}\nYear: {x["year"]}\nBranch: {x["branch"]}\nPhone: {x["phone"]}\nDiscord Username: {x["discord_username"]}
    '''


def findSIGMembers(db_GDSC, sig_name):
    sig_collection = db_GDSC["users"]
    x = sig_collection.find({"sig": sig_name})
    if x == None:
        return 0
    else:
        L = []
        for i in x:
            L.append(i["username"])
        if (len(L) == 0):
            return "No members in this SIG"
        else:
            return L


def findSigInfo(db_GDSC, sig_name):
    sig_collection = db_GDSC["sigs"]
    data = {
        "sig_name": sig_name,
    }
    x = sig_collection.find_one(data)
    print(x)
    return f'''
        SIG Name: {sig_name}\nSIG Head: {x["sig_head"]}\nSIG Description: {x["sig_desc"]}\nSIG Members: {findSIGMembers(db_GDSC, sig_name)}
    '''


'''
Handling all adding stuff
'''


def addSIG(db_GDSC, sig_name, sig_head):
    sig_collection = db_GDSC["sig"]
    data = {
        "sig": sig_name,
        "head": sig_head
    }
    sig_collection.insert_one(data)


def addEvent(db_GDSC, date, event_Name, venue, time, about, tech_or_tech):
    event_collection = db_GDSC["events"]
    data = {
        "date": date,
        "event_Name": event_Name,
        "venue": venue,
        "time": time,
        "about": about,
        "tech_or_tech": tech_or_tech,
    }
    event_collection.insert_one(data)


def addUserToSig(db_GDSC, sig, discord_username):
    sig_collection = db_GDSC["sig"]
    x = sig_collection.find_one({"sig": sig})
    if x == None:
        return 0
    else:
        sig_collection.update_one(
            {"sig": sig}, {"$push": {"members": discord_username}})
        return 1


def upcomingEvents(db_GDSC):
    # for upcoming events with reference to current date where current date is todays date get from datetime module
    events_collection = db_GDSC["events"]
    x = events_collection.find().sort("event_date")
    L = []
    for i in x:
        if i["event_date"] > datetime.datetime.now():
            L.append(i["event_name"])
    return L


def displayPastEvents(db_GDSC):
    # display the past events with reference to current date where current date is todays date get from datetime module
    events_collection = db_GDSC["events"]
    x = events_collection.find().sort("event_date")
    L = []
    for i in x:
        if i["event_date"] < datetime.datetime.now():
            L.append(i["event_name"])
    return L


def eventInfo(db_GDSC, event_name):
    events_collection = db_GDSC["events"]
    x = events_collection.find_one({"event_name": event_name})
    if x == None:
        return 0
    else:
        return f'''
            Event Name: {x["event_name"]}\nDate: {x["event_date"]}\nTime: {x["event_time"]}\nVenue: {x["event_venue"]}\nAbout: {x["event_description"]}\nTechical Event: {x["event_T"]}
        '''


def displayNonTechnicalEvents(db_GDSC):
    events_collection = db_GDSC["events"]
    x = events_collection.find({"event_T": False})
    L = []
    for i in x:
        L.append(i["event_name"])
    return L


def displayTechnicalEvents(db_GDSC):
    events_collection = db_GDSC["events"]
    x = events_collection.find({"event_T": True})
    L = []
    for i in x:
        L.append(i["event_name"])
    return L


def isValidEventName(db_GDSC, event_name):
    event_collection = db_GDSC["events"]
    x = event_collection.find_one({"event_name": event_name})
    if x == None:
        return 0  # Dint find such a Event
    else:
        return 1  # Found the Event