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()
