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