python调用sql_python执行sql语句

dbname = 'db.sqlite3'

dbpath = 'D:\\pyweb\\sf\\db.sqlite3'csvpath=pspath#custom thread number

tnum = 20hvsrvs_all=hvsrvs.objects.all()

serverips=[]#ls = []

for hvsrv inhvsrvs_all:

Phy_ServerIP=hvsrv.serverip

serverips.append(Phy_ServerIP)for ips inlstg(tnum,serverips):

threads=[]for Phy_ServerIP inips:#print Phy_ServerIP

t = threading.Thread(target=GetVMs,args=(PS_GetVMs,Phy_ServerIP))

t.setDaemon(True)

t.start()

threads.append(t)for t inthreads:

t.join()

sql_insert= '''insert into sinfors_hvvms values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)'''conn=sqlite3.connect(dbpath)

cu=conn.cursor()

datas=[]

i= 1

for csvf inos.listdir(csvpath):if os.path.splitext(csvf)[0].startswith('queryresult-') and os.path.splitext(csvf)[1] == '.csv':

csvfile=os.path.join(csvpath,csvf)#print csvfile

cf =open(csvfile)

cf.readline()for l incsv.reader(cf):

l.insert(0,i)

i=i+1datas.append(tuple(l))

cf.close()#print csvfile

os.remove(csvfile)#print datas

if len(datas) >0:

cu.execute('delete from sinfors_hvvms')

conn.commit()for data indatas:

cu.execute(sql_insert,data)

conn.commit()

cu.execute('select * from sinfors_hvvms')

cu.close()