def init(): #init log logging.basicConfig(level=logging.DEBUG, format='%(asctime)s %(filename)s[line:%(lineno)d] %(levelname)s %(message)s', datefmt='%Y-%m-%d %H:%M:%S ', filename='../log/charge_python.log', filemode='a') #init conf global g_conf global g_mysql g_conf=ConfigParser.ConfigParser() g_conf.read("../conf/charge_python.conf") g_mysql=mysql_db() db_name=g_conf.get("db","db_name") host=g_conf.get("db","host") user_name=g_conf.get("db","user_name") passwd=g_conf.get("db","passwd") port_num=int(g_conf.get("db","port_num")) ret=g_mysql.establish_connection(host,user_name,passwd,port_num) if ret!=0: logging.warning("connect to db failed") return -1 global g_ad_dict g_ad_dict={} ad_file=g_conf.get('file','ad_file') fp=open(ad_file,"r") line_cnt=0 for line in fp: line_cnt+=1 line=line.rstrip("\r\n").split("\t") if line_cnt==1: continue idea_id=line[0] unit_id=line[1] account_id=line[3] g_ad_dict[idea_id]=[unit_id,account_id] fp.close() global g_ad_profit_dict g_ad_profit_dict={} ad_profit_file=g_conf.get('file','ad_profit') fp=open(ad_profit_file,"r") line_cnt=0 for line in fp: line_cnt+=1 line=line.rstrip("\r\n").split("\t") if line_cnt==1: continue unit_id=line[0] profit=float(line[2]) g_ad_profit_dict[unit_id]=profit fp.close() return 0
def refresh(self): self.query("show databases") result = self.handle.store_result() old = dict(self.databases) db_id = len(old) for row in result.fetch_row(0): if not row[0] in old: self.databases[row[0]] = mysql_db(self, row[0]) else: del old[row[0]] for db in old.keys(): print "remove database", db del self.databases[db]
def init(): #init log logging.basicConfig( level=logging.DEBUG, format= '%(asctime)s %(filename)s[line:%(lineno)d] %(levelname)s %(message)s', datefmt='%Y-%m-%d %H:%M:%S ', filename='../log/monitor.log', filemode='a') #init conf global g_conf global g_mysql global g_idea_dict g_idea_dict = {} g_conf = ConfigParser.ConfigParser() g_conf.read("../conf/monitor.conf") g_mysql = mysql_db() db_name = g_conf.get("db", "db_name") host = g_conf.get("db", "host") user_name = g_conf.get("db", "user_name") passwd = g_conf.get("db", "passwd") port_num = int(g_conf.get("db", "port_num")) ret = g_mysql.establish_connection(host, user_name, passwd, port_num) if ret != 0: logging.warning("connect to db failed") return -1 #init db #init idea dict idea_file = g_conf.get("file", "idea_file") line_cnt = 0 header_dict = {} fp = open(idea_file, "r") print idea_file for line in fp: line_cnt += 1 line = line.rstrip("\r\n").split("\t") if line_cnt == 1: for i in range(0, len(line)): name = line[i] header_dict[name] = i continue idea_id = line[0] lp_idx = header_dict['landingpage'] lp = line[lp_idx] g_idea_dict[idea_id] = lp fp.close() return 0
def init(): #init log logging.basicConfig(level=logging.DEBUG, format='%(asctime)s %(filename)s[line:%(lineno)d] %(levelname)s %(message)s', datefmt='%Y-%m-%d %H:%M:%S ', filename='../log/monitor.log', filemode='a') #init conf global g_conf global g_mysql global g_idea_dict g_idea_dict={} g_conf=ConfigParser.ConfigParser() g_conf.read("../conf/monitor.conf") g_mysql=mysql_db() db_name=g_conf.get("db","db_name") host=g_conf.get("db","host") user_name=g_conf.get("db","user_name") passwd=g_conf.get("db","passwd") port_num=int(g_conf.get("db","port_num")) ret=g_mysql.establish_connection(host,user_name,passwd,port_num) if ret!=0: logging.warning("connect to db failed") return -1 #init db #init idea dict idea_file=g_conf.get("file","idea_file") line_cnt=0 header_dict={} fp=open(idea_file,"r") print idea_file for line in fp: line_cnt+=1 line=line.rstrip("\r\n").split("\t") if line_cnt==1: for i in range(0,len(line)): name=line[i] header_dict[name]=i continue idea_id=line[0] lp_idx=header_dict['landingpage'] lp=line[lp_idx] g_idea_dict[idea_id]=lp fp.close() return 0
def init(): logging.basicConfig(level=logging.DEBUG, format='%(asctime)s %(filename)s[line:%(lineno)d] %(levelname)s %(message)s', datefmt='%Y-%m-%d %H:%M:%S ', filename='../log/get_mysql_data.log', filemode='a') #init conf global g_conf global g_mysql g_conf=ConfigParser.ConfigParser() g_conf.read("../conf/charge_python.conf") g_mysql=mysql_db() db_name=g_conf.get("db","db_name") host=g_conf.get("db","host") user_name=g_conf.get("db","user_name") passwd=g_conf.get("db","passwd") port_num=int(g_conf.get("db","port_num")) ret=g_mysql.establish_connection(host,user_name,passwd,port_num) if ret!=0: logging.warning("connect to db failed") return -1