diff options
| author | Michael Trier <mtrier@gmail.com> | 2008-12-28 07:40:56 +0000 |
|---|---|---|
| committer | Michael Trier <mtrier@gmail.com> | 2008-12-28 07:40:56 +0000 |
| commit | cae83f6d4fc3eef57814e6bd554bc39461644359 (patch) | |
| tree | 6fa7468f27e727b43e6d5eeaf9080363e0639af1 /test/dialect/mssql.py | |
| parent | defba2fc020556dadd106e7e4e35907216d9208d (diff) | |
| download | sqlalchemy-cae83f6d4fc3eef57814e6bd554bc39461644359.tar.gz | |
On MSSQL if a field is part of the primary_key then it should not allow NULLS.
Diffstat (limited to 'test/dialect/mssql.py')
| -rwxr-xr-x | test/dialect/mssql.py | 17 |
1 files changed, 7 insertions, 10 deletions
diff --git a/test/dialect/mssql.py b/test/dialect/mssql.py index b87a1566e..c4056fd9b 100755 --- a/test/dialect/mssql.py +++ b/test/dialect/mssql.py @@ -252,8 +252,9 @@ class GenerativeQueryTest(TestBase): class SchemaTest(TestBase): def setUp(self): - t = Table('sometable', MetaData(), - Column('test_column', Integer) + t = Table('sometable', MetaData(), + Column('pk_column', Integer), + Column('test_column', String) ) self.column = t.c.test_column @@ -262,8 +263,7 @@ class SchemaTest(TestBase): mssql.MSSQLDialect().schemagenerator(mssql.MSSQLDialect(), None) column_specification = \ schemagenerator.get_column_specification(self.column) - assert "test_column INTEGER NULL" == column_specification, \ - column_specification + eq_("test_column VARCHAR NULL", column_specification) def test_that_mssql_none_nullability_does_not_emit_nullability(self): schemagenerator = \ @@ -271,8 +271,7 @@ class SchemaTest(TestBase): self.column.nullable = None column_specification = \ schemagenerator.get_column_specification(self.column) - assert "test_column INTEGER" == column_specification, \ - column_specification + eq_("test_column VARCHAR", column_specification) def test_that_mssql_specified_nullable_emits_null(self): schemagenerator = \ @@ -280,8 +279,7 @@ class SchemaTest(TestBase): self.column.nullable = True column_specification = \ schemagenerator.get_column_specification(self.column) - assert "test_column INTEGER NULL" == column_specification, \ - column_specification + eq_("test_column VARCHAR NULL", column_specification) def test_that_mssql_specified_not_nullable_emits_not_null(self): schemagenerator = \ @@ -289,8 +287,7 @@ class SchemaTest(TestBase): self.column.nullable = False column_specification = \ schemagenerator.get_column_specification(self.column) - assert "test_column INTEGER NOT NULL" == column_specification, \ - column_specification + eq_("test_column VARCHAR NOT NULL", column_specification) def full_text_search_missing(): |