Changeset 573 for trunk/bin

Timestamp:

Feb 27, 2017 2:13:19 PM (7 years ago)

Author:

anonymous

Message:

Refactoring of init_codebase_tables.cli.php to support external _config.inc.php

File:

• trunk/bin/init_codebase_tables.cli.php (modified) (12 diffs)

trunk/bin/init_codebase_tables.cli.php

@@ -24 +24 @@
 *
 * @author   Quinn Comendant <quinn@strangecode.com>
-* @version  1.0
-* @since    12 Jul 2015 22:44:58
+* @version  2.0
+* @since    05 Mar 2016 19:12:09
 */
-
-/********************************************************************
-* CONFIG
-********************************************************************/
-
-require_once dirname(__FILE__) . '/_config.inc.php';
-require_once CODEBASE_PATH . '/lib/ACL.inc.php';
-require_once CODEBASE_PATH . '/lib/Auth_SQL.inc.php';
-require_once CODEBASE_PATH . '/lib/Lock.inc.php';
-require_once CODEBASE_PATH . '/lib/Prefs.inc.php';
-require_once CODEBASE_PATH . '/lib/Version.inc.php';
 
 /********************************************************************
@@ -44 +33 @@
 
 // Process command line options.
-$opt = getopt('fh');
+$opt = getopt('fhc:');
 
-// Get class name.
+// Get name of class to initialize (or 'all' for all).
 $class = strtolower(end($_SERVER['argv']));
 
@@ -55 +44 @@
 }
 
-$app->logMsg(sprintf('Running initDB on %s codebase tables in db %s', $class, $db->getParam('db_name')), LOG_INFO, __FILE__, __LINE__);
+if (isset($opt['c']) && is_file($opt['c'])) {
+    require_once $opt['c'];
+    $app->logMsg(sprintf('Loaded custom config file: %s', $opt['c']), LOG_INFO, __FILE__, __LINE__);
+}
+require_once dirname(__FILE__) . '/_config.inc.php';
 
 if ('all' == $class) {
@@ -63 +56 @@
     initClassDB('prefs');
     initClassDB('version');
+    initClassDB('session');
 } else {
     initClassDB($class);
 }
 
+$app->stop();
+die;
 
 /********************************************************************
@@ -92 +88 @@
 OPTIONS
 
-    -f  Force recreation of tables, if they already exist.
-    -h  Show this help message.
+    -c FILE Path to include custom site _config.inc.php file.
+    -f      Force recreation of tables, if they already exist. WARNING: this will delete existing records.
+    -h      Show this help message.
 
 CLASSNAME is one of:
@@ -103 +100 @@
     prefs       Create tables for Prefs
     version     Create tables for Version
+    session     Create tables for DBSessionHandler
 <?php
 }
@@ -119 +117 @@
 {
     global $opt;
+    $app =& App::getInstance();
+    $db =& DB::getInstance();
+
+    $app->logMsg(sprintf('Running %s->initDB() on database %s', $class, $db->getParam('db_name')), LOG_INFO, __FILE__, __LINE__);
 
     switch ($class) {
         case 'acl':
             // ACL!
+            require_once CODEBASE_PATH . '/lib/ACL.inc.php';
             $acl =& ACL::getInstance();
             $acl->setParam(array('create_table' => true));
@@ -130 +133 @@
         case 'auth':
             // Auth_SQL!
+            require_once CODEBASE_PATH . '/lib/Auth_SQL.inc.php';
             $auth = new Auth_SQL('codebase');
-            $auth->setParam(array(
-                'create_table' => true,
-                'abuse_detection' => true,
-            ));
+            $auth->setParam(array('create_table' => true));
+            if (!isset($opt['c'])) {
+                // User didn't provide custom config. Use sane defaults.
+                $auth->setParam(array('abuse_detection' => true));
+            }
             $auth->initDB(isset($opt['f']));
             break;
@@ -140 +145 @@
         case 'lock':
             // Lock!
+            require_once CODEBASE_PATH . '/lib/Lock.inc.php';
             $lock =& Lock::getInstance(new Auth_SQL('codebase'));
             $lock->setParam(array('create_table' => true));
@@ -147 +153 @@
         case 'prefs':
             // Prefs!
+            require_once CODEBASE_PATH . '/lib/Prefs.inc.php';
             $prefs = new Prefs('codebase');
             $prefs->setParam(array('create_table' => true));
@@ -154 +161 @@
         case 'version':
             // Version!
+            require_once CODEBASE_PATH . '/lib/Version.inc.php';
             $version = Version::getInstance(new Auth_SQL('codebase'));
             $version->setParam(array('create_table' => true));
@@ -159 +167 @@
             break;
 
+        case 'session':
+            // DBSessionHandler!
+
+            // We need to hack the app to allow sessions to run in a CLI.
+            $app->stop();
+            $app->cli = false;
+            $app->setParam(array('enable_session' => true));
+            $app->start();
+
+            if (!isset($opt['c'])) {
+                // User didn't provide custom config. Use sane defaults.
+                require_once CODEBASE_PATH . '/lib/DBSessionHandler.inc.php';
+                $db_session = new DBSessionHandler($app->db, array(
+                    'db_table' => 'session_tbl',
+                    'create_table' => true,
+                ));
+                $db_session->initDB(isset($opt['f']));
+            } else if (true === $app->getParam('enable_db_session_handler') && true === $app->getParam('enable_db') && isset($app->db_session)) {
+                // Only init if db_session is enabled in config.
+                $app->db_session->initDB(isset($opt['f']));
+            }
+            break;
+
         default:
-            echo "The class $class is not setup to initClassDB.\n";
+            echo "The class $class is not setup to initClassDB().\n";
             exit(1);
     }