def select_area(latest, province):
if latest == '1':
sql = """
SELECT * FROM (
SELECT * FROM `area`
ORDER BY updateTime DESC
) AS t
GROUP BY provinceName
HAVING provinceName LIKE '%{}%'
ORDER BY country="中国" DESC, confirmedCount+0 DESC, updateTime DESC
""".format(province)
elif latest == '0':
sql = """
SELECT * FROM (
SELECT * FROM `area`
ORDER BY updateTime DESC
) AS t
WHERE provinceName LIKE '%{}%'
ORDER BY country="中国" DESC, confirmedCount+0 DESC, updateTime DESC;
""".format(province)
db = POOL.connection()
db.ping(reconnect=True)
cursor = db.cursor(pymysql.cursors.DictCursor)
cursor.execute(sql)
res = cursor.fetchall()
cursor.close()
db.close()
return res
def select_daily(date):
sql = """
SELECT * FROM `daily`
WHERE Tdate LIKE '%{}%'
""".format(date)
db = POOL.connection()
db.ping(reconnect=True)
cursor = db.cursor(pymysql.cursors.DictCursor)
cursor.execute(sql)
res = cursor.fetchall()
cursor.close()
db.close()
return res
def select_overall_all():
sql = """
SELECT DISTINCT * FROM `overall`
ORDER BY updateTime desc
"""
db = POOL.connection()
db.ping(reconnect=True)
cursor = db.cursor(pymysql.cursors.DictCursor)
cursor.execute(sql)
res = cursor.fetchall()
cursor.close()
db.close()
return res
def select_location(province, city, district, address):
sql = """
SELECT * FROM `location`
WHERE
province LIKE "%{}%"
AND city LIKE "%{}%"
AND district LIKE "%{}%"
AND address LIKE "%{}%";
""".format(province, city, district, address)
db = POOL.connection()
db.ping(reconnect=True)
cursor = db.cursor(pymysql.cursors.DictCursor)
cursor.execute(sql)
res = cursor.fetchall()
cursor.close()
db.close()
return res
def open_cursor(self):
if not self.cursor and not self.db:
self.db = POOL.connection()
self.cursor = self.db.cursor(pymysql.cursors.DictCursor)