Python get_engine Examples

Example #1

    def testZS2SA(self):

        db = get_engine('mysql://root@localhost/alc2', echo=True)
        meta = rdb.BoundMetaData(db)
        table = transmute(ITestInterface, meta)
        meta.create_all()

        self.assertEqual(table.columns.ASCII.type.__class__, rdb.TEXT)
        self.assertEqual(table.columns.ASCIILine.type.__class__, rdb.TEXT)
        self.assertEqual(table.columns.Bool.type.__class__, rdb.BOOLEAN)

Example #2

File: test_zs2sa.py Project: kapilt/zope-alchemist

    def testZS2SA( self ):

        db = get_engine('mysql://root@localhost/alc2', echo=True )
        meta = rdb.BoundMetaData( db )
        table = transmute(ITestInterface, meta)
        meta.create_all()

        self.assertEqual(table.columns.ASCII.type.__class__, rdb.TEXT)
        self.assertEqual(table.columns.ASCIILine.type.__class__, rdb.TEXT)
        self.assertEqual(table.columns.Bool.type.__class__, rdb.BOOLEAN)

Example #3

File: db.py Project: BGCX261/zope-alchemist-svn-to-git

"""
database access definition

$Id: db.py 129 2006-11-27 22:50:41Z hazmat $
"""

from ore.alchemist.engine import get_engine

database = get_engine('mysql://root@localhost/orgperson', encoding='utf-8', convert_unicode=True, echo=True)

Example #4

File: model.py Project: kapilt/zope-alchemist

def ModelFactory( db_uri ):
    db = get_engine( db_uri )
    meta = BoundMetaData( db )
    return AppModel( meta )

Example #5

from sqlalchemy import *
from ore.alchemist.engine import get_engine
db = get_engine('mysql://root@localhost/alc2', echo=True)


def loadTables():
    meta = BoundMetaData(db)
    table = Table("Users", meta, autoload=True)

    return meta

Example #6

File: test_Changeset.py Project: BGCX261/zope-alchemist-svn-to-git

"""
$Id: test_Changeset.py 94 2006-10-26 17:39:37Z hazmat $
"""

from unittest import TestCase, main

from sqlalchemy import * # to hard to fight ;-)
from ore.alchemist import changeset
from ore.alchemist.engine import get_engine
from ore.alchemist import introspector

import transaction

engine = get_engine( 'mysql://root@localhost/alchemy', echo=True)

metadata = BoundMetaData( engine )

other_metadata = DynamicMetaData()


users = Table('users', metadata,
                            Column('user_id', Integer, Sequence('user_id_seq', optional=True), primary_key = True),
                            Column('user_name', String(40)),
                            )


other_users = Table('users', other_metadata,
                                  Column('user_id', Integer, Sequence('user_id_seq', optional=True), primary_key = True),
                                  Column('user_name', String(40)),
                                  Column('fullname',  String(90)),
                                  )

Example #7

File: _base.py Project: kapilt/zope-alchemist

from sqlalchemy import *
from ore.alchemist.engine import get_engine
db = get_engine('mysql://root@localhost/alc2', echo=True )

def loadTables():
    meta = BoundMetaData( db )
    table = Table("Users", meta, autoload=True )

    return meta
        

Example #8

File: db.py Project: kapilt/zope-alchemist

"""
database access definition

$Id$
"""

from ore.alchemist.engine import get_engine

database = get_engine('mysql://root@localhost/orgperson',
                      encoding='utf-8',
                      convert_unicode=True,
                      echo=True)

Example #9

File: model.py Project: BGCX261/zope-alchemist-svn-to-git

def ModelFactory(db_uri):
    db = get_engine(db_uri)
    meta = BoundMetaData(db)
    return AppModel(meta)