Python get_engine Examples

Example #1

File: README_dtest.py Project: marplatense/sqla_hierarchy

def setup(mod):
    global engine
    engine = get_engine('pg-db')

Example #2

# -*- coding: UTF-8 -*-
""""Testing hierarchy dialect in sqlalchemy"""
from nose.tools import *
from mock import Mock

from sqlalchemy import Table, Column, ForeignKey, MetaData
from sqlalchemy import Integer, Unicode, Boolean
from sqlalchemy import select
from sqlalchemy.orm import mapper, relationship, scoped_session, sessionmaker
from sqla_hierarchy import *
from tests import get_engine

DBSession = scoped_session(sessionmaker())
metadata = MetaData()
engine = get_engine('ora-db')
DBSession.configure(bind=engine)
metadata.bind = engine

dummy_tb = Table(
    'dummy_hierarchy', metadata, Column('id', Integer, primary_key=True),
    Column('name', Unicode(10)),
    Column('parent_id', Integer, ForeignKey('dummy_hierarchy.id'), index=True),
    Column('active', Boolean, default=True, nullable=False))


class Dummy(object):
    def __init__(self, **kw):
        for k, v in kw.items():
            setattr(self, k, v)

    def __repr__(self):

Example #3

File: README_dtest.py Project: FashtimeDotCom/sqla_hierarchy

def setup(mod):
    global engine
    engine = get_engine('pg-db')

Example #4

File: test_pg.py Project: FashtimeDotCom/sqla_hierarchy

# -*- coding: UTF-8 -*-
""""Testing hierarchy dialect in sqlalchemy"""
from nose.tools import *
from mock import Mock

from sqlalchemy import Table, Column, ForeignKey, MetaData
from sqlalchemy import Integer, Unicode, Boolean
from sqlalchemy import select
from sqlalchemy.orm import mapper, relationship, scoped_session, sessionmaker
from sqla_hierarchy import *

from tests import get_engine

DBSession = scoped_session(sessionmaker())
metadata = MetaData()
engine = get_engine('pg-db')
DBSession.configure(bind=engine)
metadata.bind = engine

dummy_tb = Table('dummy_hierarchy', metadata,
                 Column('id', Integer, primary_key=True),
                 Column('name', Unicode(10)),
                 Column('parent_id', Integer, ForeignKey('dummy_hierarchy.id'),
                        index=True),
                 Column('active', Boolean, default=True, nullable=False)
                )

class Dummy(object):
    def __init__(self, **kw):
        for k, v in kw.iteritems():
            setattr(self, k, v)

Example #5

File: test_pg.py Project: jakeogh/sqla_hierarchy

# -*- coding: UTF-8 -*-
""""Testing hierarchy dialect in sqlalchemy"""
from nose.tools import *
from mock import Mock

from sqlalchemy import Table, Column, ForeignKey, MetaData
from sqlalchemy import Integer, Unicode, Boolean
from sqlalchemy import select
from sqlalchemy.orm import mapper, relationship, scoped_session, sessionmaker
from sqla_hierarchy import *

from tests import get_engine

DBSession = scoped_session(sessionmaker())
metadata = MetaData()
engine = get_engine('pg-db')
DBSession.configure(bind=engine)
metadata.bind = engine

dummy_tb = Table(
    'dummy_hierarchy', metadata, Column('id', Integer, primary_key=True),
    Column('name', Unicode(10)),
    Column('parent_id', Integer, ForeignKey('dummy_hierarchy.id'), index=True),
    Column('active', Boolean, default=True, nullable=False))


class Dummy(object):
    def __init__(self, **kw):
        for k, v in kw.items():
            setattr(self, k, v)

Example #6

File: test_oracle.py Project: ovgu-ttz/sqla_hierarchy

# -*- coding: UTF-8 -*-
""""Testing hierarchy dialect in sqlalchemy"""
from nose.tools import *
from mock import Mock

from sqlalchemy import Table, Column, ForeignKey, MetaData
from sqlalchemy import Integer, Unicode, Boolean
from sqlalchemy import select
from sqlalchemy.orm import mapper, relationship, scoped_session, sessionmaker
from sqla_hierarchy import *
from tests import get_engine


DBSession = scoped_session(sessionmaker())
metadata = MetaData()
engine = get_engine('ora-db')
DBSession.configure(bind=engine)
metadata.bind = engine

dummy_tb = Table('dummy_hierarchy', metadata,
                 Column('id', Integer, primary_key=True),
                 Column('name', Unicode(10)),
                 Column('parent_id', Integer, ForeignKey('dummy_hierarchy.id'),
                        index=True),
                 Column('active', Boolean, default=True, nullable=False)
                )

class Dummy(object):
    def __init__(self, **kw):
        for k, v in kw.items():
            setattr(self, k, v)