def __init__(self, server, port, user, pw, **kwargs):
self.server = server
self.port = port
self.user = user
self.pw = pw
self._meta = _MetaData()
self.engine = None
# Copyright (c) 2009-2011, Stefano Rivera
# Released under terms of the MIT/X/Expat Licence. See COPYING for details.
import warnings as _warnings
from ibid.db.types import TypeDecorator, Integer, DateTime, Boolean, \
IbidUnicode, IbidUnicodeText
from sqlalchemy import Table, Column, ForeignKey, Index, UniqueConstraint, \
PassiveDefault, or_, and_, MetaData as _MetaData
from sqlalchemy.orm import eagerload, relation, synonym
from sqlalchemy.sql import func
from sqlalchemy.ext.declarative import declarative_base as _declarative_base
from sqlalchemy.exceptions import IntegrityError, SADeprecationWarning
metadata = _MetaData()
Base = _declarative_base(metadata=metadata)
from ibid.db.versioned_schema import VersionedSchema, SchemaVersionException, \
schema_version_check, upgrade_schemas
# We use SQLAlchemy 0.4 compatible .save_or_update() functions
_warnings.filterwarnings('ignore', 'Use session.add\(\)', SADeprecationWarning)
def get_regexp_op(session):
"Return a regexp operator"
if session.bind.engine.name in ('postgres', 'postgresql'):
return lambda x, y: x.op('~')(y)
else:
return lambda x, y: x.op('REGEXP')(y)
# Copyright (c) 2009-2011, Stefano Rivera
# Released under terms of the MIT/X/Expat Licence. See COPYING for details.
import warnings as _warnings
from ibid.db.types import TypeDecorator, Integer, DateTime, Boolean, \
IbidUnicode, IbidUnicodeText
from sqlalchemy import Table, Column, ForeignKey, Index, UniqueConstraint, \
PassiveDefault, or_, and_, MetaData as _MetaData
from sqlalchemy.orm import eagerload, relation, synonym
from sqlalchemy.sql import func
from sqlalchemy.ext.declarative import declarative_base as _declarative_base
from sqlalchemy.exceptions import IntegrityError, SADeprecationWarning
metadata = _MetaData()
Base = _declarative_base(metadata=metadata)
from ibid.db.versioned_schema import VersionedSchema, SchemaVersionException, \
schema_version_check, upgrade_schemas
# We use SQLAlchemy 0.4 compatible .save_or_update() functions
_warnings.filterwarnings('ignore', 'Use session.add\(\)', SADeprecationWarning)
def get_regexp_op(session):
"Return a regexp operator"
if session.bind.engine.name in ('postgres', 'postgresql'):
return lambda x, y: x.op('~')(y)
else:
return lambda x, y: x.op('REGEXP')(y)
from config import * from sqlalchemy import MetaData as _MetaData from sqlalchemy.ext.declarative import declarative_base as _declarative_base DeclarativeBase = _declarative_base(metadata=_MetaData())
#
# This file is part of BDC-DB.
# Copyright (C) 2020 INPE.
#
# BDC-DB is free software; you can redistribute it and/or modify it
# under the terms of the MIT License; see LICENSE file for more details.
#
"""Database instance using Flask-SQLAlchemy extension."""
from flask_sqlalchemy import SQLAlchemy as _SQLAlchemy
from sqlalchemy import MetaData as _MetaData
# See more in https://docs.sqlalchemy.org/en/13/core/constraints.html#configuring-constraint-naming-conventions
NAMING_CONVENTION = {
"ix": 'idx_%(column_0_label)s',
"uq": "%(table_name)s_%(column_0_name)s_key",
"ck": "%(table_name)s_%(constraint_name)s_ckey",
"fk": "%(table_name)s_%(column_0_name)s_%(referred_table_name)s_fkey",
"pk": "%(table_name)s_pkey"
}
"""Naming convention for SQLAlchemy constraint keys"""
metadata = _MetaData(naming_convention=NAMING_CONVENTION)
"""Default database metadata object holding associated schema constructs."""
db = _SQLAlchemy(metadata=metadata)
"""Shared database instance using Flask-SQLAlchemy extension."""
