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