Symfony Bulk Update with Propel
By marc • May 12th, 2008 • Category: SymfonyHere is a quick example of how to do a bulk update with Propel within symfony. This is based on this code snippet on the symfony site. I thought it was extremely useful, so I wanted to post it as an easy reference for myself and others.
Suppose we had a query which looked like this:
-
-
UPDATE articles SET STATUS = 0 WHERE user_id = 10;
Here is how we would translate it into symfony/propel terms:
-
-
// set the select condition criteria
-
$c = new Criteria();
-
$c->add(ArticlePeer::USER_ID, 10);
-
-
// set the update criteria
-
$update = new Criteria();
-
$update->add(ArticlePeer::STATUS, 0);
-
-
// we need the connection for update, so get default connection
-
$con = Propel::getConnection();
-
-
// finally, do the update
-
BasePeer::doUpdate($c, $update, $con);
We are just creating the first criteria to find all the objects that we want to select and then update. Then creating the second one that specifies which values we are updating. Easy!
The main thing to notice is that we are using the ‘BasePeer’ class, so you need to make sure that you explicitly pass in a connection, otherwise it won’t work as expected!
Thanks, needed it, googled it, applied it)
I wish only propel’s syntax become more simple