From 4497f5e30629488b3ac7d860d2dc55d225c1dde5 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sat, 17 Sep 2005 07:22:23 +0000 Subject: [PATCH] --- test/tables.py | 95 +++++++++++++++++++++++++++----------------------- 1 file changed, 51 insertions(+), 44 deletions(-) diff --git a/test/tables.py b/test/tables.py index 0c87d9da46..81fe8f90f9 100644 --- a/test/tables.py +++ b/test/tables.py @@ -52,60 +52,67 @@ itemkeywords = Table('itemkeywords', db, ) users.build() -users.insert().execute( - dict(user_id = 7, user_name = 'jack'), - dict(user_id = 8, user_name = 'ed'), - dict(user_id = 9, user_name = 'fred') -) + +if DATA: + 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.build() -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") -) +if DATA: + 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.build() -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) -) +if DATA: + 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.build() -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') -) +if DATA: + 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.build() -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') -) +if DATA: + 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.build() -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) -) +if DATA: + 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() -- 2.47.2