def prefix(): cnx = dbConnect.connect() cursor = cnx.cursor() cursor.execute("""CREATE TABLE `prefix` ( `guild_id` BIGINT NOT NULL, `prefix` CHAR(50) NOT NULL, primary key (guild_id) )""")
def config(): cnx = dbConnect.connect() cursor = cnx.cursor() cursor.execute("""CREATE TABLE `config` ( `guild_id` BIGINT NOT NULL, `option_name` VARCHAR(50) NOT NULL, `value` LONGTEXT NOT NULL, primary key (guild_id, option_name) )""")
def cogs(): cnx = dbConnect.connect() cursor = cnx.cursor() cursor.execute("""CREATE TABLE `cogs` ( `cog_name` VARCHAR(50) NOT NULL, `is_enabled` BOOLEAN NOT NULL, `is_loaded` BOOLEAN NOT NULL, primary key (cog_name) )""")
def commands(): cnx = dbConnect.connect() cursor = cnx.cursor() cursor.execute("""CREATE TABLE `commands` ( `guild_id` BIGINT NOT NULL, `command_name` VARCHAR(30) NOT NULL, `is_enabled` BOOLEAN NOT NULL, `times_used` BIGINT, primary key (guild_id, command_name) )""")
def ignore(): cnx = dbConnect.connect() cursor = cnx.cursor() cursor.execute("""CREATE TABLE `ignore` ( `guild_id` BIGINT NOT NULL, `guild_name` VARCHAR(50) NOT NULL, `member_id` BIGINT NOT NULL, `is_ignored` BOOLEAN NOT NULL, primary key (guild_id, member_id) )""")
def archive(): cnx = dbConnect.connect() cursor = cnx.cursor() cursor.execute("""CREATE TABLE `archive` ( `guild_id` BIGINT NOT NULL, `channel` BIGINT, `role` BIGINT, `pins` BOOLEAN, `toggle` BOOLEAN, primary key (guild_id) )""")
def startUpChecks(): # mainConfig.ini exists try: conf = config.readINI('mainConfig.ini') logger.passStart('mainConfig.ini found') except Exception as e: logger.errorStart('mainConfig.ini missing or unable to load') logger.errorStart(e) return False # database connection try: if dbConnect.connect() != False: logger.passStart('database connected') else: logger.errorStart('unable to connect to database') return False except Exception as e: logger.errorStart('unable to connect to database') logger.errorStart(e) return False # botname in mainConfig.ini try: name = conf['main']['botname'] logger.passStart('botName found') except Exception as e: logger.errorStart('botname not found in mainConfig.ini') logger.errorStart(e) return False # default prefix in mainConfig.ini try: prefix = conf['main']['prefix'] logger.passStart('prefix found') except Exception as e: logger.errorStart('prefix not found in mainConfig.ini') logger.errorStart(e) return False # token in mainConfig.ini try: token = conf['main']['discordToken'] logger.passStart('token found') except Exception as e: logger.errorStart('token not found in mainConfig.ini') logger.errorStart(e) return False return True
def leaderboard(): cnx = dbConnect.connect() cursor = cnx.cursor() cursor.execute("""CREATE TABLE `leaderboard` ( `guild_id` BIGINT NOT NULL, `guild_name` VARCHAR(50) NOT NULL, `member_id` BIGINT NOT NULL, `member_name` VARCHAR(50), `level` INT, `points` BIGINT, `next_level` BIGINT, `last_added` DATETIME, `message_count` BIGINT, primary key (guild_id, member_id) )""")