function views_db_object::save_row

Write the row to the database.

Parameters

$update: If true this will be an UPDATE query. Otherwise it will be an INSERT.

File

includes/view.inc, line 2021

view.inc Provides the view object type and associated methods.

Class

views_db_object

Base class for views' database objects.

Code

function save_row($update = NULL) {
  $schema = drupal_get_schema($this->db_table);
  $fields = $defs = $values = $serials = array();

  // Go through our schema and build correlations.
  foreach ($schema['fields'] as $field => $info) {

    // special case -- skip serial types if we are updating.
    if ($info['type'] == 'serial') {
      $serials[] = $field;
      continue;
    }
    $fields[] = $field;
    switch ($info['type']) {
      case 'blob':
        $defs[] = '%b';
        break;
      case 'int':
        $defs[] = '%d';
        break;
      case 'float':
      case 'numeric':
        $defs[] = '%f';
        break;
      default:
        $defs[] = "'%s'";
    }
    if (empty($info['serialize'])) {
      $values[] = $this->{$field};
    }
    else {
      $values[] = serialize($this->{$field});
    }
  }
  $query = '';
  if (!$update) {
    $query = "INSERT INTO {" . $this->db_table . "} (" . implode(', ', $fields) . ') VALUES (' . implode(', ', $defs) . ')';
  }
  else {
    $query = '';
    foreach ($fields as $id => $field) {
      if ($query) {
        $query .= ', ';
      }
      $query .= $field . ' = ' . $defs[$id];
    }
    $query = "UPDATE {" . $this->db_table . "} SET " . $query . " WHERE {$update} = " . $this->{$update};
  }
  db_query($query, $values);
  if ($serials && !$update) {

    // get last insert ids and fill them in.
    foreach ($serials as $field) {
      $this->{$field} = db_last_insert_id($this->db_table, $field);
    }
  }
}