diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-10-22 06:12:05 +0000 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-10-22 06:12:05 +0000 |
commit | b8418eef7eb28adbf1eeed4b25ad6c0044ff2ec6 (patch) | |
tree | c11def95183dfcacbcc53b8b53dcd1e1d16410c5 /test/tables.py | |
parent | 65811386b0526e1f7a775c29e97344c201845eab (diff) | |
download | sqlalchemy-b8418eef7eb28adbf1eeed4b25ad6c0044ff2ec6.tar.gz |
Diffstat (limited to 'test/tables.py')
-rw-r--r-- | test/tables.py | 55 |
1 files changed, 0 insertions, 55 deletions
diff --git a/test/tables.py b/test/tables.py index 5a081e478..5fb7a0bad 100644 --- a/test/tables.py +++ b/test/tables.py @@ -71,61 +71,6 @@ if CREATE: itemkeywords.create() -if DATA: - itemkeywords.delete().execute() - keywords.delete().execute() - orderitems.delete().execute() - orders.delete().execute() - addresses.delete().execute() - users.delete().execute() - users.insert().execute( - dict(user_id = 7, user_name = 'jack'), - dict(user_id = 8, user_name = 'ed'), - dict(user_id = 9, user_name = 'fred') - ) - addresses.insert().execute( - dict(address_id = 1, user_id = 7, email_address = "jack@bean.com"), - dict(address_id = 2, user_id = 8, email_address = "ed@wood.com"), - dict(address_id = 3, user_id = 8, email_address = "ed@lala.com") - ) - orders.insert().execute( - dict(order_id = 1, user_id = 7, description = 'order 1', isopen=0), - dict(order_id = 2, user_id = 9, description = 'order 2', isopen=0), - dict(order_id = 3, user_id = 7, description = 'order 3', isopen=1), - dict(order_id = 4, user_id = 9, description = 'order 4', isopen=1), - dict(order_id = 5, user_id = 7, description = 'order 5', isopen=0) - ) - orderitems.insert().execute( - dict(item_id=1, order_id=2, item_name='item 1'), - dict(item_id=3, order_id=3, item_name='item 3'), - dict(item_id=2, order_id=2, item_name='item 2'), - dict(item_id=5, order_id=3, item_name='item 5'), - dict(item_id=4, order_id=3, item_name='item 4') - ) - keywords.insert().execute( - dict(keyword_id=1, name='blue'), - dict(keyword_id=2, name='red'), - dict(keyword_id=3, name='green'), - dict(keyword_id=4, name='big'), - dict(keyword_id=5, name='small'), - dict(keyword_id=6, name='round'), - dict(keyword_id=7, name='square') - ) - itemkeywords.insert().execute( - dict(keyword_id=2, item_id=1), - dict(keyword_id=2, item_id=2), - dict(keyword_id=4, item_id=1), - dict(keyword_id=6, item_id=1), - dict(keyword_id=7, item_id=2), - dict(keyword_id=6, item_id=3), - dict(keyword_id=3, item_id=3), - dict(keyword_id=5, item_id=2), - dict(keyword_id=4, item_id=3) - ) - -db.connection().commit() - - class User(object): def __init__(self): self.user_id = None |