python写入oracle数据库_python向oracle插入数据

#encoding:utf-8

import pymongo

#import thread

connection=pymongo.Connection('192.168.85.76',27017)

#选择WikiAnswer库

db=connection.WikiAnswer

def insert_user(start,end,status,closetime): # insert_user(10000,20000,1,"")-10个数据

print ("开始插入数据")

print ("................")

for i in range(start,end):

user ={"BrandName":"动感地带",

"CityName":"大同",

"CloseTime":closetime,

"IsDump":"0",

"NetType":"",

"NetTypeId":"",

"RegisterTime":"2014-07-3015:01:24",

"Status":str(status),

"UserTelNo":"130030"+str(i),

"WeiTionNo":str(i),

"Channel":"微信渠道"

}

#print (i)

db.UserWeitionInfo.insert(user) #表UserWeitionInfo 插入微信绑定信息

print ("插入数据结束")

def insert_bizop(start,end,result,bizname,operationname,bizoptime): #

print ("开始插入数据")

print ("................")

for i in r