summaryrefslogtreecommitdiff
path: root/code/botcmds
diff options
context:
space:
mode:
authorstolenvw <stolenvw@hotmail.com>2021-04-12 16:54:58 -0400
committerstolenvw <stolenvw@hotmail.com>2021-04-12 16:54:58 -0400
commit90c4debcbc961b342353a6576501ffe096329068 (patch)
tree7848f2fea2c08debf15c18e85b7d46e93a49af36 /code/botcmds
parent8ada699bc41441a91eebbecd60227a56e4ab0412 (diff)
Fixed where some commands where not reconnecting the MySQL database when connecting to database timedout do to being inactive
Diffstat (limited to 'code/botcmds')
-rw-r--r--code/botcmds/maincmd.py11
1 files changed, 1 insertions, 10 deletions
diff --git a/code/botcmds/maincmd.py b/code/botcmds/maincmd.py
index e1e2000..77c05ce 100644
--- a/code/botcmds/maincmd.py
+++ b/code/botcmds/maincmd.py
@@ -14,13 +14,6 @@ class Main(commands.Cog):
def __init__(self, bot):
self.bot = bot
- self.mydb = mysql.connector.connect(
- host=config.SQL_HOST,
- user=config.SQL_USER,
- password=config.SQL_PASS,
- database=config.SQL_DATABASE,
- port=config.SQL_PORT,
- )
@commands.command(name="deaths",
brief="Deaths leaderboard",
@@ -83,10 +76,8 @@ class Main(commands.Cog):
#Get data from mysql
botsql = self.bot.get_cog('BotSQL')
- mycursor = await botsql.get_cursor()
- mycursor.close()
sqls = """SELECT date, users FROM serverstats WHERE timestamp BETWEEN '%s' AND '%s'""" % (tlookup, int(time.time()))
- df = pd.read_sql(sqls, self.mydb, parse_dates=['date'])
+ df = pd.read_sql(sqls, await botsql.get_mydb(), parse_dates=['date'])
lastday = datetime.now() - timedelta(hours = user_range)
# Plot formatting / styling matplotlib