def runSql(self):
t = time.time()
db = client.conn()
db.execute("select * from TABLE_CONSTRAINTS join (CHARACTER_SETS,STATISTICS)")
# db.execute("select * from PLUGINS join (SESSION_STATUS,SESSION_VARIABLES);")
db.close()
return time.time() - t
def runSql(self):
t = time.time()
db = client.conn()
db.execute(
"select * from TABLE_CONSTRAINTS join (CHARACTER_SETS,STATISTICS)")
db.close()
return time.time() - t
def mysql_to_file(cls):
conn = client.conn()
try:
sql = "show table status"
tables_infos = conn.query(sql)
data = {}
os.popen('rm ./public/toml/* -f')
os.popen('rm ./public/json/* -f')
xls_table_map = get_xls_table_map()
table_names = _.pluck("table_name", xls_table_map)
for k in tables_infos:
if k.Name in table_names:
data["tableInfos"] = k
sql = "SELECT * FROM " + k.Name
result = (conn.query(sql))
data["record"] = result
sql = "SHOW FULL FIELDS FROM " + k.Name
result1 = conn.query(sql)
data["fieldInfo"] = result1
cls.toToml(data)
cls.toJson(data)
zipTool.zip_dir("./public/toml", "./public/toml.zip")
zipTool.zip_dir("./public/json", "./public/json.zip")
return True
except:
traceback.print_exc()
return False
def runSql(self):
t = time.time()
db = client.conn()
db.execute(
"select * from TABLE_CONSTRAINTS join (CHARACTER_SETS,STATISTICS)")
# db.execute("select * from PLUGINS join (SESSION_STATUS,SESSION_VARIABLES);")
db.close()
return time.time() - t
def runSql(self):
t = time.time()
db = client.conn()
db.execute("select * from TABLE_CONSTRAINTS join (CHARACTER_SETS,STATISTICS)")
db.close()
return time.time() - t
