def saveDB(col, data, db="Pstatus.db", table=jh):
Pdb = DBHandler(db)
# 创建表
# table_cmd =
# status
# table_cmd = col[0] + " INT,"
# 日期
table_cmd = col[0] + " text,"
for i in range(1, len(col)):
table_cmd += col[i] + " REAL DEFAULT 0,"
table_cmd = table_cmd.rstrip(',')
print("table_cmd:", table_cmd)
Pdb.createTable(table, table_cmd)
# 插入数据
Pdb.insertMany(table, data)
# 提交
Pdb.dbCommit()
# 查询
# des,res = Pdb.queryAll("Pstatus",1000)
# print(res)
# 关闭
Pdb.dbClose()
def query_db(jh):
dbquery = DBHandler(db)
dbquery.row_factory()
col_name,rv = dbquery.queryAll(jh,100000)
dbquery.dbCommit()
dbquery.dbClose()
# return (rv[0] if rv else None) if one else rv
return col_name,rv
