def mysql_connect():
conn = comic_hentai_data_source.get_conn()
cursor = conn.cursor()
# 得到当前数据库中的所有表
cursor.execute(
"SELECT DISTINCT table_name FROM information_schema.columns WHERE table_schema = 'jxt' ORDER BY table_schema,table_name"
)
tables = cursor.fetchall()
print(tables)
for table in tables:
table = table[0]
if table == 'TestComic' or table == "TestUser":
continue
cursor.execute(
"SELECT column_name,data_type,is_nullable,column_comment FROM information_schema.columns WHERE table_name = '"
+ table + "' ORDER BY table_schema,table_name", )
values = cursor.fetchall()
columns = []
for column in values:
if not (column[0] == 'id' or column[0] == 'created'
or column[0] == 'updated' or column[0] == 'isDeleted'
or column[0] == 'status'):
columns.append(column)
print(columns)
initAll(table, columns)
cursor.close()
conn.close()
def get_comic():
conn = comic_hentai_data_source.get_conn()
find_comic_simple_info = "select id, title from Comic"
cursor = conn.cursor()
cursor.execute(find_comic_simple_info)
result = cursor.fetchall()
operator = "curl -XPUT "
for r in result:
id = str(r[0])
title = str(r[1])
title = title.replace("'", "'")
data = json.dumps({"id": id, "title": title})
url = r"'http://db.hope6537.com:9200/comichentai/comic/" + id + r"'"
tmp = operator + url + " -d \'" + data + '\''
print(tmp)
commands.getstatusoutput(tmp)
def get_comic():
conn = comic_hentai_data_source.get_conn()
find_comic_simple_info = "select id, title from Comic"
cursor = conn.cursor()
cursor.execute(find_comic_simple_info)
result = cursor.fetchall()
operator = "curl -XPUT "
for r in result:
id = str(r[0])
title = str(r[1])
title = title.replace("'", "'")
data = json.dumps({
"id": id,
"title": title
})
url = r"'http://db.hope6537.com:9200/comichentai/comic/" + id + r"'"
tmp = operator + url + " -d \'" + data + '\''
print(tmp)
commands.getstatusoutput(tmp)
def mysql_connect():
conn = comic_hentai_data_source.get_conn()
cursor = conn.cursor()
# 得到当前数据库中的所有表
cursor.execute(
"select distinct table_name from information_schema.columns where table_schema = 'ComicHentai' order by table_schema,table_name")
tables = cursor.fetchall()
print(tables)
for table in tables:
table = table[0]
if table == 'TestComic' or table == "TestUser":
continue
cursor.execute(
"select column_name,data_type,is_nullable,column_comment from information_schema.columns where table_name = '" + table + "' order by table_schema,table_name", )
values = cursor.fetchall()
columns = []
for column in values:
if not (column[0] == 'id' or column[0] == 'created' or column[0] == 'updated' or column[0] == 'isDeleted' or
column[0] == 'status'):
columns.append(column)
print(columns)
initAll(table, columns)
cursor.close()
conn.close()
