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
|
#! /usr/bin/php
<?php
/**
* Copyright 2011 Roland Mas
*
* This file is part of FusionForge. FusionForge is free software;
* you can redistribute it and/or modify it under the terms of the
* GNU General Public License as published by the Free Software
* Foundation; either version 2 of the Licence, or (at your option)
* any later version.
*
* FusionForge is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License along
* with FusionForge; if not, write to the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*/
require_once (dirname(__FILE__).'/../common/include/sqlparser.php');
$file = $argv[1];
$queries = array();
foreach (parse_sql_file($file) as $q) {
$q = trim($q);
$q = preg_replace('/\s+/', ' ', $q);
if (preg_match("/^INSERT INTO /", $q)) continue ;
if (preg_match('/^COMMENT/', $q)) continue;
if (preg_match('/^SET/', $q)) continue;
if (preg_match('/^\\\connect/', $q)) continue;
if (preg_match('/^SELECT pg_catalog.setval/', $q)) continue;
$ignored_insert_tables = array('artifact_extra_field_elements',
'artifact_extra_field_list',
'database_changes',
'doc_groups',
'database_startpoint',
'group_plugin',
'groups',
'mail_group_list',
'nss_groups',
'plugins',
'pfo_role',
'pfo_user_role',
'pfo_role_setting',
'project_task',
'role',
'role_project_refs',
'role_setting',
'user_group',
'users',
'user_session',
'themes',
'[a-z]*_idx',
);
foreach ($ignored_insert_tables as $i) {
if (preg_match("/INSERT INTO \"$i\" /", $q)) continue 2;
}
$queries[] = $q;
}
sort($queries);
foreach ($queries as $q) {
print "$q\n";
}
?>
|
