finalAmout = jsonOne.get('finalAmout')
nickName = jsonOne.get('nickName')
tradeMethod = jsonOne.get('tradeMethod')
ucodeId = jsonOne.get('ucodeId')
userId = jsonOne.get('userId')
sql = 'insert into RRDXinPlanInvest (amount,createTime,finalAmout,nickName,tradeMethod,ucodeId,userId,planId) values ("' + amount + '","' + createTime + '","' + finalAmout + '","' + nickName + '","' + tradeMethod + '","' + ucodeId + '","' + userId + '","' + planId + '")'
cur.execute(sql)
conn.commit()
conn, cur = DatabaseUtil().getConn()
session = SessionUtil()
logUtil = LogUtil("xinPlanInvest.log")
cur.execute('select planId from RRDXinPlanList order by planId')
data = cur.fetchall()
for i in range(0, len(data)):
planId = str(data[i].get('planId'))
url = 'https://www.renrendai.com/autoinvestplan/listPlan!getAutoInvestPlanBuyerRecords.action?autoInvestPlanId=' + planId + '&_=' + str(
int(time.time()))
logUtil.warning(planId)
try:
data = session.getReq(url)
investList = handleData(data)
if len(investList) > 0:
for j in range(len(investList)):
dictObject = DictUtil(investList[j])
storeData(dictObject, conn, cur, planId)
except Exception, e:
logUtil.warning(traceback.print_exc())
cur.close()
conn.close
createTime = jsonOne.get('createTime')
finalAmout = jsonOne.get('finalAmout')
nickName = jsonOne.get('nickName')
tradeMethod = jsonOne.get('tradeMethod')
ucodeId = jsonOne.get('ucodeId')
userId = jsonOne.get('userId')
sql = 'insert into RRDPlanInvest (amount,createTime,finalAmout,nickName,tradeMethod,ucodeId,userId,planId) values ("' + amount + '","' + createTime + '","' + finalAmout + '","' + nickName + '","' + tradeMethod + '","' + ucodeId + '","' + userId + '","' + planId + '")'
cur.execute(sql)
conn.commit()
conn, cur = DatabaseUtil().getConn()
session = SessionUtil()
logUtil = LogUtil("planInvest.log")
for i in range(1, 13387):
time.sleep(1)
url = 'https://www.renrendai.com/financeplan/getFinancePlanLenders.action?financePlanStr=' + str(
i) + '&_=' + str(int(time.time()))
logUtil.warning(str(i))
try:
data = session.getReq(url)
investList = handleData(data)
if len(investList) > 0:
for j in range(len(investList)):
dictObject = DictUtil(investList[j])
storeData(dictObject, conn, cur, str(i))
except Exception, e:
logUtil.warning(traceback.print_exc())
cur.close()
conn.close
