diff options
| author | Federico Caselli <cfederico87@gmail.com> | 2020-09-19 22:29:38 +0200 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2020-09-28 18:11:12 -0400 |
| commit | 7362d454f46107cae4076ce54e9fa430c3370734 (patch) | |
| tree | ae7545a99a76995ef31a879f09fb1c0fe6764f4b /lib/sqlalchemy/testing/suite/test_select.py | |
| parent | c3f102c9fe9811fd5286628cc6aafa5fbc324621 (diff) | |
| download | sqlalchemy-7362d454f46107cae4076ce54e9fa430c3370734.tar.gz | |
Add reflection for Identity columns
Added support for reflecting "identity" columns, which are now returned
as part of the structure returned by :meth:`_reflection.Inspector.get_columns`.
When reflecting full :class:`_schema.Table` objects, identity columns will
be represented using the :class:`_schema.Identity` construct.
Fixed compilation error on oracle for sequence and identity column
``nominvalue`` and ``nomaxvalue`` options that require no space in them.
Improved test compatibility with oracle 18.
As part of the support for reflecting :class:`_schema.Identity` objects,
the method :meth:`_reflection.Inspector.get_columns` no longer returns
``mssql_identity_start`` and ``mssql_identity_increment`` as part of the
``dialect_options``. Use the information in the ``identity`` key instead.
The mssql dialect will assume that at least MSSQL 2005 is used.
There is no hard exception raised if a previous version is detected,
but operations may fail for older versions.
Fixes: #5527
Fixes: #5324
Change-Id: If039fe637c46b424499e6bac54a2cbc0dc54cb57
Diffstat (limited to 'lib/sqlalchemy/testing/suite/test_select.py')
| -rw-r--r-- | lib/sqlalchemy/testing/suite/test_select.py | 11 |
1 files changed, 4 insertions, 7 deletions
diff --git a/lib/sqlalchemy/testing/suite/test_select.py b/lib/sqlalchemy/testing/suite/test_select.py index b0fb60c5f..224826c25 100644 --- a/lib/sqlalchemy/testing/suite/test_select.py +++ b/lib/sqlalchemy/testing/suite/test_select.py @@ -1047,7 +1047,9 @@ class IdentityColumnTest(fixtures.TablesTest): Column( "id", Integer, - Identity(always=True, start=42), + Identity( + always=True, start=42, nominvalue=True, nomaxvalue=True + ), primary_key=True, ), Column("desc", String(100)), @@ -1058,12 +1060,7 @@ class IdentityColumnTest(fixtures.TablesTest): Column( "id", Integer, - Identity( - increment=-5, - start=0, - minvalue=-1000, - maxvalue=0, - ), + Identity(increment=-5, start=0, minvalue=-1000, maxvalue=0), primary_key=True, ), Column("desc", String(100)), |