diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2011-01-16 20:18:32 -0500 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2011-01-16 20:18:32 -0500 |
commit | a9a67667901e24eefb36e01334eed9bf25b2b144 (patch) | |
tree | fc28a4040ca71d69416da59d2102583ba9563c70 /test/zblog/tables.py | |
parent | 7325ba60bce50c63ce83fcb44f6b337664262ad0 (diff) | |
download | sqlalchemy-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.py | 53 |
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), - ) |