root/sandbox/bhorisberger/v25toflex/v25toflex/tests/persistent.py @ 2497

import sqlalchemy as sa
import sqlalchemy.orm as orm
import models

class Schema(object):

    """create engine to our postgres database"""
    engine = sa.create_engine('postgres://postgres:postgres@localhost/testVector')



#-------SESSION---------------------------------------
    def create_session(self):
        """link session to an engine"""
        Session=orm.scoped_session(orm.sessionmaker(bind=self.engine))
        
        """create a session"""
        one_session=Session()
        return one_session
#-----------------------------------------------------

     
#-------SCHEMA---------------------------------------------------
    def createSchema(self):

        metadata = sa.MetaData()
        self.testVector= sa.Table('vector', metadata,
            sa.Column('gid', sa.integer, primary_key=True),
            sa.Column('area', sa.numeric),
            sa.Column('perimeter', sa.numeric),
            sa.Column('objectid', sa.bigint),
            sa.Column('objectorig', sa.charactervarying(20)),
            sa.Column('objectval', sa.charactervarying(20)),
            sa.Column('yearofchan', sa.integer),
            sa.Column('the_geom', sa.geometry))
#----------------------------------------------------------------


#-------MAPPING--------------------------------------------
    def createMappers(self):
        """delete existing mapping"""
        orm.clear_mappers()
        
        """create new mapping"""
        orm.mapper(models.TestVector, self.testVector)
#----------------------------------------------------------