Posted By

berkes on 10/09/09

Tagged

Versions (?)

Last Edited at 10/09/09 09:08am

Statistics

Viewed 845 times

Favorited by 0 user(s)

Related snippets

Track block/views/cck etc changes in RCS and migrate with Drupal updates.

/ Published in: PHP

Takes a .sql file and runs trough that, each line as an update_sql.
Very usefull to track and migrate your blocks/views/cck etc changes.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

/**
 * Make these queries with mysqldump -uusernam -p database_name -t blocks -c --compact --skip-extended-insert | sort | uniq  > sitese/all/modules/projectname_meta/blocks.sql 
 **/
function projectname_meta_update_5002() {
  $ret = array();
 
  $files = array(
    'blocks' => 'blocks.sql',
  );
 
  foreach($files as $table => $name) {
    $lines = file(drupal_get_path('module', 'ogt_meta') .'/'. $name);
    if (count($lines) > 0) {
      $table = db_escape_string($table);
      $ret[] = update_sql('TRUNCATE {'. $table .'}');
 
      foreach ($lines as $line_num => $line) {
        $ret[] = update_sql($line);
      }
    }
  }
 
  return $ret;
}