def get_click_set(datetime_start,datetime_end,datetime_delta): act_date = datetime_start while act_date < datetime_end: end_date = min(datetime_end,act_date+datetime_delta); session = clickdb.get_pixel_db_session() andstatement = and_(Click.time_start>=act_date,Click.time_start<end_date) yield session.query(Click).filter(andstatement) act_date = act_date+datetime_delta;
def ClicksWhichCorrespondToSessionsWithOneClick(): sess = clickdb.get_clicksession_db_session() pix_sess = clickdb.get_pixel_db_session() qry = sess.query(ClickSession.firstclick).filter(and_(ClickSession.click_count==1,ClickSession.qualification_certainty==1)).limit(10) for cl in qry: print cl.firstclick cl_qry = pix_sess.query(Click).filter(Click.id==cl.firstclick).first() print cl_qry print "Ref {0} \n Time spent: {1}\n Url: {2}".format(cl_qry.ref,cl_qry.time_spent,cl_qry.url)
def AllClicksFor(vis,pubid): pix_sess = clickdb.get_pixel_db_session() qry = pix_sess.query(Click).filter(and_(Click.visitor==vis,Click.public_id==pubid)).order_by(Click.time_start) print "All clicks for {0} {1} ==================================".format(vis,pubid) for click in qry: print click