def main():
nca47_service.prepare_service(sys.argv)
engine = db_api.get_engine()
meta = sa.MetaData()
meta.bind = engine
dns_servers = sa.Table('dns_servers',
meta,
sa.Column('deleted_at',
sa.DateTime(),
nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
sa.Column('id',
sa.String(attr.UUID_LEN),
primary_key=True,
nullable=False),
sa.Column('name',
sa.String(attr.NAME_MAX_LEN),
nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8')
tables = [
dns_servers,
]
for table in tables:
try:
table.create()
except Exception:
LOG.info(repr(table))
LOG.exception(_LE('Exception while creating table.'))
raise
def main():
nca47_service.prepare_service(sys.argv)
launcher = nca47_service.process_launcher()
agentinfo = agent_config.getAgent_config()
server = service.FWService(topic='firewall_manager', agentinfo=agentinfo)
launcher.launch_service(server)
launcher.wait()
def main():
nca47_service.prepare_service(sys.argv)
# Build and start the WSGi app
launcher = nca47_service.process_launcher()
server = service.DNSService(topic='dns_manager')
launcher.launch_service(server, workers=2)
launcher.wait()
def main():
# Parse config file and command line options, then start logging
nca47_service.prepare_service(sys.argv)
# Build and start the WSGi app
launcher = nca47_service.process_launcher()
server = nca47_service.WSGIService('nca47_api', CONF.api.enable_ssl_api)
launcher.launch_service(server, workers=server.workers)
launcher.wait()
def main():
nca47_service.prepare_service(sys.argv)
# Build and start the WSGi app
launcher = nca47_service.process_launcher()
# register agent host informations to agent service
agentinfo = agent_config.getAgent_config()
server = service.DNSService(topic='dns_manager', agentinfo=agentinfo)
launcher.launch_service(server, workers=2)
launcher.wait()
def main():
nca47_service.prepare_service(sys.argv)
engine = db_api.get_engine()
meta = sa.MetaData()
meta.bind = engine
dns_servers = sa.Table('dns_servers', meta,
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.NAME_MAX_LEN), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
tables = [dns_servers, ]
for table in tables:
try:
table.create()
except Exception:
LOG.info(repr(table))
LOG.exception(_LE('Exception while creating table.'))
raise
def wrap_onspace(text, width):
"""
A word-wrap function that preserves existing line breaks
and most spaces in the text. Expects that existing line
breaks are posix newlines (\n).
"""
return reduce(lambda line, word, width=width: '%s%s%s' %
(line, ' \n'[(len(line[line.rfind('\n')+1:]) +
len(word.split('\n', 1)[0]) >= width)], word),
text.split(' '))
if __name__ == '__main__':
nca47_service.prepare_service(sys.argv)
labels = ('id', 'agent_type', 'agent_ip', 'agent_nat_ip', 'status')
agents = objects.Agent(context)
agent_list = agents.get_objects(context)
print agent_list
rows = []
for agent in agent_list:
row = []
row.append(agent.id)
row.append(agent.agent_type)
row.append(agent.agent_ip)
row.append(agent.agent_nat_ip)
is_down = timeutils.is_older_than(agent.update_time,
CONF.agent.agent_down_time)
agent_status = "xxx" if is_down else ':-)'
row.append(agent_status)
def main():
nca47_service.prepare_service(sys.argv)
engine = db_api.get_engine()
meta = sa.MetaData()
meta.bind = engine
dns_servers = sa.Table('dns_servers', meta,
sa.Column('id', sa.String(attr.UUID_LEN),
primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.NAME_MAX_LEN),
nullable=True),
sa.Column('deleted_at', sa.DateTime(),
nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8')
nca_agent_info = sa.Table('nca_agent_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('agent_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('agent_ip', sa.String(attr.IP_LEN), nullable=False),
sa.Column('agent_nat_ip', sa.String(attr.IP_LEN), nullable=True),
sa.Column('dc_name', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('network_zone', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('agent_type', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('availiable', sa.Boolean(), nullable=False),
sa.Column('status', sa.Boolean(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('operation_fro', sa.String(attr.NAME_MAX_LEN),
nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
nca_vres_info = sa.Table('nca_vres_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('vres_id', sa.String(attr.UUID_LEN), unique=True,
nullable=False),
sa.Column('vres_name', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('tenant_id', sa.String(attr.TENANT_ID_MAX_LEN),
nullable=True),
sa.Column('agent_id', sa.String(attr.UUID_LEN), nullable=True),
sa.Column('operation_fro', sa.String(attr.NAME_MAX_LEN),
nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
nca_operation_history = sa.Table('nca_operation_history', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('config_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('input', sa.String(attr.INPUT_MAX_LEN), nullable=False),
sa.Column('operation_type', sa.String(attr.NAME_MAX_LEN),
nullable=True),
sa.Column('operation_time', sa.DateTime(), nullable=True),
sa.Column('operation_status', sa.String(attr.NAME_MAX_LEN),
nullable=True),
sa.Column('operation_fro', sa.String(attr.NAME_MAX_LEN),
nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
dns_zone_info = sa.Table('dns_zone_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('zone_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('tenant_id', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('vres_id', sa.String(attr.UUID_LEN), nullable=True),
sa.Column('zone_name', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('masters', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('slaves', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('default_ttl', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('ad_controller', sa.String(attr.NAME_MAX_LEN),
nullable=True),
sa.Column('renewal', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('owners', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('comment', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('operation_fro', sa.String(attr.NAME_MAX_LEN),
nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
dns_rrs_info = sa.Table('dns_rrs_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('rrs_id', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('zone_id', sa.String(attr.UUID_LEN), nullable=True),
sa.Column('rrs_name', sa.String(attr.NAME_MAX_LEN), nullable=False,
primary_key=True),
sa.Column('type', sa.String(attr.TYPE_LEN), nullable=False,
primary_key=True),
sa.Column('ttl', sa.String(attr.TTL_LEN), nullable=False),
sa.Column('klass', sa.String(attr.TENANT_ID_MAX_LEN), nullable=True),
sa.Column('rdata', sa.String(attr.TENANT_ID_MAX_LEN), nullable=False),
sa.Column('operation_fro', sa.String(attr.NAME_MAX_LEN),
nullable=True),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_vlan_info = sa.Table('fw_vlan_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('vlan_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('ipaddr', sa.String(attr.INPUT_MAX_LEN), nullable=False),
sa.Column('ifnames', sa.String(attr.INPUT_MAX_LEN), nullable=False),
sa.Column('vres_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_vrf_info = sa.Table('fw_vrf_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('vrfInterface', sa.String(attr.INPUT_MAX_LEN),
nullable=False),
sa.Column('vfwname', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('vfw_id', sa.String(attr.UUID_LEN), nullable=True),
sa.Column('vres_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_vfw_info = sa.Table('fw_vfw_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('vfw_name', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('vfw_type', sa.String(attr.STATUS_LEN), nullable=False),
sa.Column('vfw_info', sa.String(attr.INPUT_MAX_LEN), nullable=False),
sa.Column('dc_name', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('network_zone_name',
sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('network_zone_class',
sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('protection_class',
sa.String(attr.STATUS_LEN), nullable=True),
sa.Column('vres_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_security_zone_info = sa.Table('fw_security_zone_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('ifnames', sa.String(attr.INPUT_MAX_LEN), nullable=True),
sa.Column('priority', sa.String(attr.TTL_LEN), nullable=False),
sa.Column('vfwname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('vfw_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_addrobj_info = sa.Table('fw_addrobj_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('ip', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('expip', sa.String(attr.UUID_LEN), nullable=True),
sa.Column('vfwname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('vfw_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_netservices_info = sa.Table('fw_netservices_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('proto', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('port', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('vfwname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('vfw_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_snataddrpool_info = sa.Table('fw_snataddrpool_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('ipstart', sa.String(attr.IP_LEN), nullable=False),
sa.Column('ipend', sa.String(attr.IP_LEN), nullable=False),
sa.Column('slotip', sa.String(attr.STATUS_LEN), nullable=False),
sa.Column('vfwname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('vfw_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_snat_info = sa.Table('fw_snat_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('outifname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('srcipobjname', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('dstipobjname', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('wanippoolname',
sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('vfwname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('vfw_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_dnat_info = sa.Table('fw_dnat_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('inifname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('wanip', sa.String(attr.IP_LEN), nullable=False),
sa.Column('wantcpports', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('wanudpports', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('lanipstart', sa.String(attr.IP_LEN), nullable=False),
sa.Column('lanipend', sa.String(attr.IP_LEN), nullable=False),
sa.Column('lanport', sa.String(attr.TTL_LEN), nullable=False),
sa.Column('slot', sa.String(attr.STATUS_LEN), nullable=False),
sa.Column('vfwname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('vfw_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro',
sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_packetfilter_info = sa.Table('fw_packetfilter_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('srczonename', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('dstzonename', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('srcipobjnames', sa.String(attr.NAME_MAX_LEN),
nullable=True),
sa.Column('dstipobjnames', sa.String(attr.NAME_MAX_LEN),
nullable=True),
sa.Column('servicenames', sa.String(attr.NAME_MAX_LEN), nullable=True),
sa.Column('action', sa.String(attr.STATUS_LEN), nullable=True),
sa.Column('log', sa.String(attr.STATUS_LEN), nullable=True),
sa.Column('vfwname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('vfw_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
fw_staticnat_info = sa.Table('fw_staticnat_info', meta,
sa.Column('id', sa.String(attr.UUID_LEN), primary_key=True,
nullable=False),
sa.Column('name', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('ifname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('lanip', sa.String(attr.IP_LEN), nullable=False),
sa.Column('wanip', sa.String(attr.IP_LEN), nullable=False),
sa.Column('slot', sa.String(attr.STATUS_LEN), nullable=False),
sa.Column('vfwname', sa.String(attr.NAME_MAX_LEN), nullable=False),
sa.Column('vfw_id', sa.String(attr.UUID_LEN), nullable=False),
sa.Column('operation_fro',
sa.String(attr.UUID_LEN), nullable=False),
sa.Column('deleted_at', sa.DateTime(), nullable=True),
sa.Column('deleted', sa.Boolean(), nullable=True),
mysql_engine='InnoDB',
mysql_charset='utf8'
)
tables = [dns_zone_info, nca_agent_info, nca_vres_info,
nca_operation_history, dns_rrs_info, fw_vlan_info,
fw_vfw_info, fw_security_zone_info, fw_addrobj_info,
fw_netservices_info, fw_snataddrpool_info,
fw_snat_info, fw_dnat_info, fw_packetfilter_info,
fw_staticnat_info, fw_vrf_info]
for table in tables:
try:
if not table.exists():
table.create()
except Exception:
LOG.info(repr(table))
LOG.exception(_LE('Exception while creating table.'))
raise
columns = [nca_vres_info.c.id.label('id'),
nca_agent_info.c.id.label('agent_id'),
nca_agent_info.c.agent_ip.label('agent_ip'),
nca_agent_info.c.agent_nat_ip.label('agent_nat_ip'),
nca_vres_info.c.id.label('vres_id'),
nca_vres_info.c.tenant_id.label('tenant_id'),
nca_agent_info.c.dc_name.label('dc_name'),
nca_agent_info.c.network_zone.label('network_zone'),
nca_vres_info.c.vres_name.label('vres_name'),
nca_agent_info.c.agent_type.label('agent_type'),
nca_agent_info.c.deleted_at.label('deleted_at'),
nca_agent_info.c.deleted.label('deleted')]
condition1 = (nca_agent_info.c.id == nca_vres_info.c.agent_id)
condition2 = (nca_agent_info.c.availiable is True)
condition3 = (nca_vres_info.c.deleted is False)
vres_agent_view = CreateView('vres_agent_view',
select(columns).where(condition1 and
condition2 and
condition3))
engine.execute(vres_agent_view)
vfw_trigger = sa.DDL('''\
CREATE TRIGGER cascadeDel_on_vfw AFTER UPDATE ON
fw_vfw_info FOR EACH ROW
BEGIN
UPDATE fw_dnat_info set deleted_at=now(), deleted=1
WHERE (vfw_id = old.id) and (old.deleted = 0) and
(new.deleted = 1);
UPDATE fw_staticnat_info set deleted_at=now(),
deleted=1 WHERE (vfw_id = old.id) and
(old.deleted = 0) and (new.deleted = 1);
UPDATE fw_snat_info set deleted_at=now(), deleted=1
WHERE (vfw_id = old.id) and (old.deleted = 0)
and (new.deleted = 1);
UPDATE fw_addrobj_info set deleted_at=now(), deleted=1
WHERE (vfw_id = old.id) and (old.deleted = 0) and
(new.deleted = 1);
UPDATE fw_snataddrpool_info set deleted_at=now(),
deleted=1 WHERE (vfw_id = old.id) and
(old.deleted = 0) and (new.deleted = 1);
UPDATE fw_netservices_info set deleted_at=now(),
deleted=1
WHERE (vfw_id = old.id) and (old.deleted = 0)
and (new.deleted = 1);
UPDATE fw_security_zone_info set deleted_at=now(),
deleted=1
WHERE (vfw_id = old.id) and (old.deleted = 0)
and (new.deleted = 1);
UPDATE fw_packetfilter_info set deleted_at=now(),
deleted=1 WHERE (vfw_id = old.id) and
(old.deleted = 0) and (new.deleted = 1);
END;''')
engine.execute(vfw_trigger)
nca_agent_info_table = sa.Table('nca_agent_info', meta, autoload=True)
nca_vres_info_table = sa.Table('nca_vres_info', meta, autoload=True)
nca_operation_history_table = sa.Table('nca_operation_history', meta,
autoload=True)
dns_zone_info_table = sa.Table('dns_zone_info', meta, autoload=True)
dns_rrs_info_table = sa.Table('dns_rrs_info', meta, autoload=True)
fw_vlan_info_table = sa.Table('fw_vlan_info', meta, autoload=True)
fw_vfw_info_table = sa.Table('fw_vfw_info', meta, autoload=True)
fw_security_zone_info_table = sa.Table('fw_security_zone_info',
meta, autoload=True)
fw_addrobj_info_table = sa.Table('fw_addrobj_info',
meta, autoload=True)
fw_netservices_info_table = sa.Table('fw_netservices_info',
meta, autoload=True)
fw_snataddrpool_info_table = sa.Table('fw_snataddrpool_info',
meta, autoload=True)
fw_snat_info_table = sa.Table('fw_snat_info', meta, autoload=True)
fw_dnat_info_table = sa.Table('fw_dnat_info', meta, autoload=True)
fw_packetfilter_info_table = sa.Table('fw_packetfilter_info',
meta, autoload=True)
fw_staticnat_info_table = sa.Table('fw_staticnat_info',
meta, autoload=True)
fw_vrf_info_table = sa.Table('fw_vrf_info',
meta, autoload=True)
nca_vres_info_agent_fk = ForeignKeyConstraint(
[nca_vres_info_table.c.agent_id],
[nca_agent_info_table.c.id])
nca_vres_info_agent_fk.create()
nca_operation_history_rrs_fk = ForeignKeyConstraint(
[nca_operation_history_table.c.config_id],
[nca_vres_info_table.c.id])
nca_operation_history_rrs_fk.create()
dns_zone_info_rrs_fk = ForeignKeyConstraint(
[dns_rrs_info_table.c.zone_id],
[dns_zone_info_table.c.id])
dns_zone_info_rrs_fk.create()
dns_zone_info_vres_fk = ForeignKeyConstraint(
[dns_zone_info_table.c.vres_id],
[nca_vres_info_table.c.vres_id])
dns_zone_info_vres_fk.create()
fw_vlan_info_fk = ForeignKeyConstraint(
[fw_vlan_info_table.c.vres_id],
[nca_vres_info_table.c.id])
fw_vlan_info_fk.create()
fw_vrf_info_fk = ForeignKeyConstraint(
[fw_vrf_info_table.c.vres_id],
[nca_vres_info_table.c.id])
fw_vrf_info_fk.create()
fw_vfw_info_fk = ForeignKeyConstraint(
[fw_vfw_info_table.c.vres_id],
[nca_vres_info_table.c.id])
fw_vfw_info_fk.create()
fw_security_zone_info_fk = ForeignKeyConstraint(
[fw_security_zone_info_table.c.vfw_id],
[fw_vfw_info_table.c.id])
fw_security_zone_info_fk.create()
fw_addrobj_info_fk = ForeignKeyConstraint(
[fw_addrobj_info_table.c.vfw_id],
[fw_vfw_info_table.c.id])
fw_addrobj_info_fk.create()
fw_netservices_info_fk = ForeignKeyConstraint(
[fw_netservices_info_table.c.vfw_id],
[fw_vfw_info_table.c.id])
fw_netservices_info_fk.create()
fw_snataddrpool_info_fk = ForeignKeyConstraint(
[fw_snataddrpool_info_table.c.vfw_id],
[fw_vfw_info_table.c.id])
fw_snataddrpool_info_fk.create()
fw_snat_info_fk = ForeignKeyConstraint(
[fw_snat_info_table.c.vfw_id],
[fw_vfw_info_table.c.id])
fw_snat_info_fk.create()
fw_dnat_info_fk = ForeignKeyConstraint(
[fw_dnat_info_table.c.vfw_id],
[fw_vfw_info_table.c.id])
fw_dnat_info_fk.create()
fw_packetfilter_info_fk = ForeignKeyConstraint(
[fw_packetfilter_info_table.c.vfw_id],
[fw_vfw_info_table.c.id])
fw_packetfilter_info_fk.create()
fw_staticnat_info_fk = ForeignKeyConstraint(
[fw_staticnat_info_table.c.vfw_id],
[fw_vfw_info_table.c.id])
fw_staticnat_info_fk.create()
