Python simple_setupの例

コード例 #1

ファイル: cascade_speed.py プロジェクト: Frihet/sqlalchemy-patches

import testenv; testenv.simple_setup()
from sqlalchemy import *
from sqlalchemy.orm import *
from timeit import Timer
import sys


meta = MetaData()

orders = Table('orders', meta,
    Column('id', Integer, Sequence('order_id_seq'), primary_key = True),
)
items = Table('items', meta,
    Column('id', Integer, Sequence('item_id_seq'), primary_key = True),
    Column('order_id', Integer, ForeignKey(orders.c.id), nullable=False),
)
attributes = Table('attributes', meta,
    Column('id', Integer, Sequence('attribute_id_seq'), primary_key = True),
    Column('item_id', Integer, ForeignKey(items.c.id), nullable=False),
)
values = Table('values', meta,
    Column('id', Integer, Sequence('value_id_seq'), primary_key = True),
    Column('attribute_id', Integer, ForeignKey(attributes.c.id), nullable=False),
)

class Order(object): pass
class Item(object): pass
class Attribute(object): pass
class Value(object): pass

コード例 #2

ファイル: cascade_speed.py プロジェクト: Mozilla-GitHub-Standards/441e91400508d94b5a6931d7693918293007697b91395acd9460441a437990ec

import testenv; testenv.simple_setup()
from sqlalchemy import *
from sqlalchemy.orm import *
from timeit import Timer
import sys


meta = MetaData()

orders = Table('orders', meta,
    Column('id', Integer, Sequence('order_id_seq'), primary_key = True),
)
items = Table('items', meta,
    Column('id', Integer, Sequence('item_id_seq'), primary_key = True),
    Column('order_id', Integer, ForeignKey(orders.c.id), nullable=False),
)
attributes = Table('attributes', meta,
    Column('id', Integer, Sequence('attribute_id_seq'), primary_key = True),
    Column('item_id', Integer, ForeignKey(items.c.id), nullable=False),
)
values = Table('values', meta,
    Column('id', Integer, Sequence('value_id_seq'), primary_key = True),
    Column('attribute_id', Integer, ForeignKey(attributes.c.id), nullable=False),
)

class Order(object): pass
class Item(object): pass
class Attribute(object): pass
class Value(object): pass

コード例 #3

import testenv

testenv.simple_setup()
import time, gc, resource
from sqlalchemy import *
from sqlalchemy.orm import *

db = create_engine('sqlite://')
metadata = MetaData(db)
Person_table = Table('Person', metadata, Column('id',
                                                Integer,
                                                primary_key=True),
                     Column('name', String(40)), Column('sex', Integer),
                     Column('age', Integer))


class RawPerson(object):
    pass


class Person(object):
    pass


mapper(Person, Person_table)
compile_mappers()


def setup():
    metadata.create_all()
    i = Person_table.insert()

コード例 #4

import testenv

testenv.simple_setup()
import time, gc, resource
from sqlalchemy import *
from sqlalchemy.orm import *


db = create_engine("sqlite://")
metadata = MetaData(db)
Person_table = Table(
    "Person",
    metadata,
    Column("id", Integer, primary_key=True),
    Column("name", String(40)),
    Column("sex", Integer),
    Column("age", Integer),
)


class RawPerson(object):
    pass


class Person(object):
    pass


mapper(Person, Person_table)
compile_mappers()