Python读写sqlite3数据库的方法并且将数据写入Excel的实例详解

 src = 'F:\log\mha-041log\rnd-log-dl.huawei.com\test'
# dst = sys.argv[2]
 dst = 'F:\log\mha-041log\rnd-log-dl.huawei.com\test\mha-041log.db'
# dst_anylyzed = sys.argv[3]
 dst_anylyzed = 'F:\log\mha-041log\rnd-log-dl.huawei.com\test\mha-041log.xlsx'
 cx = sqlite3.connect(dst)
 init_table_title(cx, startcoreapp_table)
 init_table_title(cx, startwechat_table)
 init_table_title(cx, coreappjankframe_table)
 init_table_title(cx, wechatjankframe_table)
 init_table_title(cx, otherapp_table)
 os.path.walk(src, visit_zipfile, cx)

def init_table_title(c, work_table):
 global base_index
 global info_index
 c.execute('DROP TABLE IF EXISTS ' + work_table);
 c.execute('CREATE TABLE ' + work_table + ' 
 (Product TEXT NOT NULL, 
 Version TEXT NOT NULL, 
 Imei TEXT NOT NULL, 
 Date TEXT NOT NULL, 
 Eventid TEXT NOT NULL, 
 HappenTime TEXT NOT NULL, 
 FIELDNAME TEXT NOT NULL, 
 CASENAME TEXT NOT NULL)');
 return