db.class.php

Go to the documentation of this file.

<?php
final class db {

        const FETCH_ASSOC = PDO::FETCH_ASSOC;
        const FETCH_BOTH = PDO::FETCH_BOTH;
        const FETCH_NUM = PDO::FETCH_NUM;
        const FETCH_ROWSET = PDO::FETCH_CLASS;
        const FETCH_COLUMN = PDO::FETCH_COLUMN;

        private static $instances = array();

        private static $cfg = null;

        private static $tables = array();

        private static $log = array();

        private function __construct() {}

        public static function getInstance($cfg=null) {
                if (is_array($cfg)) {
                        $cfg['getInstanceCfg'] = $cfg;
                        return factory::get('db_'.$cfg['use'], $cfg);
                }

                self::init();

        if (is_null($cfg))
            $cfg = self::$cfg->get('defCfg');

                if (!array_key_exists($cfg, self::$instances)) {
                        $tmp = self::$cfg->get($cfg);
                        $tmp['getInstanceCfg'] = $cfg;
                        $use = $tmp['use'];
                        unset($tmp['use']);
                        self::$instances[$cfg] = factory::get('db_'.$use, $tmp);
                }
                return self::$instances[$cfg];
        }

        public static function get($type, $table, array $prm = array()) {
                if ($type == 'table' && array_key_exists($table, self::$tables))
                        return self::$tables[$table];

                self::init();

                if ($table instanceof db_table) {
                        $tableName = $table->getName();
                        if (!array_key_exists('table', $prm))
                                $prm['table'] = $table;
                } else {
                        $tableName = $table;
                        if ($type == 'table' && !array_key_exists('name', $prm))
                                $prm['name'] = $table;
                        else if ($type == 'row' && !array_key_exists('table', $prm)) {
                                $db = array_key_exists('db', $prm)? $prm['db'] : self::getInstance();
                                $prm['table'] = self::get('table', $tableName, array('db'=>$db));
                        }
                }

                if (!($className = self::$cfg->getInArray($type, $tableName)) &&
                        (!factory::isCreable($className = 'db_'.$type.'_'.$tableName)))
                        $className = self::$cfg->get($type.'Class');

                if ($type == 'table') {
                        self::$tables[$table] = factory::get($className, $prm);
                        return self::$tables[$table];
                }

                return factory::get($className, $prm);
        }

        public static function getCfg($key) {
                return self::$cfg->get($key);
        }

        public static function isI18nName($field) {
                return substr($field, 0, strlen(self::getCfg('i18n'))) == self::getCfg('i18n');
        }

        public static function unI18nName($field) {
                return self::isI18nName($field)? substr($field, strlen(self::getCfg('i18n'))) : $field;
        }

        public static function log($sql=null, $bind=null) {
                if (is_null($sql))
                        return self::$log;
                else if (empty($bind))
                        self::$log[] = $sql;
                else
                        self::$log[] = array($sql, $bind);
        }

        protected static function init() {
                if (self::$cfg == null)
                        self::$cfg = new config(factory::loadCfg(__CLASS__));
        }

}