From eb554a04444b191d927490d2fc8b3764b2b4d5f4 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 30 Dec 2005 00:24:03 +0000 Subject: [PATCH] adjustments for oracle sequences --- test/manytomany.py | 4 ++-- test/tables.py | 6 +++--- 2 files changed, 5 insertions(+), 5 deletions(-) diff --git a/test/manytomany.py b/test/manytomany.py index 6d011264bc..daa95a070c 100644 --- a/test/manytomany.py +++ b/test/manytomany.py @@ -22,13 +22,13 @@ class M2MTest(testbase.AssertMixin): db = testbase.db global place place = Table('place', db, - Column('place_id', Integer, primary_key=True), + Column('place_id', Integer, Sequence('pid_seq', optional=True), primary_key=True), Column('name', String(30), nullable=False), ) global transition transition = Table('transition', db, - Column('transition_id', Integer, primary_key=True), + Column('transition_id', Integer, Sequence('tid_seq', optional=True), primary_key=True), Column('name', String(30), nullable=False), ) diff --git a/test/tables.py b/test/tables.py index d0d0692488..4dad1a8e90 100644 --- a/test/tables.py +++ b/test/tables.py @@ -23,20 +23,20 @@ addresses = Table('email_addresses', db, ) orders = Table('orders', db, - Column('order_id', Integer, primary_key = True), + Column('order_id', Integer, Sequence('order_id_seq', optional=True), primary_key = True), Column('user_id', Integer, ForeignKey(users.c.user_id)), Column('description', String(50)), Column('isopen', Integer) ) orderitems = Table('items', db, - Column('item_id', INT, primary_key = True), + Column('item_id', INT, Sequence('items_id_seq', optional=True), primary_key = True), Column('order_id', INT, ForeignKey("orders")), Column('item_name', VARCHAR(50)) ) keywords = Table('keywords', db, - Column('keyword_id', Integer, primary_key = True), + Column('keyword_id', Integer, Sequence('keyword_id_seq', optional=True), primary_key = True), Column('name', VARCHAR(50)) ) -- 2.47.2