1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
# Copyright: See the LICENSE file.
"""Helpers for testing SQLAlchemy apps."""
from sqlalchemy import Column, Integer, Unicode, create_engine
from sqlalchemy.orm import declarative_base, scoped_session, sessionmaker
engine_name = 'sqlite://'
session = scoped_session(sessionmaker())
engine = create_engine(engine_name)
session.configure(bind=engine)
Base = declarative_base()
class StandardModel(Base):
__tablename__ = 'StandardModelTable'
id = Column(Integer(), primary_key=True)
foo = Column(Unicode(20))
class MultiFieldModel(Base):
__tablename__ = 'MultiFieldModelTable'
id = Column(Integer(), primary_key=True)
foo = Column(Unicode(20))
slug = Column(Unicode(20), unique=True)
class MultifieldUniqueModel(Base):
__tablename__ = 'MultiFieldUniqueModelTable'
id = Column(Integer(), primary_key=True)
slug = Column(Unicode(20), unique=True)
text = Column(Unicode(20), unique=True)
title = Column(Unicode(20), unique=True)
class NonIntegerPk(Base):
__tablename__ = 'NonIntegerPk'
id = Column(Unicode(20), primary_key=True)
class SpecialFieldModel(Base):
__tablename__ = 'SpecialFieldModelTable'
id = Column(Integer(), primary_key=True)
session = Column(Unicode(20))
|
