]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
- Added new ENUM type to the Postgresql dialect, which exists as a schema-level
authorMike Bayer <mike_mp@zzzcomputing.com>
Sun, 25 Oct 2009 00:40:34 +0000 (00:40 +0000)
committerMike Bayer <mike_mp@zzzcomputing.com>
Sun, 25 Oct 2009 00:40:34 +0000 (00:40 +0000)
commitaa557982fa2518e6d520ce17894093d5ed03c0eb
tree5bc55ac2aa8d33de635c380f775e642c52bc7d8c
parent82ea898ab06063ebac631f4e375331550a226687
- Added new ENUM type to the Postgresql dialect, which exists as a schema-level
construct and extends the generic Enum type.  Automatically
associates itself with tables and their parent metadata
to issue the appropriate CREATE TYPE/DROP TYPE
commands as needed, supports unicode labels, supports
reflection.  [ticket:1511]

- MySQL ENUM now subclasses the new generic Enum type, and also handles
unicode values implicitly, if the given labelnames are unicode
objects.

- Added a new Enum generic type, currently supported on
Postgresql and MySQL.  Enum is a schema-aware object
to support databases which require specific DDL in
order to use enum or equivalent; in the case of PG
it handles the details of `CREATE TYPE`, and on
other databases without native enum support can
support generation of CHECK constraints.
[ticket:1109] [ticket:1511]

- types documentation updates

- some cleanup on schema/expression docs
12 files changed:
CHANGES
doc/build/reference/sqlalchemy/schema.rst
doc/build/reference/sqlalchemy/types.rst
lib/sqlalchemy/__init__.py
lib/sqlalchemy/dialects/mysql/base.py
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/schema.py
lib/sqlalchemy/sql/compiler.py
lib/sqlalchemy/sql/expression.py
lib/sqlalchemy/types.py
test/dialect/test_mysql.py
test/dialect/test_postgresql.py