def updateAccount(account): cur = mysql.cursor() cur.execute( """UPDATE accounts SET username = %s, password = %s, email = %s, admin = %s, present = %s, nom = %s, prenom = %s, ecole = %s, annee = %s, phone = %s, specialite = %s, theme = %s WHERE id = %s""", ( account[1], account[2], account[3], account[4], account[5], account[6], account[7], account[8], account[9], account[10], account[11], account[12], account[0], )) mysql.commit() return True
def getAccount(_id): cursor = mysql.cursor() cursor.execute("""SELECT * FROM accounts WHERE id = %s""", (_id, )) account = cursor.fetchall() return account[0]
def delInfos(_id): cur = mysql.cursor() cur.execute("""DELETE FROM infos WHERE id = %s""", (_id, )) mysql.commit() return True
def delAccount(_id): cur = mysql.cursor() cur.execute("""DELETE FROM accounts WHERE id = %s""", (_id, )) mysql.commit() return True
def presentAccounts(): cursor = mysql.cursor() cursor.execute("""UPDATE accounts SET present = %s""", (False, )) mysql.commit() return True
def getAccounts(): cursor = mysql.cursor() cursor.execute("""SELECT * FROM accounts ORDER BY nom""") account = cursor.fetchall() return account
def delSujet(_id): cur = mysql.cursor() cur.execute("""DELETE FROM sujets WHERE id = %s""", (_id,)) mysql.commit() return True
def delConfig(_id): cur = mysql.cursor() cur.execute("""DELETE FROM config WHERE id = %s""", (_id, )) mysql.commit() return True
def getSujet(_id): cursor = mysql.cursor() cursor.execute("""SELECT * FROM sujets WHERE id = %s""", (_id,)) sujet = cursor.fetchall() return sujet[0]
def getMatch(_id): cursor = mysql.cursor() cursor.execute("""SELECT * FROM matchs WHERE id = %s""", (_id, )) match = cursor.fetchall() return match[0]
def getCours(): cursor = mysql.cursor() cursor.execute("""SELECT * FROM cours ORDER BY datedb""") cours = cursor.fetchall() return cours
def getConfig(_id): cursor = mysql.cursor() cursor.execute("""SELECT * FROM config WHERE id = %s""", (_id, )) config = cursor.fetchall() return config[0]
def getInfos(): cursor = mysql.cursor() cursor.execute("""SELECT * FROM infos ORDER BY datedb""") infos = cursor.fetchall() return infos
def getSujets(sujet): cursor = mysql.cursor() cursor.execute("""SELECT * FROM sujets WHERE type = %s ORDER BY sujet""", (sujet,)) sujets = cursor.fetchall() return sujets
def getToken(username): cursor = mysql.cursor() cursor.execute( """SELECT * FROM accounts WHERE username = %s""", (username, )) account = cursor.fetchall() return account[0][13]
def getAccountToken(token): cursor = mysql.cursor() cursor.execute( """SELECT * FROM accounts WHERE token = %s""", (token)) account = cursor.fetchall() return account
def registSujets(sujet): cursor = mysql.cursor() cursor.execute(""" INSERT INTO sujets (sujet, type) VALUES (%s,%s)""", (sujet[0], sujet[1],)) mysql.commit() return True
def updateSujet(_id, sujet): cur = mysql.cursor() cur.execute("""UPDATE sujets SET sujet = %s, type = %s WHERE id = %s""", (sujet[0], sujet[1], _id,)) mysql.commit() return True
def presentAccount(_id): cursor = mysql.cursor() cursor.execute( """UPDATE accounts SET present = %s WHERE id =%s""", (True, _id)) mysql.commit() return True
def getMatchs(_type): cursor = mysql.cursor() cursor.execute( """SELECT * FROM matchs WHERE type = %s ORDER BY datedb""", (_type, )) matchs = cursor.fetchall() return matchs
def updatePassword(password, username): cur = mysql.cursor() cur.execute( """UPDATE accounts SET password = %s WHERE username = %s""", ( password, username, )) mysql.commit() return True
def getConfigs(name, typeconf): cursor = mysql.cursor() cursor.execute( """SELECT * FROM config WHERE name = %s AND type = %s ORDER BY value""", ( name, typeconf, )) configs = cursor.fetchall() return configs
def registInfos(info): cursor = mysql.cursor() cursor.execute( """ INSERT INTO infos (datedb, description) VALUES (%s, %s)""", ( info[0], info[1], )) mysql.commit() return True
def verifAccount(username): try: cursor = mysql.cursor() cursor.execute( """SELECT * FROM accounts WHERE username = %s""", (username, )) account = cursor.fetchall() return account[0] except: return False
def registMatchs(match): cursor = mysql.cursor() cursor.execute( """ INSERT INTO matchs (datedb, type, sujet, equipe, gouvernement, opposition, meilorateur, meilequipe, jury) VALUES (%s,%s, %s, %s, %s, %s, %s, %s, %s)""", (match[0], match[1], match[2], match[3], match[4], match[5], match[6], match[7], match[8])) mysql.commit() return True
def updateMatch(_id, match): cur = mysql.cursor() cur.execute( """UPDATE matchs SET datedb = %s, type = %s, sujet = %s, equipe = %s, gouvernement = %s, opposition = %s, meilorateur = %s, meilequipe = %s, jury = %s WHERE id = %s""", (match[0], match[1], match[2], match[3], match[4], match[5], match[6], match[7], match[8], _id)) mysql.commit() return True
def registConfig(config): cursor = mysql.cursor() cursor.execute( """ INSERT INTO config (type, name, value, description) VALUES (%s,%s, %s, %s)""", ( config[0], config[1], config[2], config[3], )) mysql.commit() return True
def logAccount(username, password): try: cursor = mysql.cursor() cursor.execute( """SELECT * FROM accounts WHERE username = %s AND password = %s""", ( username, password, )) logAccount = cursor.fetchall() return logAccount[0] except: return False
def name(typeconf): unique = [] cur = mysql.cursor() cur.execute( """SELECT * FROM config WHERE type = %s ORDER BY value""", (typeconf, )) config = cur.fetchall() for conf in config: name = str(conf[2]) unique.append(name) if name not in unique else 0 return unique
def registCours(cours): cursor = mysql.cursor() cursor.execute( """INSERT INTO cours (titre, datedb, start, end, lien, color) VALUES (%s, %s,%s, %s, %s, %s)""", ( cours[0], cours[1], cours[2], cours[3], cours[4], cours[5], )) mysql.commit() return True