From 72b1f475afe8892edf8fd6d966244ff7c5d31228 Mon Sep 17 00:00:00 2001 From: Derek Harland Date: Tue, 4 Dec 2012 14:49:03 +1300 Subject: [PATCH] Add several MSSQL dialect tests for sequence declarations --- test/dialect/test_mssql.py | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) diff --git a/test/dialect/test_mssql.py b/test/dialect/test_mssql.py index bf4e937587..f1c4b4df42 100644 --- a/test/dialect/test_mssql.py +++ b/test/dialect/test_mssql.py @@ -483,6 +483,30 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): checkparams={u'x_1': 5} ) + def test_sequence_start_0(self): + metadata = MetaData() + tbl = Table('test', metadata, + Column('id', Integer, Sequence('', 0), primary_key=True)) + self.assert_compile(schema.CreateTable(tbl), + "CREATE TABLE test (id INTEGER NOT NULL IDENTITY(0,1), " + "PRIMARY KEY (id))" + ) + + def test_sequence_non_primary_key(self): + metadata = MetaData() + tbl = Table('test', metadata, + Column('id', Integer, Sequence(''), primary_key=False)) + self.assert_compile(schema.CreateTable(tbl), + "CREATE TABLE test (id INTEGER NOT NULL IDENTITY(1,1))" + ) + + def test_sequence_ignore_nullability(self): + metadata = MetaData() + tbl = Table('test', metadata, + Column('id', Integer, Sequence(''), nullable=True)) + self.assert_compile(schema.CreateTable(tbl), + "CREATE TABLE test (id INTEGER NOT NULL IDENTITY(1,1))" + ) class SchemaAliasingTest(fixtures.TestBase, AssertsCompiledSQL): """SQL server cannot reference schema-qualified tables in a SELECT statement, they -- 2.47.3