]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Add support for identity columns
authorFederico Caselli <cfederico87@gmail.com>
Sat, 30 May 2020 12:45:00 +0000 (14:45 +0200)
committerFederico Caselli <cfederico87@gmail.com>
Tue, 18 Aug 2020 22:34:23 +0000 (00:34 +0200)
commit26e8d3b5bdee50192e3426fba48e6b326e428e0b
tree0893364e2ddcf171cdcf1cb461b09d8a00664d21
parent0901190bb440580f0664fe3f6310173762b908e0
Add support for identity columns

Added the :class:`_schema.Identity` construct that can be used to
configure identity columns rendered with GENERATED { ALWAYS |
BY DEFAULT } AS IDENTITY. Currently the supported backends are
PostgreSQL >= 10, Oracle >= 12 and MSSQL (with different syntax
and a subset of functionalities).

Fixes: #5362
Fixes: #5324
Fixes: #5360
Change-Id: Iecea6f3ceb36821e8b96f0b61049b580507a1875
21 files changed:
doc/build/changelog/unreleased_14/5362.rst [new file with mode: 0644]
doc/build/core/defaults.rst
lib/sqlalchemy/__init__.py
lib/sqlalchemy/dialects/mssql/base.py
lib/sqlalchemy/dialects/oracle/base.py
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/schema.py
lib/sqlalchemy/sql/compiler.py
lib/sqlalchemy/sql/schema.py
lib/sqlalchemy/testing/plugin/pytestplugin.py
lib/sqlalchemy/testing/requirements.py
lib/sqlalchemy/testing/suite/test_select.py
test/dialect/mssql/test_compiler.py
test/dialect/mssql/test_query.py
test/dialect/mssql/test_reflection.py
test/dialect/oracle/test_compiler.py
test/dialect/postgresql/test_compiler.py
test/orm/test_defaults.py
test/requirements.py
test/sql/test_computed.py
test/sql/test_identity_column.py [new file with mode: 0644]