echo \b2db\Core::getDBtype(); ?> </li> <li><b>DSN:</b> <?php echo \b2db\Core::getDSN(); ?> <ul> <li><b>Hostname:</b> <?php echo \b2db\Core::getHost(); ?> :<?php echo \b2db\Core::getPort(); ?> </li> <li><b>Database:</b> <?php echo \b2db\Core::getDBname(); ?> </li> </ul> </li> <li><b>Username:</b> <?php echo \b2db\Core::getUname(); ?> </li> <li><b>Prefix:</b> <?php echo \b2db\Core::getTablePrefix(); ?> </li> <li><b>Connection status:</b> <?php echo \b2db\Core::isConnected() ? 'Connected' : 'Not connected'; ?>
/** * Runs the action for the third step of the installation * where it tests the connection, sets up the database and the initial scope * * @param framework\Request $request The request object * * @return null */ public function runInstallStep3(framework\Request $request) { $this->selected_connection_detail = $request['connection_type']; try { if ($this->username = $request['db_username']) { \b2db\Core::setUname($this->username); \b2db\Core::setTablePrefix($request['db_prefix']); if ($this->password = $request->getRawParameter('db_password')) { \b2db\Core::setPasswd($this->password); } if ($this->selected_connection_detail == 'dsn') { if (($this->dsn = $request['db_dsn']) != '') { \b2db\Core::setDSN($this->dsn); } else { throw new \Exception('You must provide a valid DSN'); } } else { if ($this->db_type = $request['db_type']) { \b2db\Core::setDBtype($this->db_type); if ($this->db_hostname = $request['db_hostname']) { \b2db\Core::setHost($this->db_hostname); } else { throw new \Exception('You must provide a database hostname'); } if ($this->db_port = $request['db_port']) { \b2db\Core::setPort($this->db_port); } if ($this->db_databasename = $request['db_name']) { \b2db\Core::setDBname($this->db_databasename); } else { throw new \Exception('You must provide a database to use'); } } else { throw new \Exception('You must provide a database type'); } } try { \b2db\Core::doConnect(); } catch (\b2db\Exception $e) { throw new \Exception('There was an error connecting to the database: ' . $e->getMessage()); } if (\b2db\Core::getDBname() == '') { throw new \Exception('You must provide a database to use'); } \b2db\Core::saveConnectionParameters(\THEBUGGENIE_CONFIGURATION_PATH . "b2db.yml"); } else { throw new \Exception('You must provide a database username'); } // Create v4 tables $b2db_entities_path = THEBUGGENIE_CORE_PATH . 'entities' . DS . 'tables' . DS; $tables_created = array(); foreach (scandir($b2db_entities_path) as $tablefile) { if (in_array($tablefile, array('.', '..'))) { continue; } if (($tablename = mb_substr($tablefile, 0, mb_strpos($tablefile, '.'))) != '') { $tablename = "\\thebuggenie\\core\\entities\\tables\\{$tablename}"; $reflection = new \ReflectionClass($tablename); $docblock = $reflection->getDocComment(); $annotationset = new \b2db\AnnotationSet($docblock); if ($annotationset->hasAnnotation('Table')) { \b2db\Core::getTable($tablename)->create(); \b2db\Core::getTable($tablename)->createIndexes(); $tables_created[] = $tablename; } } } sort($tables_created); $this->tables_created = $tables_created; } catch (\Exception $e) { $this->error = $e->getMessage(); } $server_type = strtolower(trim($_SERVER['SERVER_SOFTWARE'])); switch (true) { case stripos($server_type, 'apache') !== false: $this->server_type = 'apache'; break; case stripos($server_type, 'nginx') !== false: $this->server_type = 'nginx'; break; case stripos($server_type, 'iis') !== false: $this->server_type = 'iis'; break; default: $this->server_type = 'unknown'; } $dirname = dirname($_SERVER['PHP_SELF']); if (mb_stristr(PHP_OS, 'WIN')) { $dirname = str_replace("\\", "/", $dirname); /* Windows adds a \ to the URL which we don't want */ } $this->dirname = $dirname != '/' ? $dirname . '/' : $dirname; }
/** * Runs the action for the third step of the installation * where it tests the connection, sets up the database and the initial scope * * @param TBGRequest $request The request object * * @return null */ public function runInstallStep3(TBGRequest $request) { $this->selected_connection_detail = $request['connection_type']; try { if ($this->username = $request['db_username']) { \b2db\Core::setUname($this->username); \b2db\Core::setTablePrefix($request['db_prefix']); if ($this->password = $request->getRawParameter('db_password')) { \b2db\Core::setPasswd($this->password); } if ($this->selected_connection_detail == 'dsn') { if (($this->dsn = $request['db_dsn']) != '') { \b2db\Core::setDSN($this->dsn); } else { throw new Exception('You must provide a valid DSN'); } } else { if ($this->db_type = $request['db_type']) { \b2db\Core::setDBtype($this->db_type); if ($this->db_hostname = $request['db_hostname']) { \b2db\Core::setHost($this->db_hostname); } else { throw new Exception('You must provide a database hostname'); } if ($this->db_port = $request['db_port']) { \b2db\Core::setPort($this->db_port); } if ($this->db_databasename = $request['db_name']) { \b2db\Core::setDBname($this->db_databasename); } else { throw new Exception('You must provide a database to use'); } } else { throw new Exception('You must provide a database type'); } } \b2db\Core::initialize(THEBUGGENIE_CORE_PATH . 'b2db_bootstrap.inc.php'); \b2db\Core::doConnect(); if (\b2db\Core::getDBname() == '') { throw new Exception('You must provide a database to use'); } \b2db\Core::saveConnectionParameters(THEBUGGENIE_CORE_PATH . 'b2db_bootstrap.inc.php'); } else { throw new Exception('You must provide a database username'); } // Add table classes to classpath $tables_path = THEBUGGENIE_CORE_PATH . 'classes' . DS . 'B2DB' . DS; TBGContext::addAutoloaderClassPath($tables_path); $tables_path_handle = opendir($tables_path); $tables_created = array(); while ($table_class_file = readdir($tables_path_handle)) { if (($tablename = mb_substr($table_class_file, 0, mb_strpos($table_class_file, '.'))) != '') { \b2db\Core::getTable($tablename)->create(); \b2db\Core::getTable($tablename)->createIndexes(); $tables_created[] = $tablename; } } sort($tables_created); $this->tables_created = $tables_created; //TBGScope::setupInitialScope(); } catch (Exception $e) { throw $e; $this->error = $e->getMessage(); } }