sqlalchemy.Table

All Samples(2038) | Call(1509) | Derive(0) | Import(529)

Represent a table in a database.

e.g.::

    mytable = Table("mytable", metadata, 
                    Column('mytable_id', Integer, primary_key=True),
                    Column('value', String(50))
               )

The Table object constructs a unique instance of itself based on its(more...)

src/s/y/synthesis-1.1061/synthesis/dbobjects.py synthesis(Download)

#!/usr/bin/env python
 
from sqlalchemy import create_engine, Table, Column, Integer, String, Boolean, MetaData, ForeignKey
from sqlalchemy.orm import sessionmaker, mapper, relation, clear_mappers
from sqlalchemy.types import DateTime, Date

    def system_configuration_map(self):
        table_metadata = MetaData(bind=self.pg_db_engine)
        #table_metadata = MetaData(bind=self.sqlite_db)
        system_configuration_table = Table(
        'sender_system_configuration',

    def service_event_map(self):
        table_metadata = MetaData(bind=self.pg_db_engine)
        service_event_table = Table(
        'service_event',
        table_metadata,

    def need_map(self):
        table_metadata = MetaData(bind=self.pg_db_engine)
        need_table = Table(
        'need',
        table_metadata,

    def site_service_participation_map(self):
        table_metadata = MetaData(bind=self.pg_db_engine)
        site_service_participation_table = Table(
        'site_service_participation',
        table_metadata,

src/s/q/SQLAlchemy-0.7.10/examples/large_collection/large_collection.py SQLAlchemy(Download)

 
from sqlalchemy import (MetaData, Table, Column, Integer, String, ForeignKey,
                        create_engine)
from sqlalchemy.orm import (mapper, relationship, sessionmaker)
 
 
meta = MetaData()
 
org_table = Table('organizations', meta,

    mysql_engine='InnoDB')
 
member_table = Table('members', meta,
    Column('member_id', Integer, primary_key=True),
    Column('member_name', String(50), nullable=False, key='name'),

src/s/q/sqlalchemy-HEAD/examples/large_collection/large_collection.py sqlalchemy(Download)

 
from sqlalchemy import (MetaData, Table, Column, Integer, String, ForeignKey,
                        create_engine)
from sqlalchemy.orm import (mapper, relation, sessionmaker)
 
 
meta = MetaData()
 
org_table = Table('organizations', meta,

    mysql_engine='InnoDB')
 
member_table = Table('members', meta,
    Column('member_id', Integer, primary_key=True),
    Column('member_name', String(50), nullable=False, key='name'),

src/s/q/SQLAlchemy-0.7.10/examples/vertical/dictlike-polymorphic.py SQLAlchemy(Download)

 
if __name__ == '__main__':
    from sqlalchemy import (MetaData, Table, Column, Integer, Unicode,
        ForeignKey, UnicodeText, and_, not_, or_, String, Boolean, cast, text,
        null, case, create_engine)

    metadata = MetaData()
 
    animals = Table('animal', metadata,
                    Column('id', Integer, primary_key=True),
                    Column('name', Unicode(100)))
 
    chars = Table('facts', metadata,

src/s/q/sqlalchemy-HEAD/examples/vertical/dictlike-polymorphic.py sqlalchemy(Download)

 
if __name__ == '__main__':
    from sqlalchemy import (MetaData, Table, Column, Integer, Unicode,
        ForeignKey, UnicodeText, and_, not_, or_, String, Boolean, cast, text,
        null, case)

    metadata = MetaData()
 
    animals = Table('animal', metadata,
                    Column('id', Integer, primary_key=True),
                    Column('name', Unicode(100)))
 
    chars = Table('facts', metadata,

src/a/t/atma-HEAD/trunk/examples/system/lib/classes/model.py atma(Download)

metadata = sa.BoundMetaData(engine)
 
sa.Table('user', metadata,
    sa.Column('id', sa.Integer, primary_key=True),
    sa.Column('name', sa.String(16), nullable=False, unique=True),

src/s/q/SQLAlchemy-0.7.10/examples/inheritance/single.py SQLAlchemy(Download)

from sqlalchemy import MetaData, Table, Column, Integer, String, \
    ForeignKey, create_engine
from sqlalchemy.orm import mapper, relationship, sessionmaker
 
metadata = MetaData()
 
# a table to store companies
companies = Table('companies', metadata,

   Column('name', String(50)))
 
employees_table = Table('employees', metadata,
    Column('employee_id', Integer, primary_key=True),
    Column('company_id', Integer, ForeignKey('companies.company_id')),

src/s/q/sqlalchemy-HEAD/examples/inheritance/single.py sqlalchemy(Download)

from sqlalchemy import MetaData, Table, Column, Integer, String, ForeignKey
from sqlalchemy.orm import mapper, relation, create_session
 
metadata = MetaData('sqlite://')
metadata.bind.echo = 'debug'
 
# a table to store companies
companies = Table('companies', metadata,

   Column('name', String(50)))
 
employees_table = Table('employees', metadata, 
    Column('employee_id', Integer, primary_key=True),
    Column('company_id', Integer, ForeignKey('companies.company_id')),

src/s/q/SQLAlchemy-0.7.10/examples/elementtree/optimized_al.py SQLAlchemy(Download)

 
##################### PART I - Imports/Configuration #########################
from sqlalchemy import (MetaData, Table, Column, Integer, String, ForeignKey,
    Unicode, and_, create_engine)
from sqlalchemy.orm import mapper, relationship, Session, lazyload

 
# stores a top level record of an XML document.
documents = Table('documents', meta,
    Column('document_id', Integer, primary_key=True),
    Column('filename', String(30), unique=True),
)
 
# stores XML nodes in an adjacency list model.  This corresponds to
# Element and SubElement objects.
elements = Table('elements', meta,

# stores attributes.  This corresponds to the dictionary of attributes
# stored by an Element or SubElement.
attributes = Table('attributes', meta,
    Column('element_id', Integer, ForeignKey('elements.element_id'), primary_key=True),
    Column('name', Unicode(100), nullable=False, primary_key=True),

src/s/q/sqlalchemy-HEAD/examples/elementtree/optimized_al.py sqlalchemy(Download)

 
################################# PART I - Imports/Configuration ###########################################
from sqlalchemy import (MetaData, Table, Column, Integer, String, ForeignKey,
    Unicode, and_)
from sqlalchemy.orm import mapper, relation, create_session, lazyload

 
# stores a top level record of an XML document.  
documents = Table('documents', meta,
    Column('document_id', Integer, primary_key=True),
    Column('filename', String(30), unique=True),
)
 
# stores XML nodes in an adjacency list model.  This corresponds to 
# Element and SubElement objects.
elements = Table('elements', meta,

# stores attributes.  This corresponds to the dictionary of attributes
# stored by an Element or SubElement.
attributes = Table('attributes', meta,
    Column('element_id', Integer, ForeignKey('elements.element_id'), primary_key=True),
    Column('name', Unicode(100), nullable=False, primary_key=True),

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 Next