def get_analyse(branch_id, client_id, message_ids, domain):
stat_sql = '''
select
'%s' as message_id, h.real_from,h.from_ip,h.to_ip,h.error,count(0) as count
from
msg_%s_%s_h h
where
h.domain_name = '%s' and h.return_type_id = 2
group by
h.error,h.to_ip
order by
count desc
limit 15
'''
bounce_conn = mdb.get_bounce_conn(client_id);
display = [];
messages = message_ids.split(',')
for message in messages:
domain_stat = mdb.exe_sql(bounce_conn, stat_sql % (message, client_id, message, domain), True);
display.extend(domain_stat);
mdb.close_conn(bounce_conn);
return display;
def get_analyse(branch_id, client_id, message_ids, domain, group = False):
stat_sql = '''
select
'%s' as message_id, DATE_FORMAT(h.begin_time, '%%Y-%%m-%%d %%H:%%i') as begin_time, substring(h.real_from,instr(h.real_from,'@')+1) as real_from, h.from_ip, h.from_inner_ip, h.to_ip, h.error, count(0) as count
from
msg_%s_%s_h h
where
h.domain_name = '%s' and h.return_type_id = 2
'''
if(group):
stat_sql += '''group by %s''' % (group)
else:
stat_sql += '''group by h.error '''
stat_sql += '''order by count desc limit 20'''
bounce_conn = mdb.get_bounce_conn(client_id);
display = [];
messages = message_ids.split(',')
for message in messages:
domain_stat = mdb.exe_sql(bounce_conn, stat_sql % (message, client_id, message, domain), True);
display.extend(domain_stat);
mdb.close_conn(bounce_conn);
return display;
def updateToHard(cid, mid, limit_num):
sql = '''
update
msg_%s_%s_h h
set
h.return_type_id= 2, h.error_type_id = 204
where
h.return_type_id = 1
limit %s
'''
bounce_conn = mdb.get_bounce_conn(cid)
row_info = mdb.exe_update_sql(bounce_conn, sql % (cid, mid, limit_num), False, True, False, False)
print row_info
def updateBounce(cid, mid, last_rt_id, limit_num):
sql = '''
update
msg_%s_%s_u u
set
u.last_rt_id = 1, u.last_et_id = -1
where
u.last_rt_id = %s
limit %s
'''
bounce_conn = mdb.get_bounce_conn(cid)
row_info = mdb.exe_update_sql(bounce_conn, sql % (cid, mid, last_rt_id, limit_num), False, True, False, False)
print row_info
