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)
