From 3afb680e45dbfd76e0e1c3aba4bfb0707397e850 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 23 Oct 2005 16:42:42 +0000 Subject: [PATCH] --- test/sequence.py | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 test/sequence.py diff --git a/test/sequence.py b/test/sequence.py new file mode 100644 index 0000000000..c17e619d32 --- /dev/null +++ b/test/sequence.py @@ -0,0 +1,29 @@ +from testbase import PersistTest +import sqlalchemy.util as util +import unittest, sys, os +import sqlalchemy.schema as schema +import testbase +from sqlalchemy.schema import * +import sqlalchemy + +db = sqlalchemy.engine.create_engine('postgres', {'database':'test', 'host':'127.0.0.1', 'user':'scott', 'password':'tiger'}, echo=testbase.echo) +#db = sqlalchemy.engine.create_engine('oracle', {'DSN':'test', 'user':'scott', 'password':'tiger'}, echo=testbase.echo) + +class SequenceTest(PersistTest): + def testsequence(self): + table = Table("cartitems", db, + Column("cart_id", Integer, Sequence('cart_id_seq'), primary_key=True), + Column("description", String(40)), + Column("date", DateTime()) + ) + + table.create() + + table.insert().execute(description='hi') + table.insert().execute(description='there') + table.insert().execute(description='lala') + + table.select().execute().fetchall() + table.drop() +if __name__ == "__main__": + unittest.main() -- 2.47.2