def addResult(data): conn = None try: conn = sqlite3.connect(DATABASE_PATHNAME) save_sql = """insert into "result" ( "first", "second", "third") values ( ?, ?, ?);""" save(conn, save_sql, data) conn.commit() return True except Exception, e: print 'add result error', e return False
def addResult(data): ''' 在result表中添加数据 ''' conn = None; try: conn = sqlite3.connect(DATABASE_PATHNAME) save_sql = """insert into "result" ( "first", "second", "third") values ( ?, ?, ?);""" save(conn, save_sql, data) conn.commit() return True; except Exception, e: print 'add result error', e print traceback.format_exc(); return False;
def addResult(data): print data ''' 在result表中添加数据 ''' conn = None try: conn = sqlite3.connect(DATABASE_PATHNAME) save_sql = """insert into "result" ( "keyword", "url", "result1", "result2", "result3") values ( ?, ?, ?, ?, ?);""" save(conn, save_sql, data) conn.commit() return True except Exception, e: print 'add result error', e print traceback.format_exc() return False
keywords = [] srcpathname = r"/Users/yangjie/Downloads/qq/prescription_use_method" if srcpathname.endswith("xls") or srcpathname.endswith("xlsx"): tableData = read(srcpathname, "Sheet1") for row in tableData: keywords.append(row[0]) else: f1 = fileUtil.readFile(srcpathname) keywords = f1.split("\r\n") if len(keywords) < 2: keywords = f1.split("\r") if len(keywords) < 2: keywords = f1.split("\n") #上面的代码就是将原始数据转换城一个列表 data = [] save_sql = """insert into "main"."keys" ( "status", "keyword") values ( ?, ?);""" import sqlite3 conn = sqlite3.connect(DBNAME) conn.text_factory = str count = 0 for keyword in keywords: data.append((0, keyword)) if len(data) >= 1000: save(conn, save_sql, data) data = [] count += 1000 print count, r"/", len(keywords) save(conn, save_sql, data)