Beispiel #1
0
    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';
    ?>
Beispiel #2
0
 /**
  * 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;
 }
Beispiel #3
0
 /**
  * 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();
     }
 }