Пример #1
0
def update_stack(stack_id, values):
    if not len(values):
        log.error("update stack not value.")
        return
    sql = u"update stacks set %s where stack_id='%s'" % (enc_values(values),
                                                         stack_id)
    db_manager.execute(sql)
Пример #2
0
def delete_scenario(uuid):
    sql = u"delete from scenarios where uuid='%s'" % uuid
    db_manager.execute(sql)
Пример #3
0
def update_scenario_status(uuid, status):
    sql = u"update scenarios set status='%s' where uuid='%s'" % (status, uuid)
    db_manager.execute(sql)
Пример #4
0
def delete_stack(sid):
    sql = u"update stacks set deleted=1 where stack_id='%s'" % sid
    db_manager.execute(sql)
Пример #5
0
def insert_scenario(uuid, scenario, status):
    sql = u"insert into scenarios(uuid, scenario, status) values ('%s', '%s', '%s')" % (
        uuid, scenario, status)
    db_manager.execute(sql)
Пример #6
0
def insert_lb_vip(uuid, vip, pool_id):
    sql = u"insert into lb_vip(uuid, vip, pool_id) values ('%s', '%s', '%s')" % (
        uuid, vip, pool_id)
    db_manager.execute(sql)
Пример #7
0
def delete_stack(sid):
	sql=u"update stacks set deleted=1 where stack_id='%s'" % sid
	db_manager.execute(sql)
Пример #8
0
def delete_lb_scenario(pool_id):
	sql=u"delete from lb_scenario where pool_id='%s'" % pool_id
	db_manager.execute(sql)
Пример #9
0
def insert_lb_vip(uuid, vip, pool_id):
        sql=u"insert into lb_vip(uuid, vip, pool_id) values ('%s', '%s', '%s')" % (uuid, vip, pool_id)
        db_manager.execute(sql)
Пример #10
0
def delete_scenario(uuid):
	sql=u"delete from scenarios where uuid='%s'" % uuid
	db_manager.execute(sql)
Пример #11
0
def insert_lb_scenario(pool_id, method, protocol, subnet_id, scid):
	sql=u"insert into lb_scenario(pool_id, method, protocol, subnet_id, scid) values ('%s', '%s', '%s', '%s', '%s')" % (pool_id, method, protocol, subnet_id, scid)
	db_manager.execute(sql)
Пример #12
0
def update_scenario_status(uuid, status):
	sql=u"update scenarios set status='%s' where uuid='%s'" % (status, uuid)
	db_manager.execute(sql)
Пример #13
0
def update_stack(stack_id, values):
	if not len(values):
		log.error("update stack not value.")
		return
	sql=u"update stacks set %s where stack_id='%s'" % (enc_values(values), stack_id)
	db_manager.execute(sql)
Пример #14
0
def insert_scenario(uuid, scenario, status):
	sql=u"insert into scenarios(uuid, scenario, status) values ('%s', '%s', '%s')" % (uuid, scenario, status)
	db_manager.execute(sql)
Пример #15
0
def insert_lb_scenario(pool_id, method, protocol, subnet_id, scid):
    sql = u"insert into lb_scenario(pool_id, method, protocol, subnet_id, scid) values ('%s', '%s', '%s', '%s', '%s')" % (
        pool_id, method, protocol, subnet_id, scid)
    db_manager.execute(sql)
Пример #16
0
def delete_lb_vip(pool_id):
        sql=u"delete from lb_vip where pool_id='%s'" % pool_id
        db_manager.execute(sql)
Пример #17
0
def delete_lb_scenario(pool_id):
    sql = u"delete from lb_scenario where pool_id='%s'" % pool_id
    db_manager.execute(sql)
Пример #18
0
def insert_stack(scid, stack_id, ip, netns, manager, host):
    sql = u"insert into stacks(scid, stack_id, ip, netns, manager, host) values ('%s', '%s', '%s', '%s', '%s', '%s')" % (
        scid, stack_id, ip, netns, manager, host)
    db_manager.execute(sql)
Пример #19
0
def delete_lb_vip(pool_id):
    sql = u"delete from lb_vip where pool_id='%s'" % pool_id
    db_manager.execute(sql)
Пример #20
0
def insert_stack(scid, stack_id, ip, netns, manager, host):
        sql=u"insert into stacks(scid, stack_id, ip, netns, manager, host) values ('%s', '%s', '%s', '%s', '%s', '%s')" % (scid, stack_id, ip, netns, manager, host)
	db_manager.execute(sql)