# 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 datetime
from neutron_lib.db import api as db_api
from oslo_log import log as logging
from sqlalchemy import asc
from sqlalchemy import bindparam
from sqlalchemy.ext import baked
from sqlalchemy import func
from sqlalchemy import or_
from sqlalchemy.orm import aliased
from networking_odl.common import constants as odl_const
from networking_odl.db import models
bakery = baked.bakery()


def get_pending_or_processing_ops(context, object_uuid, operation=None):
    # NOTE (sai): For performance reasons, we expect this method to use baked
    # query (http://docs.sqlalchemy.org/en/latest/orm/extensions/baked.html)
    baked_query = bakery(lambda s: s.query(
        models.OpenDaylightJournal))
    baked_query += lambda q: q.filter(
        or_(models.OpenDaylightJournal.state == odl_const.PENDING,
            models.OpenDaylightJournal.state == odl_const.PROCESSING),
        models.OpenDaylightJournal.object_uuid == bindparam('uuid'))
    if operation:
        if isinstance(operation, (list, tuple)):
            baked_query += lambda q: q.filter(
                models.OpenDaylightJournal.operation.in_(bindparam('op',
                                                         expanding=True)))
        else:
            baked_query += lambda q: q.filter(
                models.OpenDaylightJournal.operation == bindparam('op'))

    return baked_query(context.session).params(
        uuid=object_uuid, op=operation).all()


def get_pending_delete_ops_with_parent(context, object_type, parent_id):
    rows = context.session.query(models.OpenDaylightJournal).filter(
        or_(models.OpenDaylightJournal.state == odl_const.PENDING,
            models.OpenDaylightJournal.state == odl_const.PROCESSING),
        models.OpenDaylightJournal.object_type == object_type,

# 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/db/db.py
import datetime
from neutron_lib.db import api as db_api
from oslo_log import log as logging
from sqlalchemy import asc
from sqlalchemy import bindparam
from sqlalchemy.ext import baked
from sqlalchemy import func
from sqlalchemy import or_
from sqlalchemy.orm import aliased
from networking_odl.common import constants as odl_const
from networking_odl.db import models

bakery = baked.bakery()


def get_pending_or_processing_ops(context, object_uuid, operation=None):
    # NOTE (sai): For performance reasons, we expect this method to use baked
    # query (http://docs.sqlalchemy.org/en/latest/orm/extensions/baked.html)
    baked_query = bakery(lambda s: s.query(
        models.OpenDaylightJournal))
    baked_query += lambda q: q.filter(
        or_(models.OpenDaylightJournal.state == odl_const.PENDING,
            models.OpenDaylightJournal.state == odl_const.PROCESSING),
        models.OpenDaylightJournal.object_uuid == bindparam('uuid'))
    if operation:
        if isinstance(operation, (list, tuple)):
            baked_query += lambda q: q.filter(
                models.OpenDaylightJournal.operation.in_(bindparam('op',
                                                         expanding=True)))
        else:
            baked_query += lambda q: q.filter(
                models.OpenDaylightJournal.operation == bindparam('op'))

    return baked_query(context.session).params(
        uuid=object_uuid, op=operation).all()


def get_pending_delete_ops_with_parent(context, object_type, parent_id):
    rows = context.session.query(models.OpenDaylightJournal).filter(
        or_(models.OpenDaylightJournal.state == odl_const.PENDING,
            models.OpenDaylightJournal.state == odl_const.PROCESSING),
        models.OpenDaylightJournal.object_type == object_type,

        models.OpenDaylightJournal.operation == odl_const.ODL_DELETE