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