def execute(self): date2 = datetime.datetime.now()-datetime.timedelta(days=2) date1 = date2 - datetime.timedelta(days=1) cursor = mysql_conn.cursor() cursor.execute('select count(0) from dish where create_time>"%s" \ and create_time<"%s" and status="A" and recipe_id>1000000' % (date1, date2)) local = cursor.fetchone()[0] cursor.execute('select count(0) from dish where create_time>"%s" \ and create_time<"%s" and status="A" and recipe_id<1000000' % (date1, date2)) foreign = cursor.fetchone()[0] print "dish_follow_local_recipes.value %s" % local print "dish_follow_foreign_recipes.value %s" % foreign print "dish_follow_total.value %s" % (foreign + local) # for realtime today = datetime.datetime.now() yesterday = today - datetime.timedelta(days=1) cursor.execute('select count(0) from dish where create_time>"%s" \ and create_time<"%s" and status="A"' % (yesterday, today)) total = cursor.fetchone()[0] print "dish_follow_total_realtime.value %s" % (total)
def execute(self): date2 = datetime.datetime.now()-datetime.timedelta(days=2) date1 = date2 - datetime.timedelta(days=1) cursor = mysql_conn.cursor() total = cursor.execute('select count(0) from user_auth where time>"%s" and time<"%s"' % (date1, date2)) total = cursor.fetchone()[0] cursor.execute('select count(0) from user_oauth2 where create_time>"%s"\ and create_time<"%s" and service_provider=0' % (date1, date2)) douban = cursor.fetchone()[0] cursor.execute('select count(0) from user_oauth2 where create_time>"%s"\ and create_time<"%s" and service_provider=1' % (date1, date2)) weibo = cursor.fetchone()[0] cursor.execute('select count(0) from user_oauth2 where create_time>"%s"\ and create_time<"%s" and service_provider=3' % (date1, date2)) qq = cursor.fetchone()[0] print "user_auth_total.value %s" % total print "user_auth_douban.value %s" % douban print "user_auth_weibo.value %s" % weibo print "user_auth_QQ.value %s" % qq
def execute(self): date2 = datetime.datetime.now()-datetime.timedelta(days=2) date1 = date2 - datetime.timedelta(days=1) cursor = mysql_conn.cursor() cursor.execute('select count(0) from collect where create_time>"%s" and create_time<"%s"' % (date1, date2)) collects = cursor.fetchone()[0] print "recipe_collect_total.value %s" % collects
def execute(self): date2 = datetime.datetime.now()-datetime.timedelta(days=2) date1 = date2 - datetime.timedelta(days=1) cursor = mysql_conn.cursor() cursor.execute('select count(0) from event where create_time>"%s" \ and create_time<"%s"' % (date1, date2)) event = cursor.fetchone()[0] cursor.execute('select count(0) from event_target where create_time>"%s" \ and create_time<"%s"' % (date1, date2)) event_item = cursor.fetchone()[0] print "event_total.value %s" % event print "event_item_total.value %s" % event_item
def execute(self): date2 = datetime.datetime.now()-datetime.timedelta(days=2) date1 = date2 - datetime.timedelta(days=1) cursor = mysql_conn.cursor() cursor.execute('select count(0) from follow where create_time>"%s" and create_time<"%s"' % (date1, date2)) follows = cursor.fetchone()[0] cursor.execute('select count(distinct(from_id)) from follow where create_time>"%s"\ and create_time<"%s"' % (date1, date2)) following_users = cursor.fetchone()[0] cursor.execute('select count(distinct(to_id)) from follow where create_time>"%s"\ and create_time<"%s"' % (date1, date2)) followed_users = cursor.fetchone()[0] print "follows_total.value %s" % follows print "following_users_total.value %s" % following_users print "followed_users_total.value %s" % followed_users
def execute(self): date2 = datetime.datetime.now()-datetime.timedelta(days=2) date1 = date2 - datetime.timedelta(days=1) cursor = mysql_conn.cursor() cursor.execute('select count(0) from digg where create_time>"%s" \ and create_time<"%s"' % (date1, date2)) diggs = cursor.fetchone()[0] cursor.execute('select count(distinct(user_id)) from digg where create_time>"%s"\ and create_time<"%s"' % (date1, date2)) digging_users = cursor.fetchone()[0] cursor.execute('select count(distinct(dish_id)) from digg where create_time>"%s"\ and create_time<"%s"' % (date1, date2)) digged_dishes = cursor.fetchone()[0] print "diggs_total.value %s" % diggs print "digging_users_total.value %s" % digging_users print "digged_dishes_total.value %s" % digged_dishes
def execute(self): date2 = datetime.datetime.now()-datetime.timedelta(days=2) date1 = date2 - datetime.timedelta(days=1) cursor = mysql_conn.cursor() cursor.execute('select count(0) from recipe_list where create_time>"%s" \ and create_time<"%s" and status="A"' % (date1, date2)) rl = cursor.fetchone()[0] rl_items = cursor.execute('select count(0) from recipe_list_item where time>"%s"\ and time<"%s"' % (date1, date2)) rl_items = cursor.fetchone()[0] print "recipe_list_total.value %s" % rl print "recipe_list_item_total.value %s" % rl_items # for realtime today = datetime.datetime.now() yesterday = today - datetime.timedelta(days=1) cursor.execute('select count(0) from recipe_list where create_time>"%s" and \ create_time<"%s" and status="A"' % (yesterday, today)) total = cursor.fetchone()[0] print "recipe_list_total_realtime.value %s" % (total)