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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
<?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: insert_db.php 293138 2010-01-05 10:21:11Z rquadling $
*/
require_once './ini_search_lib.php';
require_once './cvs-versions.php';
function insert_in_db($tag) {
global $array, $idx;
$sql = '';
foreach ($array as $key => $data) {
if (sqlite_single_query($idx, "SELECT name FROM changelog WHERE name='$key'")) {
$sql .= "UPDATE changelog SET $tag='{$data[1]}' WHERE name='$key';";
} else {
$sql .= "INSERT INTO changelog (name, $tag) VALUES ('$key', '{$data[1]}');";
}
$sql .= "REPLACE INTO last_seen_values (name, defaultval, permissions) VALUES ('$key', '".sqlite_escape_string(expand_macros($data[0]))."', '$data[1]');";
}
if ($sql) sqlite_query($idx, $sql);
}
$db_open = isset($idx) ? true : false;
if (!$db_open && !$idx = sqlite_open('ini_changelog.sqlite', 0666, $error)) {
die("Couldn't create the DB: $error");
}
// process PHP sources
foreach ($tags as $tag) {
$array = $replace = array();
recurse("./sources/$tag", true);
insert_in_db($tag);
echo "$tag\n";
}
// process PECL sources
foreach (get_pecl_releases_local() as $release) {
preg_match('/^(.+)-(\d+(?:\.\d+)+)$/S', $release, $m);
$pkg = $m[1];
$version = $m[2];
// if it has an entry already, just skip it
if (sqlite_single_query($idx, "SELECT COUNT(*) FROM pecl_changelog WHERE package='".sqlite_escape_string($pkg)."' AND version='$version'") > 0) {
continue;
}
$array = $replace = array();
recurse("./sources/$release", true);
$sql = '';
foreach ($array as $key => $data) {
$sql .= "INSERT INTO pecl_changelog (package, version, name, value) VALUES ('".sqlite_escape_string($pkg)."', '$version', '$key', '$data[1]');";
// prefer information from PHP sources
if (!sqlite_single_query($idx, "SELECT name FROM changelog WHERE name='$key'")) {
$sql .= "REPLACE INTO last_seen_values (name, defaultval, permissions) VALUES ('$key', '".sqlite_escape_string(expand_macros($data[0]))."', '$data[1]');";
}
}
if ($sql) sqlite_query($idx, $sql);
echo "$release\n";
}
if (!$db_open) {
sqlite_close($idx);
unset($idx);
}
?>
|
