1:
2: <?php
3: require_once '${config_dir}/config.php';
4: require_once '${config_dir}/cvterms.php';
5:
6: require_once __DIR__.'/db.php';
7:
8: if (in_array('--tables', $argv))
9: execute_query_dir('tables');
10: if (in_array('--functions', $argv))
11: execute_query_dir('functions');
12: if (in_array('--mat_views', $argv))
13: execute_query_dir('materialized_views');
14:
15: function execute_query_dir($subdirname) {
16: global $db;
17: $dirname = __DIR__ . DIRECTORY_SEPARATOR . $subdirname . DIRECTORY_SEPARATOR;
18: foreach (new DirectoryIterator($dirname) as $file) {
19: if (!is_file($dirname . $file))
20: continue;
21: $unprepared = file_get_contents($dirname . $file);
22: $prepared = preg_replace_callback("/\{PHPCONST\('(.*)'\)\}/", function($c) {
23: return constant($c[1]);
24: }, $unprepared);
25:
26: $queries = explode('--NEWCMD--', $prepared);
27:
28: foreach ($queries as $query) {
29: echo $query . "\n\n";
30: $db->query($query);
31: }
32: }
33: }
34: ?>
35: