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