PHP BizSystem::dbConnection方法代码示例

function giveActionAccess($where, $role_id)
{
    $db = BizSystem::dbConnection();
    try {
        if (empty($where)) {
            $sql = "SELECT * FROM acl_action";
        } else {
            $sql = "SELECT * FROM acl_action WHERE {$where}";
        }
        BizSystem::log(LOG_DEBUG, "DATAOBJ", $sql);
        $rs = $db->fetchAll($sql);
        $sql = "";
        foreach ($rs as $r) {
            $sql = "DELETE FROM acl_role_action WHERE role_id={$role_id} AND action_id={$r['0']}; ";
            BizSystem::log(LOG_DEBUG, "DATAOBJ", $sql);
            $db->query($sql);
            $sql = "INSERT INTO acl_role_action (role_id, action_id, access_level) VALUES ({$role_id},{$r['0']},1)";
            BizSystem::log(LOG_DEBUG, "DATAOBJ", $sql);
            $db->query($sql);
        }
    } catch (Exception $e) {
        echo "ERROR: " . $e->getMessage() . "" . PHP_EOL;
        return false;
    }
}

 function open($savePath, $sessionName)
 {
     // echo "session open".nl;
     // connect to session db
     $this->sessionDb = BizSystem::dbConnection(SESSION_DBNAME);
     $sessionID = session_id();
     if ($sessionID !== "") {
         $this->initSessionData = $this->read($sessionID);
     }
     return true;
 }

 /**
  * Get database connection
  *
  * @return Zend_Db_Adapter_Abstract
  **/
 public function getDBConnection()
 {
     return BizSystem::dbConnection($this->m_Database);
 }

 /**
  * Execute SQL
  *
  * @param array $argList
  * @return void
  */
 protected function executeSQL($argList)
 {
     $dbName = $argList["DBName"];
     if (!$dbName) {
         $dbName = "Default";
     }
     $sql = $argList["SQL"];
     $db = BizSystem::dbConnection($dbName);
     try {
         $resultSet = $db->query($sql);
     } catch (Exception $e) {
         $errorMessage = "Error in run SQL: " . $sql . ". " . $e->getMessage();
     }
 }

 public function DBConnection()
 {
     return BizSystem::dbConnection($this->dbName);
 }

 /**
  * Get database connection
  *
  * @return Zend_Db_Adapter_Abstract
  **/
 public function getDBConnection($type = 'default')
 {
     switch (strtolower($type)) {
         case "default":
         case "read":
             if ($this->m_DatabaseforRead) {
                 $dbName = $this->m_DatabaseforRead;
             } else {
                 $dbName = $this->m_Database;
             }
             break;
         case "write":
             if ($this->m_DatabaseforWrite) {
                 $dbName = $this->m_DatabaseforWrite;
             } else {
                 $dbName = $this->m_Database;
             }
             break;
     }
     return BizSystem::dbConnection($dbName);
 }

echo "This script is to create cubi installation database." . PHP_EOL;
echo "Please create a CubiInstall database in cubi/Config.xml." . PHP_EOL;
echo "Is CubiInstall created? (y/n) ";
// Read the input
$answer = trim(fgets(STDIN));
echo "Your answer is {$answer}" . PHP_EOL;
if ($answer != 'y') {
    exit;
}
include_once dirname(dirname(__FILE__)) . "/app_init.php";
if (!defined("CLI")) {
    exit;
}
include_once MODULE_PATH . "/system/lib/ModuleLoader.php";
$cubiInstallDb = "CubiInstall";
$db = BizSystem::dbConnection($cubiInstallDb);
if (!$db) {
    echo "Please create a CubiInstall database in cubi/Config.xml." . PHP_EOL;
}
$modules = array('system', 'menu');
foreach (glob(MODULE_PATH . DIRECTORY_SEPARATOR . "*") as $dir) {
    $modName = str_replace(MODULE_PATH . DIRECTORY_SEPARATOR, "", $dir);
    if ($modName != "system" && $modName != "menu") {
        array_push($modules, $modName);
    }
}
// find all modules
foreach ($modules as $mod) {
    echo PHP_EOL . "---------------------------------------------------" . PHP_EOL;
    echo "> Start loading '{$mod}' module ..." . PHP_EOL;
    $loader = new ModuleLoader($mod, $cubiInstallDb);

 /**
  * Load table index and uniqueness information
  * @return void
  */
 protected function getTableIndex()
 {
     $db = BizSystem::dbConnection($this->db_name);
     $db_driver = $this->db_config['Driver'];
     switch (strtoupper($db_driver)) {
         case 'PDO_MYSQL':
             $sql = "SHOW INDEX FROM {$this->table_name};";
             $result = $db->query($sql);
             $tblIndexes = $result->fetchAll();
             break;
         default:
             break;
     }
     $tableIndex = array();
     if ($tblIndexes) {
         foreach ($tblIndexes as $colIndex) {
             $non_unique = $colIndex[1];
             $key_name = $colIndex[2];
             $col_name = $colIndex[4];
             if ($key_name != "PRIMARY" && $tblCols[$col_name]['DATA_TYPE'] != 'int') {
                 //$tableIndex[$key_name]=array();
                 $indexInfo = array("NON_UNIQUE" => $non_unique, "KEY_NAME" => $key_name, "COL_NAME" => $col_name);
                 if (!is_array($tableIndex[$key_name])) {
                     $tableIndex[$key_name] = array();
                 }
                 array_push($tableIndex[$key_name], $indexInfo);
             }
         }
     }
     $this->tableIndex = $tableIndex;
     $uniqueness = "";
     foreach ($tableIndex as $key_name => $key_index) {
         $key_uniqueness = "";
         foreach ($key_index as $indexInfo) {
             if ($indexInfo['NON_UNIQUE'] == "0") {
                 if ($key_uniqueness != "") {
                     $key_uniqueness .= ",";
                 }
                 $key_uniqueness .= $indexInfo['COL_NAME'];
             }
         }
         if ($key_uniqueness != "") {
             $uniqueness .= $key_uniqueness . ";";
         }
     }
     $this->uniqueness = $uniqueness;
 }

 /**
  * Get Database profile
  *
  * @todo not finish
  * @param <type> $userId
  * @param <type> $password
  */
 protected function getDBProfile($userId, $password)
 {
     // CASE 1: simple one table query
     // SELECT role, group, pstn, divn, org FROm user_table AS t1
     // WHERE t1.userid='$userid'
     // CASE 2: intersection table user_pstn (user_role, user_divn, user_org ...), need to query multiple times
     // SELECT t1.pstnid, t2.name FROM user_pstn_table AS t1
     // JOIN pstn_table AS t2 ON t1.pstnid=t2.id
     // WHERE t1.userid='$userid'
     // CASE 3: all hierarchy info contained in one big party table, do query once, then filter on type column
     // SELECT t1.partyid, t2.name, t2.type FROM user_party_table AS t1
     // JOIN party_table AS t2 ON t1.partyid=t2.id
     // WHERE t1.userid='$userid'
     $db = BizSystem::dbConnection();
     $resultSet = $db->execute($sql);
     $sqlArr = $resultSet->fetchRow();
     // process the result
 }