Drupal 7: Controller - db_delete() syntax question

Posted by jmm42 on January 13, 2013 at 12:42am

Can someone translate this syntax:

db_delete('artwork')
  ->condition('aid', $aids, 'IN')
  ->execute

into an equivalent SQL command syntax?

This is my interpretation:

DELETE FROM {artwork} WHERE (aid = $aid)

Or, would it be:

DELETE FROM {artwork} WHERE aid IN ($aids)

But, I'm kind of confused with the 'IN' parameter.

Comments

Posted by jmm42 on January 13, 2013 at 1:11am

Based on: http://drupal.org/node/310081, the former is incorrect.

Posted by jmm42 on January 13, 2013 at 1:31am

I am confident that the latter is correct based on the API:

http://api.drupal.org/api/drupal/includes!database!query.inc/function/QueryConditionInterface%3A%3Acondition/7

However, may be 'slightly' off. It can be verified by issuing the following line:

print (string)$query;

in place of:

->execute();

Posted by Jaypan on January 13, 2013 at 4:09am

$aids is an array (it should be when you are using it with IN, or else a simple = can be used).

If $aids is this:

$aids = array(1, 30, 432);?>

Then the so called translated query would be:

<code>DELETE FROM {artwork} WHERE aid IN (1, 30, 432)

Which means delete when the aid is either 1, 30 or 432.

Jaypan We build websites