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
