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