def insert_data(userid, postid, kind):
'''
Inert new record.
'''
uid = tools.get_uuid()
TabLog.create(uid=uid,
post_id=postid,
user_id=userid,
kind=kind,
time_create=tools.timestamp())
return uid
def add(data_dic):
'''
Insert new record.
'''
uid = tools.get_uuid()
TabLog.create(uid=uid,
current_url=data_dic['url'],
refer_url=data_dic['refer'],
user_id=data_dic['user_id'],
time_create=data_dic['timein'],
time_out=data_dic['timeOut'],
time=data_dic['timeon'])
return uid
def query_all_user():
'''
查询所有登录用户的访问记录
'''
return TabLog.select().where(TabLog.user_id != 'None').distinct(TabLog.user_id).order_by(
TabLog.user_id
)
def query_all_pageview(current_page_num=1):
'''
查询所有页面（current_url），分页
'''
return TabLog.select().distinct(TabLog.current_url).order_by(TabLog.current_url).paginate(
current_page_num, CMS_CFG['list_num']
)
def query_pager_by_user(userid, current_page_num=1):
'''
Query pager
'''
return TabLog.select().where(TabLog.user_id == userid).order_by(
TabLog.time_create.desc()).paginate(current_page_num,
CMS_CFG['list_num'])
def query_all(current_page_num=1):
'''
查询所有未登录用户的访问记录
'''
return TabLog.select().where(TabLog.user_id == 'None').order_by(TabLog.time_out.desc()).paginate(
current_page_num, CMS_CFG['list_num']
)
def get_retention_time_by_id(uid, user_id):
current_rec = MLog.get_by_uid(uid)
recs = TabLog.select().where((TabLog.user_id == user_id) & (
TabLog.time_create > current_rec.time_create)).order_by(
TabLog.time_create)
if recs.count():
return recs.get()
return None
def query_all_current_url():
'''
查询所有页面（current_url）
'''
return TabLog.select().distinct(TabLog.current_url).order_by(TabLog.current_url)
def total_number():
'''
Return the number of certian slug.
'''
return TabLog.select().count()
def count_of_certain(user_id):
recs = TabLog.select().where(TabLog.user_id == user_id)
return recs.count()
def total_number():
'''
Return the number of Tablog.
'''
# adding ``None`` to hide ``No value for argument 'database' in method call``
return TabLog.select().count(None)
def query_all_user(current_page_num=1):
'''
Query pager
'''
return TabLog.select().distinct(TabLog.user_id).order_by(
TabLog.user_id).paginate(current_page_num, CMS_CFG['list_num'])
def count_of_certain_pageview():
recs = TabLog.select().distinct(TabLog.current_url).order_by(TabLog.current_url)
return recs.count()
def total_number():
'''
Return the number of Tablog.
'''
return TabLog.select().count()
def count_of_current_url(current_url):
'''
长询制订页面（current_url）的访问量
'''
res = TabLog.select().where(TabLog.current_url == current_url)
return res.count()
def get_all(num=200):
'''
查询近期访问记录
'''
return TabLog.select().order_by(TabLog.time_create.desc()).limit(num)
def get_pageview_count(current_url):
recs = TabLog.select().where(TabLog.current_url == current_url)
return recs.count()
