def __init__(self, msgh, config): CalcManager.__init__(self, msgh) self.report_fd = None self.config = config self.stat_user = StatUser(config['start'], config['end']) self.rpt_print_intvl = 40 self.category_count = {1001: 0, # play 1002: 0, # zongyi 1003: 0, 1004: 0, # movie 1005: 0, # catoon 1006: 0, 1007: 0, # sport 1008: 0, 1009: 0, 1010: 0, 1011: 0, 1012: 0, # child 1013: 0, 1014: 0, 1015: 0, 1016: 0, 1017: 0, 1100: 0 } self.country_count = {} #self.eh.register_timer(self.rpt_print_intvl * 1000, # TMTAGS.PRINT_REPORT, True) self.db = Mydb() self.db.connect('report')
def _print_report(self): echo("going to generate report file") echo("generating the count data for every seconds") db = Mydb() db.connect('report') dbname = "freq_trends_" + dbname_dict[api] dbsession = db.open(dbname) d = {'timestamp': "", 'count': ''} for ts, count in self.data.items(): d['timestamp'] = ts d['count'] = count self._mark_top(ts, count) dbsession.insert(d) dbsession.commit() dbsession.close() echo("generating the top count data for earch day") db.connect('report') dbname = "freq_tops_" + dbname_dict[api] dbsession = db.open(dbname) for ts, count in self.top_data.items(): d['timestamp'] = ts d['count'] = count dbsession.insert(d) dbsession.commit() dbsession.close()
def __init__(self, msgh, config): CalcManager.__init__(self, msgh) self.report_fd = None self.collectors = {} self.config = config self.stat_user = StatUser(config['start'], config['end']) self.rpt_print_intvl = 40 #self.eh.register_timer(self.rpt_print_intvl * 1000, # TMTAGS.PRINT_REPORT, True) self.db = Mydb() self.db.connect('report')
def __init__(self, msgh, config): CalcManager.__init__(self, msgh) self.report_fd = None self.collectors = {} self.config = config self.db = Mydb() self.db.connect('report') dbname = "freq_trends_" + dbname_dict[api] self.dbsession = self.db.open(dbname) self.data = {} self.trends_data = {} self.top_data = {}
def __init__(self, msgh, config): CalcManager.__init__(self, msgh) self.report_fd = None self.collectors = {} self.config = config self.stat_user = StatUser(config['start'], config['end']) self.analysis_time = StatTime(config['start_analysis'], config['end_analysis']) self.rpt_print_intvl = 40 self.commit_intvl = 30 self.eh.register_timer(self.commit_intvl * 1000, TMTAGS.DB_COMMIT, True) self.db = Mydb() self.db.connect('repository') self.dbsession = self.db.open('all_users')
#!/usr/bin/env python from core.mydb import Mydb db = Mydb() db.connect('repository') session = db.open("all_medias") entries = session.select("*") for key, values in entries: print "--title--", values[0], values[1], values[2]
#!/usr/bin/env python # -*- coding: utf-8 -*- import urllib2 import json import time from core.mydb import Mydb detail_page_url = "http://api.vod.jamdeocloud.com/medias/api/media/{0}" # medias database medias_db = Mydb() medias_db.connect('repository') medias_db_session = medias_db.open("all_medias") class VodMedia(): def __init__(self, mediaid): self.id = mediaid self.data = None self.title = 'anonymous' self.category_id = None self.country = 'None' self._fill() def _fill_with_local(self): media = medias_db_session.select({"mediaid": self.id}) if media is None: return False self.title = media[1][1] self.category_id = media[1][2] self.country = media[1][3]