# Path: networking_odl/common/constants.py
# ODL_NETWORK = 'network'
# ODL_NETWORKS = 'networks'
# ODL_SUBNET = 'subnet'
# ODL_SUBNETS = 'subnets'
# ODL_PORT = 'port'
# ODL_PORTS = 'ports'
# ODL_SG = 'security_group'
# ODL_SGS = 'security_groups'
# ODL_SG_RULE = 'security_group_rule'
# ODL_SG_RULES = 'security_group_rules'
# ODL_ROUTER = 'router'
# ODL_ROUTERS = 'routers'
# ODL_FLOATINGIP = 'floatingip'
# ODL_FLOATINGIPS = 'floatingips'
# ODL_QOS = 'qos'
# ODL_QOS_POLICY = 'policy'
# ODL_QOS_POLICIES = 'policies'
# ODL_SFC = 'sfc'
# ODL_SFC_FLOW_CLASSIFIER = 'flowclassifier'
# ODL_SFC_FLOW_CLASSIFIERS = 'flowclassifiers'
# ODL_SFC_PORT_PAIR = 'portpair'
# ODL_SFC_PORT_PAIRS = 'portpairs'
# ODL_SFC_PORT_PAIR_GROUP = 'portpairgroup'
# ODL_SFC_PORT_PAIR_GROUPS = 'portpairgroups'
# ODL_SFC_PORT_CHAIN = 'portchain'
# ODL_SFC_PORT_CHAINS = 'portchains'
# NETWORKING_SFC_FLOW_CLASSIFIER = 'flow_classifier'
# NETWORKING_SFC_FLOW_CLASSIFIERS = 'flow_classifiers'
# NETWORKING_SFC_PORT_PAIR = 'port_pair'
# NETWORKING_SFC_PORT_PAIRS = 'port_pairs'
# NETWORKING_SFC_PORT_PAIR_GROUP = 'port_pair_group'
# NETWORKING_SFC_PORT_PAIR_GROUPS = 'port_pair_groups'
# NETWORKING_SFC_PORT_CHAIN = 'port_chain'
# NETWORKING_SFC_PORT_CHAINS = 'port_chains'
# ODL_TRUNK = 'trunk'
# ODL_TRUNKS = 'trunks'
# ODL_L2GATEWAY = 'l2_gateway'
# ODL_L2GATEWAYS = 'l2_gateways'
# ODL_L2GATEWAY_CONNECTION = 'l2gateway_connection'
# ODL_L2GATEWAY_CONNECTIONS = 'l2_gateway_connections'
# ODL_BGPVPN = 'bgpvpn'
# ODL_BGPVPNS = 'bgpvpns'
# ODL_BGPVPN_NETWORK_ASSOCIATION = 'bgpvpn_network_association'
# ODL_BGPVPN_NETWORK_ASSOCIATIONS = 'bgpvpn_network_associations'
# ODL_BGPVPN_ROUTER_ASSOCIATION = 'bgpvpn_router_association'
# ODL_BGPVPN_ROUTER_ASSOCIATIONS = 'bgpvpn_router_associations'
# ODL_ML2_MECH_DRIVER_V2 = "opendaylight_v2"
# ODL_DEVICE_ID_START = 'OpenDaylight'
# ODL_CREATE = 'create'
# ODL_UPDATE = 'update'
# ODL_DELETE = 'delete'
# PENDING = 'pending'
# PROCESSING = 'processing'
# FAILED = 'failed'
# COMPLETED = 'completed'
# BEFORE_COMPLETE = 'before_complete'
# AFTER_DELETE = 'after_delete'
# RESOURCE_URL_MAPPINGS = {
#     ODL_QOS_POLICY: "%s/%s" % (ODL_QOS, ODL_QOS_POLICIES),
#     ODL_SFC_FLOW_CLASSIFIER: "%s/%s" % (ODL_SFC, ODL_SFC_FLOW_CLASSIFIERS),
#     ODL_SFC_PORT_CHAIN: "%s/%s" % (ODL_SFC, ODL_SFC_PORT_CHAINS),
#     ODL_SFC_PORT_PAIR: "%s/%s" % (ODL_SFC, ODL_SFC_PORT_PAIRS),
#     ODL_SFC_PORT_PAIR_GROUP: "%s/%s" % (ODL_SFC, ODL_SFC_PORT_PAIR_GROUPS)
# }
# 
# Path: networking_odl/db/models.py
# class OpenDaylightJournal(model_base.BASEV2):
# class OpenDaylightPeriodicTask(model_base.BASEV2):


