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()
print "Done! delete old strategy on client_id: %s " % owner_value
sys.exit()
owner_type = args.owner_type
for_test_msg = args.for_test_msg
flag = selectstg(domainkey, owner_value)
if(flag):
deloldstg(domainkey, owner_value)
if args.resource_ids:
rids = args.resource_ids
rinfos = getresource(rids)
for rinfo in rinfos:
server_id = rinfo['server_id']
server_ip = getServerIp(rinfo['server_id'])
resource_ids = rinfo['rids']
init_group_size = rinfo['count']
try:
resource_conn = mdb.get_resource_conn()
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)
print "Done! Add a new strategy at client_id: %s on %s " % (owner_value, domainkey)
except Exception,e:
print e
sys.exit()
elif args.load_id:
load_id = args.load_id
load_array = getLoadInfo(load_id)
for load_list in load_array:
try: