Project

General

Profile

Paste
Download (2.89 KB) Statistics
| Branch: | Revision:

root / drupal7 / scripts / dump-database-d6.sh @ 6d8023f2

1
#!/usr/bin/env php
2
<?php
3

    
4
/**
5
 * Dump a Drupal 6 database into a Drupal 7 PHP script to test the upgrade
6
 * process.
7
 *
8
 * Run this script at the root of an existing Drupal 6 installation.
9
 *
10
 * The output of this script is a PHP script that can be ran inside Drupal 7
11
 * and recreates the Drupal 6 database as dumped. Transient data from cache
12
 * session and watchdog tables are not recorded.
13
 */
14

    
15
// Define default settings.
16
$cmd = 'index.php';
17
$_SERVER['HTTP_HOST']       = 'default';
18
$_SERVER['PHP_SELF']        = '/index.php';
19
$_SERVER['REMOTE_ADDR']     = '127.0.0.1';
20
$_SERVER['SERVER_SOFTWARE'] = NULL;
21
$_SERVER['REQUEST_METHOD']  = 'GET';
22
$_SERVER['QUERY_STRING']    = '';
23
$_SERVER['PHP_SELF']        = $_SERVER['REQUEST_URI'] = '/';
24
$_SERVER['HTTP_USER_AGENT'] = 'console';
25

    
26
// Bootstrap Drupal.
27
include_once './includes/bootstrap.inc';
28
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
29

    
30
// Include the utility drupal_var_export() function.
31
include_once dirname(__FILE__) . '/../includes/utility.inc';
32

    
33
// Output the PHP header.
34
$output = <<<ENDOFHEADER
35
<?php
36

    
37
/**
38
 * @file
39
 * Filled installation of Drupal 6.17, for test purposes.
40
 *
41
 * This file was generated by the dump-database-d6.sh tool, from an
42
 * installation of Drupal 6, filled with data using the generate-d6-content.sh
43
 * tool. It has the following modules installed:
44

    
45
ENDOFHEADER;
46

    
47
foreach (module_list() as $module) {
48
  $output .= " *  - $module\n";
49
}
50
$output .= " */\n\n";
51

    
52
// Get the current schema, order it by table name.
53
$schema = drupal_get_schema();
54
ksort($schema);
55

    
56
// Export all the tables in the schema.
57
foreach ($schema as $table => $data) {
58
  // Remove descriptions to save time and code.
59
  unset($data['description']);
60
  foreach ($data['fields'] as &$field) {
61
    unset($field['description']);
62
  }
63

    
64
  // Dump the table structure.
65
  $output .= "db_create_table('" . $table . "', " . drupal_var_export($data) . ");\n";
66

    
67
  // Don't output values for those tables.
68
  if (substr($table, 0, 5) == 'cache' || $table == 'sessions' || $table == 'watchdog') {
69
    $output .= "\n";
70
    continue;
71
  }
72

    
73
  // Prepare the export of values.
74
  $result = db_query('SELECT * FROM {'. $table .'}');
75
  $insert = '';
76
  while ($record = db_fetch_array($result)) {
77
    // users.uid is a serial and inserting 0 into a serial can break MySQL.
78
    // So record uid + 1 instead of uid for every uid and once all records
79
    // are in place, fix them up.
80
    if ($table == 'users') {
81
      $record['uid']++;
82
    }
83
    $insert .= '->values('. drupal_var_export($record) .")\n";
84
  }
85

    
86
  // Dump the values if there are some.
87
  if ($insert) {
88
    $output .= "db_insert('". $table . "')->fields(". drupal_var_export(array_keys($data['fields'])) .")\n";
89
    $output .= $insert;
90
    $output .= "->execute();\n";
91
  }
92

    
93
  // Add the statement fixing the serial in the user table.
94
  if ($table == 'users') {
95
    $output .= "db_query('UPDATE {users} SET uid = uid - 1');\n";
96
  }
97

    
98
  $output .= "\n";
99
}
100

    
101
print $output;