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)
)""")