Defining SQLAlchemy enum column length

Question

I would like to know if it is possible to define with SQLAlchemy the length of an enum type field. In my case the classes are defined as follows:

EnumTest.py

from enum import Enum


class EnumTest(str, Enum):
    EnumTest1 = "EnumTest1"
    EnumTest2 = "EnumTest2"
    EnumTest3 = "EnumTest3"

TestTable.py

from models import Base
from sqlalchemy import Column, Enum, String

from .EnumTest import EnumTest


class TestTable(Base):

    __tablename__ = "test"

    id = Column(String(50), primary_key=True)
    my_enum = Column(Enum(EnumTest), nullable=False)

My goal is to create a field called my_enum of type character varying of length 50 as in the case of the id field.

sudden_appearance · Accepted Answer · 2022-03-04 11:19:42Z

1

Docs say

The Enum type will make use of the backend’s native “ENUM” type if one is available; otherwise, it uses a VARCHAR datatype

...

length – allows specifying a custom length for the VARCHAR when Enum.native_enum is False. By default it uses the length of the longest value.

So, you can set native_enum=False and length=50. It might look like this

my_enum = Column(Enum(EnumTest, native_enum=False, length=50), nullable=False)

answered Mar 4, 2022 at 11:19

sudden_appearance

2,2131 gold badge6 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Defining SQLAlchemy enum column length

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related