function search_autocomplete_update_7407 in Search Autocomplete 7.4

Update existing data (update from 4.0-alpha2 to 4.x).

File

./search_autocomplete.install, line 317

This file is used to install/update/delete the module tables in database

Code

function search_autocomplete_update_7407(&$sandbox) {
  $fid = db_select('search_autocomplete_forms', 'sa')
    ->fields('sa', array(
    'fid',
  ))
    ->condition('sa.selector', '#search-form[action="/search/node"] #edit-keys', '=')
    ->execute()
    ->fetchAssoc();
  db_update('search_autocomplete_forms')
    ->fields(array(
    'data_source' => 'view',
    'data_callback' => 'search_autocomplete/autocomplete/' . $fid['fid'] . '/',
    'data_view' => 'words_autocomplete',
    'theme' => 'basic-green.css',
  ))
    ->condition('selector', '#search-form[action="/search/node"] #edit-keys', '=')
    ->execute();
  $fid = db_select('search_autocomplete_forms', 'sa')
    ->fields('sa', array(
    'fid',
  ))
    ->condition('sa.selector', '#search-form[action="/search/user"] #edit-keys', '=')
    ->execute()
    ->fetchAssoc();
  db_update('search_autocomplete_forms')
    ->fields(array(
    'data_source' => 'view',
    'data_view' => 'users_autocomplete',
    'data_callback' => 'search_autocomplete/autocomplete/' . $fid['fid'] . '/',
    'theme' => 'user-blue.css',
  ))
    ->condition('selector', '#search-form[action="/search/user"] #edit-keys', '=')
    ->execute();
  $fid = db_select('search_autocomplete_forms', 'sa')
    ->fields('sa', array(
    'fid',
  ))
    ->condition('sa.selector', '#edit-search-block-form--2', '=')
    ->execute()
    ->fetchAssoc();
  db_update('search_autocomplete_forms')
    ->fields(array(
    'data_source' => 'view',
    'data_view' => 'nodes_autocomplete',
    'data_callback' => 'search_autocomplete/autocomplete/' . $fid['fid'] . '/',
    'theme' => 'basic-green.css',
  ))
    ->condition('selector', '#edit-search-block-form--2', '=')
    ->execute();
}