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