def record_to_user(sql_user: dict) -> User: user = User() user.pk = sql_user['id'] user.pikabu_id = sql_user['pikabu_id'] user.username = sql_user['username'] user.avatar_url = sql_user['avatar_url'] user.rating = sql_user['rating'] user.comments_count = sql_user['comments_count'] user.posts_count = sql_user['posts_count'] user.hot_posts_count = sql_user['hot_posts_count'] user.pluses_count = sql_user['pluses_count'] user.minuses_count = sql_user['minuses_count'] user.subscribers_count = sql_user['subscribers_count'] user.is_rating_ban = sql_user['is_rating_ban'] user.gender = sql_user['gender'] user.approved = sql_user['approved'] user.awards = sql_user['awards'] user.signup_timestamp = sql_user['signup_timestamp'] user.info = sql_user['info'] user.updating_period = sql_user['updating_period'] user.is_updated = sql_user['is_updated'] user.last_update_timestamp = sql_user['last_update_timestamp'] return user
def getdmuser(): html = StringIO() url = r'%sgetuser'%DMURL print datetime.now() print url c = pycurl.Curl() c.setopt(pycurl.URL, url) c.setopt(pycurl.SSL_VERIFYHOST, False) c.setopt(pycurl.SSL_VERIFYPEER, False) c.setopt(pycurl.WRITEFUNCTION, html.write) c.setopt(pycurl.FOLLOWLOCATION, 1) c.perform() ll = str(html.getvalue()) users = json.loads(ll) for u in users: user = User() p = User_Phone.query.filter(db.or_(User_Phone.phone == u['phone'],User_Phone.phone == u['phone2'])).first() purchases = u['name']+u'于'+u['gmdate']+u' 在 '+u['gmaddress']+u' 购买了大盒'+str(u['gmbigcount'])+u'盒,小盒'+str(u['gmsmallcount'])+u'盒,备注:'+u['remark']+u',电话:'+u['phone']+','+u['phone2']+u',年龄:'+str(u['ages'])+u',性别:'+u['gender']+u',区域:'+u['area'] if p: pass#如果存在,不处理20141224 # user = User.query.get_or_404(p.user_id) # user.operator_id = 1 # user.origin = int(u['origin']) # user.user_type = 5#服务客户 # #user.assign_operator_id = 1 # user.purchases = str(user.purchases)+purchases # user.qxhdm_user_id = u['id'] # user.area = u['area'] # user.pharmacy = u['pharmacy'] # user.promoters = u['promoters'] # user.pharmacystores = u['pharmacystores'] # # user.qxhdm_time = datetime.now().strftime('%Y-%m-%d') # db.session.add(user) # # #分配记录 # assign_log = User_Assign_Log() # assign_log.user_id = user.user_id # assign_log.assign_operator_id = None # assign_log.operator_id = 1 # assign_log.user_type = user.user_type # db.session.add(assign_log) else: user.operator_id = 1 user.origin = int(u['origin']) user.user_type = 5#服务客户 #user.assign_operator_id = 1 user.name = u['name'] user.phone = u['phone'] user.phone2 = u['phone2'] user.gender = u['gender'] user.ages = u['ages'] user.is_new = u['is_new'] user.disease = u['disease'] user.fugou = u['fugou'] user.remark = u['remark'] user.area = u['area'] user.pharmacy = u['pharmacy'] user.promoters = u['promoters'] user.pharmacystores = u['pharmacystores'] user.purchases = purchases user.qxhdm_user_id = u['id'] user.qxhdm_time = datetime.now().strftime('%Y-%m-%d') db.session.add(user) db.session.flush() #分配记录 assign_log = User_Assign_Log() assign_log.user_id = user.user_id assign_log.assign_operator_id = None assign_log.operator_id = 1 assign_log.user_type = user.user_type db.session.add(assign_log) db.session.add(User_Phone.add_phone(user.user_id,user.phone)) if user.phone2: db.session.add(User_Phone.add_phone(user.user_id,user.phone2)) url = r'%supdateuser?id=%s&user_id=%s'%(DMURL,u['id'],user.user_id) print url c = pycurl.Curl() c.setopt(pycurl.URL, url) c.setopt(pycurl.SSL_VERIFYHOST, False) c.setopt(pycurl.SSL_VERIFYPEER, False) c.setopt(pycurl.WRITEFUNCTION, html.write) c.setopt(pycurl.FOLLOWLOCATION, 1) c.perform() db.session.commit()