Mercurial > hg > rc2

comparison bin/updatedb.sh @ 0:4681f974d28b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
vanilla 1.3.3 distro, I hope
author Charlie Root
date Thu, 04 Jan 2018 15:52:31 -0500
parents
children bf99236cc5cd
comparison
equal deleted inserted replaced
-1:000000000000 0:4681f974d28b
1 #!/usr/bin/env php
2 <?php
3 /*
4 +-----------------------------------------------------------------------+
5 | bin/updatedb.sh |
6 | |
7 | This file is part of the Roundcube Webmail client |
8 | Copyright (C) 2010-2012, The Roundcube Dev Team |
9 | Copyright (C) 2010-2012, Kolab Systems AG |
10 | |
11 | Licensed under the GNU General Public License version 3 or |
12 | any later version with exceptions for skins & plugins. |
13 | See the README file for a full license statement. |
14 | |
15 | PURPOSE: |
16 | Update database schema |
17 +-----------------------------------------------------------------------+
18 | Author: Aleksander Machniak <alec@alec.pl> |
19 +-----------------------------------------------------------------------+
20 */
21
22 define('INSTALL_PATH', realpath(__DIR__ . '/..') . '/' );
23
24 require_once INSTALL_PATH . 'program/include/clisetup.php';
25
26 // get arguments
27 $opts = rcube_utils::get_opt(array(
28 'v' => 'version',
29 'd' => 'dir',
30 'p' => 'package',
31 ));
32
33 if (empty($opts['dir'])) {
34 rcube::raise_error("Database schema directory not specified (--dir).", false, true);
35 }
36 if (empty($opts['package'])) {
37 rcube::raise_error("Database schema package name not specified (--package).", false, true);
38 }
39
40 // Check if directory exists
41 if (!file_exists($opts['dir'])) {
42 rcube::raise_error("Specified database schema directory doesn't exist.", false, true);
43 }
44
45 $RC = rcube::get_instance();
46 $DB = rcube_db::factory($RC->config->get('db_dsnw'));
47
48 $DB->set_debug((bool)$RC->config->get('sql_debug'));
49
50 // Connect to database
51 $DB->db_connect('w');
52 if (!$DB->is_connected()) {
53 rcube::raise_error("Error connecting to database: " . $DB->is_error(), false, true);
54 }
55
56 // Read DB schema version from database (if 'system' table exists)
57 if (in_array($DB->table_name('system'), (array)$DB->list_tables())) {
58 $DB->query("SELECT `value`"
59 ." FROM " . $DB->table_name('system', true)
60 ." WHERE `name` = ?",
61 $opts['package'] . '-version');
62
63 $row = $DB->fetch_array();
64 $version = preg_replace('/[^0-9]/', '', $row[0]);
65 }
66
67 // DB version not found, but release version is specified
68 if (!$version && $opts['version']) {
69 // Map old release version string to DB schema version
70 // Note: This is for backward compat. only, do not need to be updated
71 $map = array(
72 '0.1-stable' => 1,
73 '0.1.1' => 2008030300,
74 '0.2-alpha' => 2008040500,
75 '0.2-beta' => 2008060900,
76 '0.2-stable' => 2008092100,
77 '0.2.1' => 2008092100,
78 '0.2.2' => 2008092100,
79 '0.3-stable' => 2008092100,
80 '0.3.1' => 2009090400,
81 '0.4-beta' => 2009103100,
82 '0.4' => 2010042300,
83 '0.4.1' => 2010042300,
84 '0.4.2' => 2010042300,
85 '0.5-beta' => 2010100600,
86 '0.5' => 2010100600,
87 '0.5.1' => 2010100600,
88 '0.5.2' => 2010100600,
89 '0.5.3' => 2010100600,
90 '0.5.4' => 2010100600,
91 '0.6-beta' => 2011011200,
92 '0.6' => 2011011200,
93 '0.7-beta' => 2011092800,
94 '0.7' => 2011111600,
95 '0.7.1' => 2011111600,
96 '0.7.2' => 2011111600,
97 '0.7.3' => 2011111600,
98 '0.7.4' => 2011111600,
99 '0.8-beta' => 2011121400,
100 '0.8-rc' => 2011121400,
101 '0.8.0' => 2011121400,
102 '0.8.1' => 2011121400,
103 '0.8.2' => 2011121400,
104 '0.8.3' => 2011121400,
105 '0.8.4' => 2011121400,
106 '0.8.5' => 2011121400,
107 '0.8.6' => 2011121400,
108 '0.9-beta' => 2012080700,
109 );
110
111 $version = $map[$opts['version']];
112 }
113
114 // Assume last version before the 'system' table was added
115 if (empty($version)) {
116 $version = 2012080700;
117 }
118
119 $dir = $opts['dir'] . '/' . $DB->db_provider;
120 if (!file_exists($dir)) {
121 rcube::raise_error("DDL Upgrade files for " . $DB->db_provider . " driver not found.", false, true);
122 }
123
124 $dh = opendir($dir);
125 $result = array();
126
127 while ($file = readdir($dh)) {
128 if (preg_match('/^([0-9]+)\.sql$/', $file, $m) && $m[1] > $version) {
129 $result[] = $m[1];
130 }
131 }
132 sort($result, SORT_NUMERIC);
133
134 foreach ($result as $v) {
135 echo "Updating database schema ($v)... ";
136 $error = update_db_schema($opts['package'], $v, "$dir/$v.sql");
137
138 if ($error) {
139 echo "[FAILED]\n";
140 rcube::raise_error("Error in DDL upgrade $v: $error", false, true);
141 }
142 echo "[OK]\n";
143 }
144
145
146 function update_db_schema($package, $version, $file)
147 {
148 global $DB;
149
150 // read DDL file
151 if ($sql = file_get_contents($file)) {
152 if (!$DB->exec_script($sql)) {
153 return $DB->is_error();
154 }
155 }
156
157 // escape if 'system' table does not exist
158 if ($version < 2013011000) {
159 return;
160 }
161
162 $system_table = $DB->table_name('system', true);
163
164 $DB->query("UPDATE " . $system_table
165 ." SET `value` = ?"
166 ." WHERE `name` = ?",
167 $version, $package . '-version');
168
169 if (!$DB->is_error() && !$DB->affected_rows()) {
170 $DB->query("INSERT INTO " . $system_table
171 ." (`name`, `value`) VALUES (?, ?)",
172 $package . '-version', $version);
173 }
174
175 return $DB->is_error();
176 }
177
178 ?>