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_sequence.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_sequence.py')
| -rw-r--r-- | lib/sqlalchemy/testing/suite/test_sequence.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/lib/sqlalchemy/testing/suite/test_sequence.py b/lib/sqlalchemy/testing/suite/test_sequence.py index de970da53..d8c35ed0b 100644 --- a/lib/sqlalchemy/testing/suite/test_sequence.py +++ b/lib/sqlalchemy/testing/suite/test_sequence.py @@ -105,7 +105,9 @@ class HasSequenceTest(fixtures.TablesTest): @classmethod def define_tables(cls, metadata): Sequence("user_id_seq", metadata=metadata) - Sequence("other_seq", metadata=metadata) + Sequence( + "other_seq", metadata=metadata, nomaxvalue=True, nominvalue=True + ) if testing.requires.schemas.enabled: Sequence( "user_id_seq", schema=config.test_schema, metadata=metadata |