1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| from read_log_times import connect
| import json
|
| with connect() as c:
| with c.cursor() as q:
| for sql in [
| "SHOW CREATE TABLE mes_wm_misc_receipt_line",
| "SHOW CREATE TABLE mes_wm_misc_receipt_detail",
| "SHOW CREATE TABLE mes_wm_misc_receipt",
| "SHOW TABLES LIKE 'mes_wm_misc_receipt%'",
| "SELECT COUNT(*) count FROM mes_wm_misc_receipt",
| "SELECT id,code,name,status FROM mes_wm_misc_receipt ORDER BY id DESC LIMIT 3",
| "SELECT label,value,status FROM system_dict_data WHERE dict_type='mes_wm_misc_receipt_type' AND deleted=0",
| ]:
| q.execute(sql)
| print(json.dumps({'sql': sql, 'rows': q.fetchall()}, ensure_ascii=False, default=str))
|
|
