1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
<?php
/*
+----------------------------------------------------------------------+
| ini doc settings updater |
+----------------------------------------------------------------------+
| Copyright (c) 1997-2010 The PHP Group |
+----------------------------------------------------------------------+
| This source file is subject to version 3.0 of the PHP license, |
| that is bundled with this package in the file LICENSE, and is |
| available through the world-wide-web at the following url: |
| http://www.php.net/license/3_0.txt. |
| If you did not receive a copy of the PHP license and are unable to |
| obtain it through the world-wide-web, please send a note to |
| license@php.net so we can mail you a copy immediately. |
+----------------------------------------------------------------------+
| Authors: Nuno Lopes <nlopess@php.net> |
+----------------------------------------------------------------------+
$Id: update_db.php 293138 2010-01-05 10:21:11Z rquadling $
*/
require_once './cvs-versions.php';
copy('ini_changelog.sqlite', 'backup.sqlite');
if (!$idx = sqlite_open('ini_changelog.sqlite', 0666, $error)) {
die("Couldn't open the DB: $error");
}
$olddata = sqlite_fetch_all(sqlite_query($idx, 'SELECT * FROM changelog'), SQLITE_ASSOC);
$columns = $olddata[0];
$columns_str = implode(',', array_keys($columns));
sqlite_query($idx, 'DROP TABLE changelog; VACUUM;');
// make a new table. this also fills the $tags array
include './make_db.php';
$sql = '';
foreach ($olddata as $row) {
$sql .= "INSERT INTO changelog ($columns_str) VALUES (\"" . implode('", "', $row) . '");';
}
sqlite_query($idx, $sql);
// check which versions need to be updated
$tmp = $tags;
$tags = array_keys($cvs_versions); //always update cvs versions
foreach($tmp as $tag) {
if (!isset($columns[$tag])) {
$tags[] = $tag;
}
}
unset($tmp, $columns, $sql, $olddata);
// finally recurse through the new PHP versions
include './insert_db.php';
sqlite_close($idx);
?>
|
