diff options
Diffstat (limited to 'test')
| -rw-r--r-- | test/engine/reflection.py | 17 | ||||
| -rw-r--r-- | test/sql/query.py | 16 |
2 files changed, 32 insertions, 1 deletions
diff --git a/test/engine/reflection.py b/test/engine/reflection.py index a7d18b7b6..cb12560ea 100644 --- a/test/engine/reflection.py +++ b/test/engine/reflection.py @@ -464,10 +464,25 @@ class ReflectionTest(PersistTest): meta2 = MetaData(testbase.db) try: table2 = Table('identity_test', meta2, autoload=True) - print table2.c['col1'].sequence + assert table2.c['col1'].sequence.start == 2 + assert table2.c['col1'].sequence.increment == 3 finally: table.drop() + def testreserved(self): + # check a table that uses an SQL reserved name doesn't cause an error + meta = MetaData(testbase.db) + table = Table( + 'select', meta, + Column('col1', Integer, primary_key=True) + ) + table.create() + + meta2 = MetaData(testbase.db) + try: + table2 = Table('select', meta2, autoload=True) + finally: + table.drop() class CreateDropTest(PersistTest): def setUpAll(self): diff --git a/test/sql/query.py b/test/sql/query.py index 91587bc0e..8af5aafea 100644 --- a/test/sql/query.py +++ b/test/sql/query.py @@ -458,6 +458,22 @@ class QueryTest(PersistTest): finally: tbl.drop() con.execute('drop schema paj') + + @testbase.supported('mssql') + def test_insertid_reserved(self): + meta = MetaData(testbase.db) + table = Table( + 'select', meta, + Column('col', Integer, primary_key=True) + ) + table.create() + + meta2 = MetaData(testbase.db) + try: + table.insert().execute(col=7) + finally: + table.drop() + def test_in_filtering(self): """test the 'shortname' field on BindParamClause.""" |