()
| 82 | |
| 83 | |
| 84 | def _init_msg_db(): |
| 85 | from db import Sql |
| 86 | |
| 87 | db = Sql() |
| 88 | db.dbfile("msg_box") |
| 89 | create_msg_sql = ( |
| 90 | "CREATE TABLE IF NOT EXISTS 'msg' (" |
| 91 | "'id' INTEGER PRIMARY KEY AUTOINCREMENT, " |
| 92 | "'sub_id' INTEGER NOT NULL DEFAULT 0, " |
| 93 | "'sub_type' TEXT NOT NULL DEFAULT '', " |
| 94 | "'title' TEXT NOT NULL DEFAULT '', " |
| 95 | "'read' INTEGER NOT NULL DEFAULT 0, " |
| 96 | "'msg_types' TEXT NOT NULL DEFAULT '[]', " |
| 97 | "'source' TEXT NOT NULL DEFAULT '[]', " |
| 98 | "'level' INTEGER NOT NULL DEFAULT 0, " |
| 99 | "'read_time' INTEGER NOT NULL DEFAULT 0, " |
| 100 | "'create_time' INTEGER NOT NULL DEFAULT (strftime('%s'))" |
| 101 | ");" |
| 102 | ) |
| 103 | res = db.execute(create_msg_sql) |
| 104 | if isinstance(res, str) and res.startswith("error"): |
| 105 | public.WriteLog("消息盒子", "建表msg失败: " + res) |
| 106 | return |
| 107 | res = db.execute("pragma journal_mode=wal") |
| 108 | # public.print_log(res) |
| 109 | |
| 110 | |
| 111 | # 代替 db.py 中， 离谱的两个query函数 |
no test coverage detected