def old_to_new(vip_request):
from networkapi.ambiente.models import EnvironmentVip
from networkapi.api_vip_request.models import VipRequest, VipRequestDSCP, VipRequestOptionVip, \
VipRequestPort, VipRequestPortOptionVip, VipRequestPortPool
from networkapi.requisicaovips.models import DsrL3_to_Vip, OptionVip, OptionVipEnvironmentVip, \
VipPortToPool
mp = vip_request.variables_to_map()
try:
try:
ev = EnvironmentVip().get_by_values(
mp['finalidade'], mp['cliente'], mp['ambiente'])
except:
ev = EnvironmentVip()
ev.finalidade_txt = mp['finalidade']
ev.cliente_txt = mp['cliente']
ev.ambiente_p44_txt = mp['ambiente']
ev.description = '%s - %s - %s' % (
mp['finalidade'], mp['cliente'], mp['ambiente'])
ev.save()
finally:
vp = VipRequest()
vp.environmentvip = ev
vp.id = vip_request.id
vp.name = mp['host'] if mp.get('host') else None
vp.business = mp['areanegocio'] if mp.get(
'areanegocio') else vp.name
vp.service = mp['nome_servico'] if mp.get(
'nome_servico') else vp.name
vp.ipv4 = vip_request.ip if vip_request.ip else None
vp.ipv6 = vip_request.ipv6 if vip_request.ipv6 else None
vp.created = vip_request.vip_criado
vp.save()
if mp.get('persistencia'):
persistencia = mp['persistencia']
else:
persistencia = '(nenhum)'
try:
op_per = OptionVip.objects.filter(
tipo_opcao=u'Persistencia',
nome_opcao_txt=persistencia)[0]
try:
opv = OptionVipEnvironmentVip.objects.get(
option=op_per,
environment=ev)
except:
opv = OptionVipEnvironmentVip()
opv.option = op_per
opv.environment = ev
opv.save()
except:
op_per = OptionVip()
op_per.tipo_opcao = u'Persistencia'
op_per.nome_opcao_txt = persistencia
op_per.save()
opv = OptionVipEnvironmentVip()
opv.option = op_per
opv.environment = ev
opv.save()
finally:
try:
vro = VipRequestOptionVip.objects.get(
optionvip=op_per,
vip_request=vp)
except:
vro = VipRequestOptionVip()
vro.optionvip = op_per
vro.vip_request = vp
vro.save()
if mp.get('timeout'):
timeout = mp['timeout']
else:
timeout = '5'
try:
op_time = OptionVip.objects.filter(
tipo_opcao=u'timeout',
nome_opcao_txt=timeout)[0]
try:
opv = OptionVipEnvironmentVip.objects.get(
option=op_time,
environment=ev)
except:
opv = OptionVipEnvironmentVip()
opv.option = op_time
opv.environment = ev
opv.save()
except:
op_time = OptionVip()
op_time.tipo_opcao = u'timeout'
op_time.nome_opcao_txt = timeout
op_time.save()
opv = OptionVipEnvironmentVip()
opv.option = op_time
opv.environment = ev
opv.save()
finally:
try:
vro = VipRequestOptionVip.objects.get(
optionvip=op_time,
vip_request=vp)
except:
vro = VipRequestOptionVip()
vro.optionvip = op_time
vro.vip_request = vp
vro.save()
if mp.get('trafficreturn'):
trafficreturn = mp['trafficreturn']
else:
trafficreturn = 12
try:
op_traffic = OptionVip.objects.filter(
tipo_opcao=u'Retorno de trafego',
id=trafficreturn)[0]
try:
opv = OptionVipEnvironmentVip.objects.get(
option=op_traffic,
environment=ev)
except:
opv = OptionVipEnvironmentVip()
opv.option = op_traffic
opv.environment = ev
opv.save()
except:
op_traffic = OptionVip()
op_traffic.tipo_opcao = u'Retorno de trafego'
op_traffic.nome_opcao_txt = trafficreturn
op_traffic.save()
opv = OptionVipEnvironmentVip()
opv.option = op_traffic
opv.environment = ev
opv.save()
finally:
try:
vro = VipRequestOptionVip.objects.get(
optionvip=op_traffic,
vip_request=vp)
except:
vro = VipRequestOptionVip()
vro.optionvip = op_traffic
vro.vip_request = vp
vro.save()
if int(trafficreturn) == 48:
dsrl3 = DsrL3_to_Vip.get_by_vip_id(vip_request.id)
try:
vp_dsrl3 = VipRequestDSCP.objects.get(vip_request=vp)
except:
vp_dsrl3 = VipRequestDSCP()
vp_dsrl3.vip_request = vp
vp_dsrl3.dscp = dsrl3.id_dsrl3
vp_dsrl3.save()
else:
try:
vp_dsrl3 = VipRequestDSCP.objects.get(vip_request=vp)
vp_dsrl3.delete()
except:
pass
if mp.get('cache'):
cache = mp['cache']
else:
cache = '(nenhum)'
try:
op_cache = OptionVip.objects.filter(
tipo_opcao=u'cache',
nome_opcao_txt=cache)[0]
try:
opv = OptionVipEnvironmentVip.objects.get(
option=op_cache,
environment=ev)
except:
opv = OptionVipEnvironmentVip()
opv.option = op_cache
opv.environment = ev
opv.save()
except:
op_cache = OptionVip()
op_cache.tipo_opcao = u'cache'
op_cache.nome_opcao_txt = cache
op_cache.save()
opv = OptionVipEnvironmentVip()
opv.option = op_cache
opv.environment = ev
opv.save()
finally:
try:
vro = VipRequestOptionVip.objects.get(
optionvip=op_cache,
vip_request=vp)
except:
vro = VipRequestOptionVip()
vro.optionvip = op_cache
vro.vip_request = vp
vro.save()
# delete optionvip(op_cache, op_traffic, op_time, op_per)
# in port removed in old table
VipRequestOptionVip.objects.filter(
vip_request=vp
).exclude(
optionvip__id__in=[op_cache.id, op_traffic.id,
op_time.id, op_per.id]
).delete()
pools = VipPortToPool.get_by_vip_id(vip_request.id)
# delete old ports
ports_current = VipRequestPort.objects.filter(vip_request=vp)
ports_ids = [port.id for port in ports_current]
pools_ids = [pl.id for pl in pools]
ids_to_del = list(set(ports_ids) - set(pools_ids))
ports_current.filter(id__in=ids_to_del).delete()
# delete pools removed in old table
# ptid = [ptid.server_pool.id for ptid in pools]
# VipRequestPortPool.objects.filter(
# vip_request_port=vrp
# ).exclude(
# server_pool__id__in=ptid
# ).delete()
for pool in pools:
# saving ports of vip
vrp = VipRequestPort()
vrp.id = pool.id
vrp.vip_request = vp
vrp.port = pool.port_vip
if not pool.identifier:
from networkapi.api_equipment import facade as facade_eqpt
from networkapi.plugins.factory import PluginFactory
eqpts = facade_eqpt.get_eqpt_by_envvip(ev.id)
if eqpts:
plugin = PluginFactory.factory(eqpts[0])
vrp.identifier = plugin.get_name_eqpt(
vp, pool.port_vip)
pool.identifier = vrp.identifier
pool.save()
vrp.save()
# descobre protocolo l7 e l4
tipo_opcao = 'l7_rule'
nome_opcao_txt = 'default_vip'
l4_protocol = 'TCP'
l7_protocol = 'Outros'
if mp.get('healthcheck_type') == 'HTTP':
tipo_opcao = 'l7_rule'
nome_opcao_txt = 'default_vip'
l4_protocol = 'TCP'
l7_protocol = 'HTTP'
if mp.get('healthcheck_type') == 'TCP':
l4_protocol = 'TCP'
l7_protocol = 'Outros'
if mp.get('healthcheck_type') == 'UDP':
l4_protocol = 'UDP'
l7_protocol = 'Outros'
if pool.port_vip == 20 or pool.port_vip == 21:
l4_protocol = 'TCP'
l7_protocol = 'FTP'
if pool.port_vip == 443:
l4_protocol = 'TCP'
l7_protocol = 'HTTPS'
# l4_protocol
try:
op_l4 = OptionVip.objects.filter(
tipo_opcao='l4_protocol', nome_opcao_txt=l4_protocol)[0]
try:
opv = OptionVipEnvironmentVip.objects.get(
option=op_l4, environment=ev)
except:
opv = OptionVipEnvironmentVip()
opv.option = op_l4
opv.environment = ev
opv.save()
except:
op_l4 = OptionVip()
op_l4.tipo_opcao = u'l4_protocol'
op_l4.nome_opcao_txt = l4_protocol
op_l4.save()
opv = OptionVipEnvironmentVip()
opv.option = op_l4
opv.environment = ev
opv.save()
finally:
try:
vro = VipRequestPortOptionVip.objects.filter(
optionvip=op_l4, vip_request_port=vrp)[0]
except:
vro = VipRequestPortOptionVip()
vro.optionvip = op_l4
vro.vip_request_port = vrp
vro.save()
# l7_protocol
try:
op_l7 = OptionVip.objects.filter(
tipo_opcao='l7_protocol', nome_opcao_txt=l7_protocol)[0]
try:
opv = OptionVipEnvironmentVip.objects.get(
option=op_l7, environment=ev)
except:
opv = OptionVipEnvironmentVip()
opv.option = op_l7
opv.environment = ev
opv.save()
except:
op_l7 = OptionVip()
op_l7.tipo_opcao = u'l7_protocol'
op_l7.nome_opcao_txt = l7_protocol
op_l7.save()
opv = OptionVipEnvironmentVip()
opv.option = op_l7
opv.environment = ev
opv.save()
finally:
try:
vro = VipRequestPortOptionVip.objects.filter(
optionvip=op_l7, vip_request_port=vrp)[0]
except:
vro = VipRequestPortOptionVip()
vro.optionvip = op_l7
vro.vip_request_port = vrp
vro.save()
# delete optionvip(l7 and l4) in port removed in old table
VipRequestPortOptionVip.objects.filter(
vip_request_port=vrp
).exclude(
optionvip__id__in=[op_l7.id, op_l4.id]
).delete()
# saving pools of port
try:
op_pt = OptionVip.objects.filter(
tipo_opcao=tipo_opcao,
nome_opcao_txt=nome_opcao_txt)[0]
try:
opv = OptionVipEnvironmentVip.objects.get(
option=op_pt,
environment=ev)
except:
opv = OptionVipEnvironmentVip()
opv.option = op_pt
opv.environment = ev
opv.save()
except:
op_pt = OptionVip()
op_pt.tipo_opcao = tipo_opcao
op_pt.nome_opcao_txt = nome_opcao_txt
op_pt.save()
opv = OptionVipEnvironmentVip()
opv.option = op_pt
opv.environment = ev
opv.save()
finally:
try:
vrpp = VipRequestPortPool.objects.filter(
server_pool=pool.server_pool, vip_request_port=vrp)[0]
except:
vrpp = VipRequestPortPool()
vrpp.server_pool = pool.server_pool
vrpp.vip_request_port = vrp
vrpp.optionvip = op_pt
vrpp.save()
except Exception, e:
log.error(e)
raise e