示例#1
0
 /**
  * set database
  * @param string $database
  */
 public function setDB($database = 'PF')
 {
     $f3 = \Base::instance();
     if ($database === 'CCP') {
         // CCP DB
         $dns = Controller\Controller::getEnvironmentData('DB_CCP_DNS');
         $name = Controller\Controller::getEnvironmentData('DB_CCP_NAME');
         $user = Controller\Controller::getEnvironmentData('DB_CCP_USER');
         $password = Controller\Controller::getEnvironmentData('DB_CCP_PASS');
     } else {
         // Pathfinder DB
         $dns = Controller\Controller::getEnvironmentData('DB_DNS');
         $name = Controller\Controller::getEnvironmentData('DB_NAME');
         $user = Controller\Controller::getEnvironmentData('DB_USER');
         $password = Controller\Controller::getEnvironmentData('DB_PASS');
     }
     // check for DB switch. If current DB equal new DB -> no switch needed
     if (!$f3->exists('DB') || $name !== $f3->get('DB')->name()) {
         $db = $this->connect($dns, $name, $user, $password);
         $f3->set('DB', $db);
         // set DB timezone to UTC +00:00 (eve server time)
         $f3->get('DB')->exec('SET @@session.time_zone = "+00:00";');
         // disable innoDB schema (relevant vor MySql 5.5)
         // not necessary for MySql > v.5.6
         //$f3->get('DB')->exec('SET GLOBAL innodb_stats_on_metadata = OFF;');
     }
 }
示例#2
0
 /**
  * get database
  * @param string $database
  * @return mixed|void
  */
 public function getDB($database = 'PF')
 {
     $f3 = \Base::instance();
     $dbHiveKey = $this->getDbHiveKey($database);
     if ($f3->exists($dbHiveKey)) {
         return $f3->get($dbHiveKey);
     } else {
         return $this->setDB($database);
     }
 }
示例#3
0
 /**
  * re-assort the current collection using a sql-like syntax
  * @param $cond
  */
 public function orderBy($cond)
 {
     $cols = \Base::instance()->split($cond);
     $this->uasort(function ($val1, $val2) use($cols) {
         foreach ($cols as $col) {
             $parts = explode(' ', $col, 2);
             $order = empty($parts[1]) ? 'ASC' : $parts[1];
             $col = $parts[0];
             list($v1, $v2) = array($val1[$col], $val2[$col]);
             if ($out = strnatcmp($v1, $v2) * ((strtoupper($order) == 'ASC') * 2 - 1)) {
                 return $out;
             }
         }
         return 0;
     });
 }
示例#4
0
 /**
  * connect to a database
  * @param $dns
  * @param $name
  * @param $user
  * @param $password
  * @return SQL
  */
 protected function connect($dns, $name, $user, $password)
 {
     $db = null;
     try {
         $db = new SQL($dns . $name, $user, $password, [\PDO::MYSQL_ATTR_COMPRESS => true, \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION, \PDO::ATTR_TIMEOUT => \Base::instance()->get('REQUIREMENTS.MYSQL.PDO_TIMEOUT')]);
     } catch (\PDOException $e) {
         // DB connection error
         // -> log it
         self::getLogger()->write($e->getMessage());
     }
     return $db;
 }
示例#5
0
 /**
  * get an intersection from a cached relation-set, based on given keys
  * @param string $prop
  * @param array|string $keys
  * @return array
  */
 public function getSubset($prop, $keys)
 {
     if (is_string($keys)) {
         $keys = \Base::instance()->split($keys);
     }
     if (!is_array($keys)) {
         trigger_error(sprintf(self::E_SubsetKeysValue, gettype($keys)));
     }
     if (!$this->hasRelSet($prop) || !($relSet = $this->getRelSet($prop))) {
         return null;
     }
     foreach ($keys as &$key) {
         if ($key instanceof \MongoId) {
             $key = (string) $key;
         }
     }
     return array_values(array_intersect_key($relSet, array_flip($keys)));
 }