def add_meta(uid, data_dic):
if len(uid) < 4:
return False
userip = data_dic['userip'].strip()
if len(userip) < 2:
return False
TabReferrer.create(
uid=uid,
media=data_dic['media'],
terminal=data_dic['terminal'],
userip=userip,
# usercity=data_dic['usercity'],
kind=data_dic['kind'],
time_create=tools.timestamp(),
time_update=tools.timestamp(),
)
return uid
def modify_meta(uid, data_dic):
userip = data_dic['userip'].strip()
if len(userip) < 2:
return False
cur_info = MReferrer.get_by_uid(uid)
if cur_info:
entry = TabReferrer.update(
uid=uid,
media=data_dic['media'],
terminal=data_dic['terminal'],
userip=userip,
# usercity=data_dic['usercity'],
kind=data_dic['kind'],
time_update=tools.timestamp(),
).where(TabReferrer.uid == uid)
entry.execute()
else:
return MReferrer.add_meta(uid, data_dic)
return uid
def get_by_userip(userip):
recs = TabReferrer.select().where(TabReferrer.userip == userip)
return recs
def query_all():
'''
query all the posts.
'''
return TabReferrer.select()