[Sqlalchemy-tickets] Issue #4341: create_constraint=False not respected when inheritted (zzzeek/sql
Brought to you by:
zzzeek
From: moon c. <iss...@bi...> - 2018-09-25 05:06:22
|
New issue 4341: create_constraint=False not respected when inheritted https://bitbucket.org/zzzeek/sqlalchemy/issues/4341/create_constraint-false-not-respected-when moon cake: Test case: ```py import enum from sqlalchemy import Column, Enum, Integer from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.schema import CreateTable TableBase = declarative_base() class Language(enum.Enum): english = 'English' class Test(TableBase): __tablename__ = 'enum' id = Column(Integer, primary_key=True) language = Column(Enum(Language, native_enum=False, create_constraint=False)) class TestBase(TableBase): __abstract__ = True id = Column(Integer, primary_key=True) language = Column(Enum(Language, native_enum=False, create_constraint=False)) class TestInheritted(TestBase): __tablename__ = 'enum_inheritted' print(CreateTable(Test.__table__)) print(CreateTable(TestInheritted.__table__)) ``` Output: ``` CREATE TABLE enum ( id INTEGER NOT NULL, language VARCHAR(7), PRIMARY KEY (id) ) CREATE TABLE enum_inheritted ( id INTEGER NOT NULL, language VARCHAR(7), PRIMARY KEY (id), CONSTRAINT language CHECK (language IN ('english')) ) ``` |