summaryrefslogtreecommitdiff
path: root/test/zblog/tables.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2011-01-16 20:18:32 -0500
committerMike Bayer <mike_mp@zzzcomputing.com>2011-01-16 20:18:32 -0500
commita9a67667901e24eefb36e01334eed9bf25b2b144 (patch)
treefc28a4040ca71d69416da59d2102583ba9563c70 /test/zblog/tables.py
parent7325ba60bce50c63ce83fcb44f6b337664262ad0 (diff)
downloadsqlalchemy-a9a67667901e24eefb36e01334eed9bf25b2b144.tar.gz
- the zblog example is obsolete, the tests don't really test it
and a key feature of its mapping (the deferred col outside of the select) doesn't work anyway. - add a token "deferred on selectable" test to test_mapper.
Diffstat (limited to 'test/zblog/tables.py')
-rw-r--r--test/zblog/tables.py53
1 files changed, 0 insertions, 53 deletions
diff --git a/test/zblog/tables.py b/test/zblog/tables.py
deleted file mode 100644
index 3326c28fb..000000000
--- a/test/zblog/tables.py
+++ /dev/null
@@ -1,53 +0,0 @@
-"""application table metadata objects are described here."""
-
-from sqlalchemy import *
-from test.lib.schema import Table, Column
-
-metadata = MetaData()
-
-users = Table('users', metadata,
- Column('user_id', Integer, primary_key=True, test_needs_autoincrement=True),
- Column('user_name', String(30), nullable=False),
- Column('fullname', String(100), nullable=False),
- Column('password', String(40), nullable=False),
- Column('groupname', String(20), nullable=False),
- )
-
-blogs = Table('blogs', metadata,
- Column('blog_id', Integer, primary_key=True, test_needs_autoincrement=True),
- Column('owner_id', Integer, ForeignKey('users.user_id'), nullable=False),
- Column('name', String(100), nullable=False),
- Column('description', String(500))
- )
-
-posts = Table('posts', metadata,
- Column('post_id', Integer, primary_key=True, test_needs_autoincrement=True),
- Column('blog_id', Integer, ForeignKey('blogs.blog_id'), nullable=False),
- Column('user_id', Integer, ForeignKey('users.user_id'), nullable=False),
- Column('datetime', DateTime, nullable=False),
- Column('headline', String(500)),
- Column('summary', String(255)),
- Column('body', Text),
- )
-
-topics = Table('topics', metadata,
- Column('topic_id', Integer, primary_key=True, test_needs_autoincrement=True),
- Column('keyword', String(50), nullable=False),
- Column('description', String(500))
- )
-
-topic_xref = Table('topic_post_xref', metadata,
- Column('topic_id', Integer, ForeignKey('topics.topic_id'), nullable=False),
- Column('is_primary', Boolean, nullable=False),
- Column('post_id', Integer, ForeignKey('posts.post_id'), nullable=False)
- )
-
-comments = Table('comments', metadata,
- Column('comment_id', Integer, primary_key=True, test_needs_autoincrement=True),
- Column('user_id', Integer, ForeignKey('users.user_id'), nullable=False),
- Column('post_id', Integer, ForeignKey('posts.post_id'), nullable=False),
- Column('datetime', DateTime, nullable=False),
- Column('parent_comment_id', Integer, ForeignKey('comments.comment_id')),
- Column('subject', String(500)),
- Column('body', Text),
- )