import logging
import sqlalchemy
from unittest import mock
from pecan import util as p_util
from neutron.tests.unit.testlib_api import SqlTestCaseLight
from neutron_lib import context as neutron_context
from neutron_lib.db import api as db_api
from neutron_lib import fixture as lib_fixtures
from oslo_config import fixture as config_fixture
from oslo_db import exception as db_exc
from sqlalchemy.orm import exc
from networking_odl.common import constants
from networking_odl.db import models
        self.db_context = neutron_context.get_admin_context()
        self.cfg = self.useFixture(config_fixture.Config())
        self.cfg.config(completed_rows_retention=-1, group='ml2_odl')
        self._setup_retry_tracker_table()

    def _setup_retry_tracker_table(self):
        metadata = sqlalchemy.MetaData()
        self.retry_table = sqlalchemy.Table(
            'retry_tracker', metadata,
            sqlalchemy.Column(
                'id', sqlalchemy.Integer,
                autoincrement=True,
                primary_key=True,
            ),
        )
        metadata.create_all(self.engine)
        self.addCleanup(metadata.drop_all, self.engine)

        class RetryTracker(object):
            pass

        sqlalchemy.orm.mapper(RetryTracker, self.retry_table)
        self.retry_tracker = RetryTracker

    def _db_cleanup(self):
        self.db_context.session.query(models.OpenDaylightJournal).delete()
        self.db_context.session.query(models.OpenDaylightPeriodicTask).delete()
        row0 = models.OpenDaylightPeriodicTask(
            task='maintenance', state=constants.PENDING)
        row1 = models.OpenDaylightPeriodicTask(

# Path: networking_odl/common/constants.py
# ODL_NETWORK = 'network'
# ODL_NETWORKS = 'networks'
# ODL_SUBNET = 'subnet'
# ODL_SUBNETS = 'subnets'
# ODL_PORT = 'port'
# ODL_PORTS = 'ports'
# ODL_SG = 'security_group'
# ODL_SGS = 'security_groups'
# ODL_SG_RULE = 'security_group_rule'
# ODL_SG_RULES = 'security_group_rules'
# ODL_ROUTER = 'router'
# ODL_ROUTERS = 'routers'
# ODL_FLOATINGIP = 'floatingip'
# ODL_FLOATINGIPS = 'floatingips'
# ODL_QOS = 'qos'
# ODL_QOS_POLICY = 'policy'
# ODL_QOS_POLICIES = 'policies'
# ODL_SFC = 'sfc'
# ODL_SFC_FLOW_CLASSIFIER = 'flowclassifier'
# ODL_SFC_FLOW_CLASSIFIERS = 'flowclassifiers'
# ODL_SFC_PORT_PAIR = 'portpair'
# ODL_SFC_PORT_PAIRS = 'portpairs'
# ODL_SFC_PORT_PAIR_GROUP = 'portpairgroup'
# ODL_SFC_PORT_PAIR_GROUPS = 'portpairgroups'
# ODL_SFC_PORT_CHAIN = 'portchain'
# ODL_SFC_PORT_CHAINS = 'portchains'
# NETWORKING_SFC_FLOW_CLASSIFIER = 'flow_classifier'
# NETWORKING_SFC_FLOW_CLASSIFIERS = 'flow_classifiers'
# NETWORKING_SFC_PORT_PAIR = 'port_pair'
# NETWORKING_SFC_PORT_PAIRS = 'port_pairs'
# NETWORKING_SFC_PORT_PAIR_GROUP = 'port_pair_group'
# NETWORKING_SFC_PORT_PAIR_GROUPS = 'port_pair_groups'
# NETWORKING_SFC_PORT_CHAIN = 'port_chain'
# NETWORKING_SFC_PORT_CHAINS = 'port_chains'
# ODL_TRUNK = 'trunk'
# ODL_TRUNKS = 'trunks'
# ODL_L2GATEWAY = 'l2_gateway'
# ODL_L2GATEWAYS = 'l2_gateways'
# ODL_L2GATEWAY_CONNECTION = 'l2gateway_connection'
# ODL_L2GATEWAY_CONNECTIONS = 'l2_gateway_connections'
# ODL_BGPVPN = 'bgpvpn'
# ODL_BGPVPNS = 'bgpvpns'
# ODL_BGPVPN_NETWORK_ASSOCIATION = 'bgpvpn_network_association'
# ODL_BGPVPN_NETWORK_ASSOCIATIONS = 'bgpvpn_network_associations'
# ODL_BGPVPN_ROUTER_ASSOCIATION = 'bgpvpn_router_association'
# ODL_BGPVPN_ROUTER_ASSOCIATIONS = 'bgpvpn_router_associations'
# ODL_ML2_MECH_DRIVER_V2 = "opendaylight_v2"
# ODL_DEVICE_ID_START = 'OpenDaylight'
# ODL_CREATE = 'create'
# ODL_UPDATE = 'update'
# ODL_DELETE = 'delete'
# PENDING = 'pending'
# PROCESSING = 'processing'
# FAILED = 'failed'
# COMPLETED = 'completed'
# BEFORE_COMPLETE = 'before_complete'
# AFTER_DELETE = 'after_delete'
# RESOURCE_URL_MAPPINGS = {
#     ODL_QOS_POLICY: "%s/%s" % (ODL_QOS, ODL_QOS_POLICIES),
#     ODL_SFC_FLOW_CLASSIFIER: "%s/%s" % (ODL_SFC, ODL_SFC_FLOW_CLASSIFIERS),
#     ODL_SFC_PORT_CHAIN: "%s/%s" % (ODL_SFC, ODL_SFC_PORT_CHAINS),
#     ODL_SFC_PORT_PAIR: "%s/%s" % (ODL_SFC, ODL_SFC_PORT_PAIRS),
#     ODL_SFC_PORT_PAIR_GROUP: "%s/%s" % (ODL_SFC, ODL_SFC_PORT_PAIR_GROUPS)
# }
# 
# Path: networking_odl/db/models.py
# class OpenDaylightJournal(model_base.BASEV2):
# class OpenDaylightPeriodicTask(model_base.BASEV2):


# Path: networking_odl/tests/unit/test_base_db.py
import logging
import sqlalchemy
from unittest import mock
from pecan import util as p_util
from neutron.tests.unit.testlib_api import SqlTestCaseLight
from neutron_lib import context as neutron_context
from neutron_lib.db import api as db_api
from neutron_lib import fixture as lib_fixtures
from oslo_config import fixture as config_fixture
from oslo_db import exception as db_exc
from sqlalchemy.orm import exc
from networking_odl.common import constants
from networking_odl.db import models

        self.db_context = neutron_context.get_admin_context()
        self.cfg = self.useFixture(config_fixture.Config())
        self.cfg.config(completed_rows_retention=-1, group='ml2_odl')
        self._setup_retry_tracker_table()

    def _setup_retry_tracker_table(self):
        metadata = sqlalchemy.MetaData()
        self.retry_table = sqlalchemy.Table(
            'retry_tracker', metadata,
            sqlalchemy.Column(
                'id', sqlalchemy.Integer,
                autoincrement=True,
                primary_key=True,
            ),
        )
        metadata.create_all(self.engine)
        self.addCleanup(metadata.drop_all, self.engine)

        class RetryTracker(object):
            pass

        sqlalchemy.orm.mapper(RetryTracker, self.retry_table)
        self.retry_tracker = RetryTracker

    def _db_cleanup(self):
        self.db_context.session.query(models.OpenDaylightJournal).delete()
        self.db_context.session.query(models.OpenDaylightPeriodicTask).delete()
        row0 = models.OpenDaylightPeriodicTask(
            task='maintenance', state=constants.PENDING)
        row1 = models.OpenDaylightPeriodicTask(

            task='hostconfig', state=constants.PENDING)