Propel enum with validation

482 Views Asked by At

I have a user table with an enum field for gender with the options male / female. If I create a user an Exception is thrown if I try to set the gender to for example 'transgender'.

Is it possible to allow setting transgender to 'transgender' and only get a validation error if I call the validate() function? So it is validated together with the other fields?

Schema.xml:

<table name="user" idMethod="native" namespace="Models" package="Models">
    <column name="id" type="INTEGER" sqlType="INTEGER(11) UNSIGNED" primaryKey="true" autoIncrement="true" required="true"/>
    <column name="first_name" type="VARCHAR" required="true"/>
    <column name="mail" type="VARCHAR" required="true"/>
    <column name="gender" type="ENUM" valueSet="male, female"/>
    <behavior name="validate">
        <parameter name="rule1" value="{column: first_name, validator: NotNull}" />
        <parameter name="rule2" value="{column: mail, validator: NotNull}" />
        <parameter name="rule3" value="{column: gender, validator: NotNull}" />
        <parameter name="rule4" value="{column: gender, validator: ValidEnum}" />
    </behavior>
</table>

PHP code:

$user = new User();
$user->setFirstName('John');
$user->setMail('[email protected]');
$user->setGender('transgender'); // currently throws an exception 
if ($user->validate()) {
    $user->save();
} else {
    // handle exception
}
1

There are 1 best solutions below

0
On

Since you might get an exception, then perhaps wrap this in a try-catch block.

try {
    $user = new User();
    $user->setFirstName('John');
    $user->setMail('[email protected]');
    $user->setGender('transgender'); // currently throws an exception 
    $user->save();
} catch (PropelException $e) {
    echo $e->getMessage(); // Value "transgender" is not accepted in this enumerated column
}