def get_roles(self):
list = []
mydb = sql.createConnection()
cur = mydb.cursor()
cur.execute(f"SELECT roleid from colour_roles")
for Row in cur:
list.append(Row)
return list
def add_support_role(self, roleid):
if not self.already_support_role(roleid):
mydb = sql.createConnection()
cur = mydb.cursor()
cur.execute(f"INSERT into `colour_roles` VALUES ('{roleid}')")
mydb.commit()
return True
else:
return False
def remove_access(self, user, table):
UID = (user.id)
if self.has_access(user):
mydb = sql.createConnection()
cur = mydb.cursor()
cur.execute(f"DELETE FROM `{config.mysql_db}`.`{table}` WHERE id='{UID}';")
mydb.commit()
return True
else:
return False
def set_access(self, user, table):
UID = (user.id)
if not self.has_access(user):
mydb = sql.createConnection()
cur = mydb.cursor()
cur.execute(f"INSERT into `{config.mysql_db}`.`{table}` VALUES ('{user.id}')")
mydb.commit()
return True
else:
return False
def add_id(self, user):
UID = (user.id)
if not self.has_applied(UID):
mydb = sql.createConnection()
cur = mydb.cursor()
cur.execute(f"INSERT into `applications` VALUES ('{UID}')")
mydb.commit()
return True
else:
return False
def remove_support_role(self, roleid):
if self.already_support_role(roleid):
mydb = sql.createConnection()
cur = mydb.cursor()
cur.execute(
f"DELETE from `colour_roles` WHERE roleid = '{roleid}'")
mydb.commit()
return True
else:
return False