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))