public static function BotchaRecipebookModel::save in BOTCHA Spam Prevention 7.2

Same name and namespace in other branches

1. 6.2 model/botcha_recipebook.model.inc \BotchaRecipebookModel::save()
2. 6.3 model/recipebook/botcha.recipebook.model.inc \BotchaRecipebookModel::save()
3. 7.3 model/recipebook/botcha.recipebook.model.inc \BotchaRecipebookModel::save()

Save recipe book to the database.

Parameters

BotchaRecipebook $recipebook:

1 call to BotchaRecipebookModel::save()

BotchaRecipebook::save in controller/botcha_recipebook.controller.inc

File

model/botcha_recipebook.model.inc, line 45

Contains BotchaRecipebookModel class.

Class

BotchaRecipebookModel

@file Contains BotchaRecipebookModel class.

Code

public static function save($recipebook) {

  // Catching of PDOException helps to avoid WSOD during update use case. The
  // reason is in that form_alter is called before performing an update.
  // @see http://drupal.org/node/1828710
  try {
    db_delete('botcha_recipebook_recipe')
      ->condition('rbid', $recipebook->id)
      ->execute();
    db_delete('botcha_recipebook_form')
      ->condition('rbid', $recipebook->id)
      ->execute();
    if (!$recipebook instanceof BotchaRecipebookNone) {
      db_merge('botcha_recipebook')
        ->key(array(
        'id' => $recipebook->id,
      ))
        ->fields(array(
        'title' => $recipebook->title,
        'description' => $recipebook->description,
      ))
        ->execute();

      // Save relationships between recipe book and recipes to DB.
      $recipes = $recipebook
        ->getRecipes();
      $insert = db_insert('botcha_recipebook_recipe');
      foreach ($recipes as $recipe) {
        $query = $insert
          ->fields(array(
          'rbid',
          'recipe_id',
        ))
          ->values(array(
          'rbid' => $recipebook->id,
          'recipe_id' => $recipe->id,
        ))
          ->execute();
      }

      // Save relationships between recipe book and forms to DB.
      $forms = $recipebook
        ->getForms();
      foreach ($forms as $form) {
        $brf = db_select('botcha_recipebook_form', 'brf')
          ->fields('brf', array(
          'rbid',
        ))
          ->condition('form_id', $form->id)
          ->execute()
          ->fetchCol();
        if (count($brf)) {
          $query = db_update('botcha_recipebook_form')
            ->condition('form_id', $form->id)
            ->fields(array(
            'rbid' => $recipebook->id,
          ));
        }
        else {
          $query = db_insert('botcha_recipebook_form')
            ->fields(array(
            'form_id' => $form->id,
            'rbid' => $recipebook->id,
          ));
        }
        $query
          ->execute();

        // Strange but true: db_merge does not work here, fails with integrity constraint violation.

        /*
                  $query->key(array('form_id', 'rbid'), array($form->id, $recipebook->id))
         ->execute();
        *
        */
      }
    }
  } catch (Exception $e) {
    if ($e instanceof PDOException) {
      watchdog_exception('BOTCHA', $e, 'Please perform an update via update.php or reinstall the BOTCHA module to fix the reason of this warning! %type: !message in %function (line %line of %file).', array(), WATCHDOG_WARNING);
    }
  }
}