All Samples(1528) | Call(1186) | Derive(0) | Import(342)
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
name within the given MetaData object. Constructor
arguments are as follows:
:param name: The name of this table as represented in the database.
This property, along with the *schema*, indicates the *singleton
identity* of this table in relation to its parent :class:`MetaData`.
Additional calls to :class:`Table` with the same name, metadata,
and schema name will return the same :class:`Table` object.
Names which contain no upper case characters
will be treated as case insensitive names, and will not be quoted
unless they are a reserved word. Names with any number of upper
case characters will be quoted and sent exactly. Note that this
behavior applies even for databases which standardize upper
case names as case insensitive such as Oracle.
:param metadata: a :class:`MetaData` object which will contain this
table. The metadata is used as a point of association of this table
with other tables which are referenced via foreign key. It also
may be used to associate this table with a particular
:class:`~sqlalchemy.engine.base.Connectable`.
:param \*args: Additional positional arguments are used primarily
to add the list of :class:`Column` objects contained within this
table. Similar to the style of a CREATE TABLE statement, other
:class:`.SchemaItem` constructs may be added here, including
:class:`PrimaryKeyConstraint`, and :class:`ForeignKeyConstraint`.
:param autoload: Defaults to False: the Columns for this table should
be reflected from the database. Usually there will be no Column
objects in the constructor if this property is set.
:param autoload_with: If autoload==True, this is an optional Engine
or Connection instance to be used for the table reflection. If
``None``, the underlying MetaData's bound connectable will be used.
:param implicit_returning: True by default - indicates that
RETURNING can be used by default to fetch newly inserted primary key
values, for backends which support this. Note that
create_engine() also provides an implicit_returning flag.
:param include_columns: A list of strings indicating a subset of
columns to be loaded via the ``autoload`` operation; table columns who
aren't present in this list will not be represented on the resulting
``Table`` object. Defaults to ``None`` which indicates all columns
should be reflected.
:param info: A dictionary which defaults to ``{}``. A space to store
application specific data. This must be a dictionary.
:param mustexist: When ``True``, indicates that this Table must already
be present in the given :class:`MetaData`` collection.
:param prefixes:
A list of strings to insert after CREATE in the CREATE TABLE
statement. They will be separated by spaces.
:param quote: Force quoting of this table's name on or off, corresponding
to ``True`` or ``False``. When left at its default of ``None``,
the column identifier will be quoted according to whether the name is
case sensitive (identifiers with at least one upper case character are
treated as case sensitive), or if it's a reserved word. This flag
is only needed to force quoting of a reserved word which is not known
by the SQLAlchemy dialect.
:param quote_schema: same as 'quote' but applies to the schema identifier.
:param schema: The *schema name* for this table, which is required if
the table resides in a schema other than the default selected schema
for the engine's database connection. Defaults to ``None``.
:param useexisting: When ``True``, indicates that if this Table is already
present in the given :class:`MetaData`, apply further arguments within
the constructor to the existing :class:`Table`. If this flag is not
set, an error is raised when the parameters of an existing
:class:`Table` are overwritten.src/o/p/openinvdata-HEAD/trunk/storage/models/sas.py openinvdata(Download)
from sqlalchemy import Table, Column, Sequence, Integer, String, \
ForeignKey, TEXT, DateTime, Date, Boolean, Float, UniqueConstraint
from sqlalchemy.orm import mapper, relation
from sqlalchemy import MetaData
from datetime import datetime
sas_meta = MetaData()
#sas_prices
sas_prices_table = Table('sas_price', sas_meta,
src/o/p/openinvdata-HEAD/storage/models/sas.py openinvdata(Download)
from sqlalchemy import Table, Column, Sequence, Integer, String, \
ForeignKey, TEXT, DateTime, Date, Boolean, Float, UniqueConstraint
from sqlalchemy.orm import mapper, relation
from sqlalchemy import MetaData
from datetime import datetime
sas_meta = MetaData()
#sas_prices
sas_prices_table = Table('sas_price', sas_meta,
src/p/y/pychadwick-HEAD/chadwick/orm/__init__.py pychadwick(Download)
def __init__(self):
self.metadata = sqlalchemy.MetaData()
self.offensive_stats_table = \
sqlalchemy.Table("offensive_stats", self.metadata,
sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column("player_id", sqlalchemy.Integer,
)
self.defensive_stats_table = \
sqlalchemy.Table("defensive_stats", self.metadata,
sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column("player_id", sqlalchemy.Integer,
sqlalchemy.ForeignKey('players.id'),
)
self.pitching_stats_table = \
sqlalchemy.Table("pitching_stats", self.metadata,
sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column("player_id", sqlalchemy.Integer,
sqlalchemy.ForeignKey('players.id'),
)
self.players_table = \
sqlalchemy.Table("players", self.metadata,
sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column("team_id", sqlalchemy.Integer,
sqlalchemy.ForeignKey('teams.id'),
)
self.teams_table = \
sqlalchemy.Table("teams", self.metadata,
sqlalchemy.Column("id", sqlalchemy.Integer,
primary_key=True),
sqlalchemy.Column("game_id", sqlalchemy.Integer,
sqlalchemy.Column("stat_pb", sqlalchemy.Integer))
self.events_table = \
sqlalchemy.Table("events", self.metadata,
sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column("game_id", sqlalchemy.Integer,
sqlalchemy.ForeignKey('games.id'),
)
self.games_table = \
sqlalchemy.Table("games", self.metadata,
sqlalchemy.Column("id",
sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column("game_key", sqlalchemy.String(50)),
)
self.people_table = \
sqlalchemy.Table("people", self.metadata,
sqlalchemy.Column("id",
sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column("person_key", sqlalchemy.String(50),
src/j/u/junkcode_python-HEAD/sqlalchemy/ilf/inet_old.py junkcode_python(Download)
#!/usr/bin/env python from contextlib import contextmanager from sqlalchemy import create_engine, MetaData, Table, Column, ForeignKey from sqlalchemy.orm import mapper, sessionmaker from sqlalchemy.orm import backref, relationship, column_property from sqlalchemy.types import Integer, Float, String, \
engine = create_engine(connection_pattern.format(**logindata))
metadata = MetaData(engine)
employee_table = Table('e_employee', metadata,
Column('E_ID', Integer, primary_key=True),
Column('E_P_ID', Integer, ForeignKey('p_person.P_ID')),
Column('E_Current_ED_ID',
Column('E_Timestamp', DateTime),
)
employeedata_table = Table('ed_employeedata', metadata,
Column('ED_ID', Integer, primary_key=True),
Column('ED_E_ID', Integer, ForeignKey('e_employee.E_ID')),
Column('ED_From', DateTime, key="from_"),
Column('ED_VSRC_Rate', String(1)),
)
person_table = Table('p_person', metadata,
Column('P_ID', Integer, primary_key=True),
Column('P_Name', String(100), key='name'),
Column('P_FirstNames', String(150), key='firstname'),
Column('P_Timestamp', DateTime),
)
project_table = Table('pr_project', metadata,
Column('PR_ID', Integer, primary_key=True),
Column('PR_PNr', String(10), key='number'),
Column('PR_ONr', Integer),
Column('PR_Timestamp', DateTime),
)
project_customer_table = Table('prcust_projectcustomer', metadata,
Column('PRCUST_ID', Integer, primary_key=True),
Column('PRCUST_PR_ID', Integer, ForeignKey('pr_project.PR_ID')),
Column('PRCUST_Company_A_ID', Integer, ForeignKey('a_address.A_ID')),
Column('PRCUST_P_ID', Integer),
Column('PRCUST_Text', String(240)),
Column('PRCUST_Timestamp', DateTime),
)
project_country_table = Table('prc_projectcountry', metadata,
Column('PRC_Timestamp', DateTime),
)
company_table = Table('c_company', metadata,
Column('C_ID', Integer, primary_key=True),
Column('C_Name', String(200), key='name'),
Column('C_SortName', String(200)),
Column('C_Timestamp', DateTime),
)
location_table = Table('loc_location', metadata,
Column('LOC_ID', Integer, primary_key=True, key='id_'),
Column('LOC_L1', Integer, key='layer1'),
Column('LOC_L2', Integer, key='layer2'),
Column('LOC_Timestamp', DateTime, key='timestamp'),
)
value_department_table = Table('value_department', metadata,
Column('VDEP_ID', Integer, primary_key=True),
Column('VDEP_L1', Integer, key='layer1'),
Column('VDEP_L2', Integer, key='layer2'),
Column('VDEP_Timestamp', DateTime),
)
address_table = Table('a_address', metadata,
Column('A_ID', Integer, primary_key=True),
Column('A_VAT_ID', Integer), # TODO: link entries
Column('A_C_ID', Integer, ForeignKey('c_company.C_ID')),
Column('A_Timestamp', DateTime),
)
value_country_table = Table('value_country', metadata,
Column('VC_ID', Integer, primary_key=True),
Column('VC_TelPrefix', String(10)),
Column('VC_NoTelCityPrefix', Integer),
Column('VC_Timestamp', DateTime),
)
value_employee_function_table = Table('value_employeefunc', metadata,
Column('VEF_ID', Integer, primary_key=True),
Column('VEF_Name_en', String(50), key='name'),
Column('VEF_Name_de', String(50), key='name_de'),
Column('VEF_Timestamp', DateTime),
)
value_costcenter_table = Table('value_costcenter', metadata,
Column('VCC_Name', String(50), key='name'),
)
value_salaryregion_table = Table('value_salaryregion', metadata,
Column('VSR_ID', Integer, primary_key=True),
Column('VSR_Name_en', String(50), key='name'),
Column('VSR_Name_de', String(50), key='name_de'),
)
value_salaryregioncost_table = Table('value_salaryregioncosts', metadata,
src/s/k/skink-HEAD/skink/lib/sqlalchemy/databases/mssql.py skink(Download)
import datetime, decimal, inspect, operator, re, sys, urllib from sqlalchemy import sql, schema, exc, util from sqlalchemy import Table, MetaData, Column, ForeignKey, String, Integer from sqlalchemy.sql import select, compiler, expression, operators as sql_operators, functions as sql_functions from sqlalchemy.engine import default, base from sqlalchemy import types as sqltypes
ischema = MetaData()
schemata = Table("SCHEMATA", ischema,
Column("CATALOG_NAME", String, key="catalog_name"),
Column("SCHEMA_NAME", String, key="schema_name"),
Column("SCHEMA_OWNER", String, key="schema_owner"),
schema="INFORMATION_SCHEMA")
tables = Table("TABLES", ischema,
Column("TABLE_TYPE", String, key="table_type"),
schema="INFORMATION_SCHEMA")
columns = Table("COLUMNS", ischema,
Column("TABLE_SCHEMA", String, key="table_schema"),
Column("TABLE_NAME", String, key="table_name"),
Column("COLUMN_NAME", String, key="column_name"),
Column("COLLATION_NAME", String, key="collation_name"),
schema="INFORMATION_SCHEMA")
constraints = Table("TABLE_CONSTRAINTS", ischema,
Column("TABLE_SCHEMA", String, key="table_schema"),
Column("TABLE_NAME", String, key="table_name"),
Column("CONSTRAINT_NAME", String, key="constraint_name"),
Column("CONSTRAINT_TYPE", String, key="constraint_type"),
schema="INFORMATION_SCHEMA")
column_constraints = Table("CONSTRAINT_COLUMN_USAGE", ischema,
Column("CONSTRAINT_NAME", String, key="constraint_name"),
schema="INFORMATION_SCHEMA")
key_constraints = Table("KEY_COLUMN_USAGE", ischema,
Column("TABLE_SCHEMA", String, key="table_schema"),
Column("TABLE_NAME", String, key="table_name"),
Column("COLUMN_NAME", String, key="column_name"),
Column("CONSTRAINT_NAME", String, key="constraint_name"),
Column("ORDINAL_POSITION", Integer, key="ordinal_position"),
schema="INFORMATION_SCHEMA")
ref_constraints = Table("REFERENTIAL_CONSTRAINTS", ischema,
src/r/e/reporter-lib-HEAD/packages/sqlalchemy/lib/sqlalchemy/dialects/mssql/information_schema.py reporter-lib(Download)
from sqlalchemy import Table, MetaData, Column, ForeignKey
from sqlalchemy.types import String, Unicode, Integer, TypeDecorator
ischema = MetaData()
class CoerceUnicode(TypeDecorator):
impl = Unicode
def process_bind_param(self, value, dialect):
if isinstance(value, str):
value = value.decode(dialect.encoding)
return value
schemata = Table("SCHEMATA", ischema,
Column("SCHEMA_OWNER", CoerceUnicode, key="schema_owner"),
schema="INFORMATION_SCHEMA")
tables = Table("TABLES", ischema,
Column("TABLE_CATALOG", CoerceUnicode, key="table_catalog"),
Column("TABLE_SCHEMA", CoerceUnicode, key="table_schema"),
Column("TABLE_NAME", CoerceUnicode, key="table_name"),
Column("TABLE_TYPE", String(convert_unicode=True), key="table_type"),
schema="INFORMATION_SCHEMA")
columns = Table("COLUMNS", ischema,
Column("COLLATION_NAME", String, key="collation_name"),
schema="INFORMATION_SCHEMA")
constraints = Table("TABLE_CONSTRAINTS", ischema,
Column("TABLE_SCHEMA", CoerceUnicode, key="table_schema"),
Column("TABLE_NAME", CoerceUnicode, key="table_name"),
Column("CONSTRAINT_NAME", CoerceUnicode, key="constraint_name"),
Column("CONSTRAINT_TYPE", String(convert_unicode=True), key="constraint_type"),
schema="INFORMATION_SCHEMA")
column_constraints = Table("CONSTRAINT_COLUMN_USAGE", ischema,
Column("CONSTRAINT_NAME", CoerceUnicode, key="constraint_name"),
schema="INFORMATION_SCHEMA")
key_constraints = Table("KEY_COLUMN_USAGE", ischema,
Column("TABLE_SCHEMA", CoerceUnicode, key="table_schema"),
Column("TABLE_NAME", CoerceUnicode, key="table_name"),
Column("COLUMN_NAME", CoerceUnicode, key="column_name"),
Column("CONSTRAINT_NAME", CoerceUnicode, key="constraint_name"),
Column("ORDINAL_POSITION", Integer, key="ordinal_position"),
schema="INFORMATION_SCHEMA")
ref_constraints = Table("REFERENTIAL_CONSTRAINTS", ischema,
Column("DELETE_RULE", String, key="delete_rule"),
schema="INFORMATION_SCHEMA")
views = Table("VIEWS", ischema,
Column("TABLE_CATALOG", CoerceUnicode, key="table_catalog"),
Column("TABLE_SCHEMA", CoerceUnicode, key="table_schema"),
Column("TABLE_NAME", CoerceUnicode, key="table_name"),
src/o/c/ocara-HEAD/ocara-ltsp/usr/lib/python2.5/site-packages/OcaraServer/db/managers.py ocara(Download)
from OcaraServer.db.models import CertidaoNascimento, Pais, State, MaritalStatus, Etnia, Address from OcaraServer.db.basemanager import BaseManager, BaseFlow from sqlalchemy import Table, Column, Boolean, Integer, String, Text from sqlalchemy import Date, DateTime, Float, ForeignKey from sqlalchemy.orm import mapper, relation from sqlalchemy.sql import select, and_, delete, update, func, exists
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Version)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, TypeDeficiency)
typeDeficiency = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Schooling)
schooling = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, SituationOccupation)
situationOccupation = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Occupation)
occupation = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, RendaFamiliar)
rendaFamiliar = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Etnia)
etnia = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, MaritalStatus)
maritalStatus = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Pais)
pais = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, State)
state = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, RegistroGeral)
registroGeral = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, CertidaoNascimento)
certidaoNascimento = Table(self.__table_name__,
self.db_session.metadata,
Column('registro', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, MachineCategory)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, UserCategory)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, AlienationMachine)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, ReasonAlienation)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, ScheduleOfBorrow)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, ReserveOfBorrow)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, DescriptionOpenDebtsOther)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Telecentro)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, DescriptionBlock)
descriptionBlock = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, DescriptionBlockBorrow)
descriptionBlockBorrow = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Block)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, BlockBorrow)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Machine)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Heritage)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Address)
address = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, User)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('nick', String(20), nullable=False, unique=True),
def __init__(self, db_session):
BaseFlow.__init__(self, db_session, CashFlowItem)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('type', Integer, nullable=False),
def __init__(self, db_session):
BaseFlow.__init__(self, db_session, OpenDebtMachineItem)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('day', Integer, nullable=False),
def __init__(self, db_session):
BaseFlow.__init__(self, db_session, OpenDebtOtherItem)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('day', Integer, nullable=False),
def __init__(self, db_session):
BaseFlow.__init__(self, db_session, HistoryItem)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('id', Integer, primary_key=True),
Column('day', Integer, nullable=False),
def __init__(self, db_session):
BaseManager.__init__(self, db_session, Cash)
self.table = Table(self.__table_name__,
self.db_session.metadata,
Column('date_time_open', DateTime, primary_key=True),
src/p/y/PyGall-HEAD/scripts/fspot_to_pygall.py PyGall(Download)
from urllib import unquote
from datetime import datetime
from sqlalchemy import create_engine, MetaData, Column, \
Table, Sequence, DateTime, UnicodeText, Integer, \
String, Unicode, ForeignKey, Boolean, not_, types
from sqlalchemy.sql import func, join, and_
fromdb_metadata = MetaData()
fromdb_tags_table = Table(
"tags", fromdb_metadata,
Column("name", Unicode()),
autoload = True, autoload_with = fromdb_engine)
# id, name, category_id, is_category, sort_priority, icon
fromdb_photo_tags_table = Table(
"photo_tags", fromdb_metadata,
# photo_id, tag_id
fromdb_photo_versions_table = Table(
"photo_versions", fromdb_metadata,
Column("photo_id", Integer(), ForeignKey('photos.id'), primary_key=True),
Column("version_id", Integer(), primary_key=True),
Column("base_uri", Unicode()),
Column("filename", Unicode()),
autoload = True, autoload_with = fromdb_engine)
# photo_id, version_id, name, base_uri, filename, md5_sum, protected
fromdb_photos_table = Table(
"photos", fromdb_metadata,
todb_metadata = MetaData()
todb_photos_table = Table(
"photos", todb_metadata,
Column('id', Integer(), Sequence('photos_seq', optional=True),
primary_key=True),
Column("uri", Unicode(), nullable=False, index=True),
# id, uri, description, rating, time
todb_tags_table = Table(
"tags", todb_metadata,
Column("id", Integer(), primary_key=True),
Column("name", Unicode(), nullable=False)
)
# id, name, category_id, is_category, sort_priority, icon
todb_photos_tags_table = Table(
"photo_tags", todb_metadata,
src/w/o/wowspyder-HEAD/wowspyder/Item.py wowspyder(Download)
import Logger
import datetime
import WoWSpyderLib
from sqlalchemy import Table, Column, ForeignKey, ForeignKeyConstraint, \
DateTime, Unicode, Integer
from sqlalchemy import and_
from sqlalchemy.ext.declarative import declarative_base
class Item(Base):
"""An item"""
__table__ = Table("ITEM", Base.metadata,
Column("item_id", Integer(), primary_key=True),
Column("name", Unicode(100), index=True),
Column("level", Integer()),
Column("quality", Integer()),
src/s/q/sqlalchemy-HEAD/lib/sqlalchemy/dialects/mssql/information_schema.py sqlalchemy(Download)
from sqlalchemy import Table, MetaData, Column, ForeignKey
from sqlalchemy.types import String, Unicode, Integer, TypeDecorator
ischema = MetaData()
class CoerceUnicode(TypeDecorator):
impl = Unicode
def process_bind_param(self, value, dialect):
if isinstance(value, str):
value = value.decode(dialect.encoding)
return value
schemata = Table("SCHEMATA", ischema,
Column("SCHEMA_OWNER", CoerceUnicode, key="schema_owner"),
schema="INFORMATION_SCHEMA")
tables = Table("TABLES", ischema,
Column("TABLE_CATALOG", CoerceUnicode, key="table_catalog"),
Column("TABLE_SCHEMA", CoerceUnicode, key="table_schema"),
Column("TABLE_NAME", CoerceUnicode, key="table_name"),
Column("TABLE_TYPE", String, key="table_type"),
schema="INFORMATION_SCHEMA")
columns = Table("COLUMNS", ischema,
Column("COLLATION_NAME", String, key="collation_name"),
schema="INFORMATION_SCHEMA")
constraints = Table("TABLE_CONSTRAINTS", ischema,
Column("TABLE_SCHEMA", CoerceUnicode, key="table_schema"),
Column("TABLE_NAME", CoerceUnicode, key="table_name"),
Column("CONSTRAINT_NAME", CoerceUnicode, key="constraint_name"),
Column("CONSTRAINT_TYPE", String, key="constraint_type"),
schema="INFORMATION_SCHEMA")
column_constraints = Table("CONSTRAINT_COLUMN_USAGE", ischema,
Column("CONSTRAINT_NAME", CoerceUnicode, key="constraint_name"),
schema="INFORMATION_SCHEMA")
key_constraints = Table("KEY_COLUMN_USAGE", ischema,
Column("TABLE_SCHEMA", CoerceUnicode, key="table_schema"),
Column("TABLE_NAME", CoerceUnicode, key="table_name"),
Column("COLUMN_NAME", CoerceUnicode, key="column_name"),
Column("CONSTRAINT_NAME", CoerceUnicode, key="constraint_name"),
Column("ORDINAL_POSITION", Integer, key="ordinal_position"),
schema="INFORMATION_SCHEMA")
ref_constraints = Table("REFERENTIAL_CONSTRAINTS", ischema,
Column("DELETE_RULE", String, key="delete_rule"),
schema="INFORMATION_SCHEMA")
views = Table("VIEWS", ischema,
Column("TABLE_CATALOG", CoerceUnicode, key="table_catalog"),
Column("TABLE_SCHEMA", CoerceUnicode, key="table_schema"),
Column("TABLE_NAME", CoerceUnicode, key="table_name"),
Previous 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 Next