Propel validation for unique key pair

Question

In my database user_group table UNIQUE_KEY consist of two columns , user_id and user_group_id. This is how it looks like in propel schema :

<unique name="UNIQUE_KEY">
            <unique-column name="user_id"/>
            <unique-column name="user_group_id"/>
</unique>

If it is about one column then you can set validation behavior like below :

<behavior name="validate">
     <parameter name="rule1"
     value="{column: column_name, validator: Unique, options {message:Your validation message here.}}"/>
</behavior>

So what I wanted to know is how to set unique validation for key pair user_id and user_group_id. Is there any possibility to pass an array of column_names ?? Any suggestions will be appreciable. Thank you .

Answer 1

This features is not available yet, but you have a few options:

1. Handle the duplicates yourself:

// First check for a duplicate
$duplicates = TableAQuery::create()
  ->filterByKey1($key1)
  ->filterByKey2($key2)
  ->count();

if ($duplicates>0) {
    throw new \PropelException('Row already exists');
}
// No duplicate, add the new row

2. Handle the underlying duplicate Databases's INSERT INTO violation via try-catch:

 try{
     $obj->save();
 } catch (PropelException $e) {
     if (stripos($e->getMessage(), ' duplicate key ') !== false) {
         throw new \PropelException('Row already exists');
     }
 }

Option 2 might be less painful if performance is an issue as it saves you a query, but may increase your auto_increment (esp. on MySQL) if have not configured it to ignore duplicate inserts.