function yamlform_update_8055 in YAML Form 8

Issue #2806263: Add property column to submission data table. Populate serial column.

File

includes/yamlform.update.inc, line 1157

YAML Form module update hooks.

Code

function yamlform_update_8055() {
  db_query("UPDATE {yamlform_submission} SET serial=sid");
  $yamlforms = YamlForm::loadMultiple();
  $result = db_query("SELECT yamlform_id, MAX(serial) AS next_serial FROM {yamlform_submission} GROUP BY yamlform_id");
  while ($record = $result
    ->fetchAssoc()) {

    /** @var \Drupal\yamlform\YamlFormInterface $yamlform */
    $yamlform = $yamlforms[$record['yamlform_id']];
    $yamlform
      ->setState('next_serial', $record['next_serial'] + 1);
  }
}