def pauseMessage(mid):
update_sql = '''
update
email_package ep
set
ep.task_status_id = 5
where
ep.task_status_id = 0 and ep.object_id = %s
'''
carrier_conn = mdb.get_mesher_conn()
mdb.exe_update_sql(carrier_conn, update_sql % (mid), False, True, False, False)
def insertnewstg(cid, load_id):
insert_load_sql = '''
INSERT INTO `strategy`
(`server_id`, `server_ip`, `domain_key`, `resource_ids`, `owner_type`, `owner_value`, `for_test_msg`, `switch_type`, `switch_value`, `init_group_size`, `min_group_size`, `last_update_time`, `from_domains`, `remark`)
VALUES
('%s', '%s', 'qqdomain', '%s', '%s', '%s', 0, 'ByGroup', 12, %s, 1, '2013-03-22 16:28:00', NULL, NULL);
'''
if int(cid) < 3000:
owner_type = 'Branch'
else:
owner_type = 'Client'
#load_array = load[load_id]
load_array = getLoadInfo(load_id)
#print load_array
#print insert_load_sql % (load_list[0], load_list[1], load_list[2], owner_type, cid, load_list[3])
for load_list in load_array:
try:
#print load_list
resource_conn = mdb.get_resource_conn()
load_list['server_ip'] = getServerIp(load_list['server_id'])
#print insert_load_sql % (load_list['server_id'], load_list['server_ip'], load_list['rids'], owner_type, cid, load_list['count'])
row_info = mdb.exe_update_sql(resource_conn, insert_load_sql % (load_list['server_id'], load_list['server_ip'], load_list['rids'], owner_type, cid, load_list['count']), False, True, False, False)
print row_info
except Exception,e:
print e
sys.exit()
def updateresource(src,tag):
sql = '''
update resource rc set rc.domains = replace(domains, '%s', '%s') where rc.id in (%s)
'''
resource_conn = mdb.get_resource_conn()
row_info = mdb.exe_update_sql(resource_conn, sql % (src, tag, resource_ids), False, True, False, False)
print row_info
def deloldstg(cid):
sql = " delete from strategy where domain_key = 'qqdomain' and owner_value = %s "
try:
resource_conn = mdb.get_resource_conn()
row_info = mdb.exe_update_sql(resource_conn, sql % (cid), False, True, False, False)
print row_info
except Exception,e:
print e
sys.exit()
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
def insertnewstg(server_id, server_ip, domainkey, resource_ids, owner_type, owner_value, for_test_msg, switch_type, switch_value, init_group_size, min_group_size):
insert_load_sql = '''
INSERT INTO `strategy`
(`server_id`, `server_ip`, `domain_key`, `resource_ids`, `owner_type`, `owner_value`, `for_test_msg`, `switch_type`, `switch_value`, `init_group_size`, `min_group_size`, `last_update_time`, `from_domains`, `remark`)
VALUES
('%s', '%s', '%s', '%s', '%s', %s, %s, '%s', %s, %s, %s, '2015-03-22 16:28:00', NULL, NULL);
'''
try:
resource_conn = mdb.get_resource_conn()
#print insert_load_sql % (server_id, server_ip, domainkey, resource_ids, owner_type, owner_value, for_test_msg, switch_type, switch_value, init_group_size, min_group_size)
row_info = mdb.exe_update_sql(resource_conn, insert_load_sql % (server_id, server_ip, domainkey, resource_ids, owner_type, owner_value, for_test_msg, switch_type, switch_value, init_group_size, min_group_size), False, True, False, False)
print row_info
except Exception,e:
print e
sys.exit()
def updatemsgpri(mid):
update_sql = '''
update
email_package ep
set
ep.priority = 1
where
ep.task_status_id = 0 and ep.object_id = %s
'''
try:
carrier_conn = mdb.get_mesher_conn()
row_info = mdb.exe_update_sql(carrier_conn, update_sql % (mid), False, True, False, False)
print row_info
except Exception,e:
print e
sys.exit()
