sqlfile.inc.php
3.87 KB
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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<?php
/**
* $Id$
*
* The contents of this file are subject to the KnowledgeTree Public
* License Version 1.1 ("License"); You may not use this file except in
* compliance with the License. You may obtain a copy of the License at
* http://www.knowledgetree.com/KPL
*
* Software distributed under the License is distributed on an "AS IS"
* basis,
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
* for the specific language governing rights and limitations under the
* License.
*
* The Original Code is: KnowledgeTree Open Source
*
* The Initial Developer of the Original Code is The Jam Warehouse Software
* (Pty) Ltd, trading as KnowledgeTree.
* Portions created by The Jam Warehouse Software (Pty) Ltd are Copyright
* (C) 2007 The Jam Warehouse Software (Pty) Ltd;
* All Rights Reserved.
*
*/
class SQLFile {
function sqlFromFile($path) {
return SQLFile::splitSQL(file_get_contents($path));
}
function splitSQL($sql) {
$instring = false;
$i = 0;
$remaining = $sql;
$query = "";
$aQueries = array();
$strlen = strlen($sql);
for ($i = 0; $i < $strlen; $i++) {
$c = $remaining[$i];
if ($c === ";") {
$query .= substr($remaining, 0, $i + 1);
$aQueries[] = $query;
$query = "";
$remaining = trim(substr($remaining, $i + 1));
$i = 0;
$strlen = strlen($remaining);
continue;
}
if ($c === "`") {
$next = strpos($remaining, "`", $i);
if ($next === false) {
$query .= $remaining;
$aQueries[] = $query;
return $aQueries;
}
$query .= substr($remaining, 0, $next);
$remaining = substr($remaining, $next);
$i = 0;
$strlen = strlen($remaining);
continue;
}
if (($c === "'") || ($c === '"')) {
$stringchar = $c;
$notfound = true;
while ($notfound) {
$next = strpos($remaining, $stringchar, $i + 1);
if ($next === false) {
$query .= $remaining;
$aQueries[] = $query;
return $aQueries;
}
$i = $next + 1;
$quotes = true;
$b = 1;
while ($remaining[$next - $b] === "\\") {
$quotes = !$quotes;
$b++;
}
if ($quotes) {
$notfound = false;
}
}
$query .= substr($remaining, 0, $next);
$remaining = substr($remaining, $next);
$i = 0;
$strlen = strlen($remaining);
continue;
}
$nextdelim = SQLFile::_nextDelim($remaining);
if ($nextdelim === false) {
$query .= $remaining;
$aQueries[] = $query;
return $aQueries;
}
// $query .= substr($remaining, 0, $nextdelim);
}
return $aQueries;
}
function _nextDelim($string) {
$q = strpos($string, "'");
$d = strpos($string, '"');
$b = strpos($string, "`");
$s = strpos($string, ";");
$min = false;
foreach (array($q, $d, $b, $s) as $c) {
if ($min === false) {
$min = $c;
continue;
}
if ($c === false) {
continue;
}
if ($c < $min) {
$min = $c;
continue;
}
}
return $min;
}
}
?>