antiloopgmbh/propel-real-enum-behavior

Propel 2 behavior to manage the ENUM type more closely to what enums should be

3.0.0 2024-04-05 09:37 UTC

Requires

• php: >=7.4
• propel/propel: ^2.0.0

MIT

README

Requirements

This Behavior was developed for Propel 2.
It was also only tested for MariaDb databases for Spryker Webshops.

Installation

composer require antiloop/propel-real-enum-behavior

schema.xml

Add the behavior either to the root of your database or on the target table.
Here are two examples:

<database ...>
    <!-- This will add the real-enum behavior for all enums in the database -->
    <behavior name="real-enum"/>
    <table name="my_table">        
        <column name="my_enum" type="ENUM" valueSet="FIRST,SECOND,THIRD" />
    </table>
</database>

<database ...>
    <table name="my_table">
        <!-- This will add the real-enum behavior for all enums in the table -->
        <behavior name="real-enum"/>
        <column name="my_enum" type="ENUM" valueSet="FIRST,SECOND,THIRD" />
    </table>
</database>

Usage

This behavior does one thing to make usage of ENUMS easier :

• You will now see the ENUM value from the valueSet in the database instead of a number.