1: #!/usr/bin/php
 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: