/** * 获取从库句柄 * @return type */ protected function getSlaveDb() { if (empty($this->slaveHandler)) { $this->slaveHandler = DBMysqlNamespace::createDBHandle($this->slaveConfig, $this->database); } return $this->slaveHandler; }
/** * 初始化句柄 * @param type $dbConfig */ protected function setHandler($masterServer, $slaveServer, $database) { if (empty($masterServer) || empty($database)) { return false; } if (empty($slaveServer)) { $slaveServer = $masterServer; } $this->masterHandler = DBMysqlNamespace::createDBHandle($masterServer, $database); $this->slaveHandler = DBMysqlNamespace::createDBHandle($slaveServer, $database); //sql构造器 $this->sqlBuilder = new SqlBuilderV5($this->tableName, $this->fieldTypes, $this->slaveHandler); return true; }
public function test_multiInstance() { $h1 = DBMysqlNamespace::createDBHandle($this->db_config, $this->dbname, $this->encoding); //print_r( $h1 ); $arg = is_bool($h1) && $h1 === FALSE; $this->assertEquals($arg, FALSE); DBMysqlNamespace::releaseDBHandle($h1); }
public function setUp() { $dbLink = DBMysqlNamespace::createDBHandle(DBConfig::$SERVER_BANG_SLAVE, 'bang'); $this->sqlBuilder = new SqlBuilderV5('bang_promotion', array('id' => 'INT', 'bang_id' => 'INT', 'title' => 'VARCHAR', 'description' => 'VARCHAR', 'create_at' => 'INT', 'status' => 'INT', 'refuse_reason' => 'VARCHAR'), $dbLink); }
/** * 批量创建model文件 * @param type $server 服务器配置,例如DBConfig::$SERVER_MS_SLAVE * @param type $database 数据库,例如'beijing' * @param type $tableLike 表范围,例如'pet_post',或者'%_post' * @param type $fileDir 放置model的目录 * @return boolean */ public static function createModels($server, $database, $tableLike, $fileDir = '') { //获取表名称 $dbr = DBMysqlNamespace::createDBHandle($server, $database); $sql = "show tables like '{$tableLike}'"; $tables = DBMysqlNamespace::getAll($dbr, $sql); if (empty($tables)) { return false; } //为每个表创建model foreach ($tables as $tableInfo) { //获取表字段 $tableName = current($tableInfo); $sql = "DESC {$tableName}"; $dbFields = DBMysqlNamespace::getAll($dbr, $sql); //生成代码文件需要的变量 $dateText = date('Y-m-d H:i:s'); $className = self::_getClassName($tableName); //fieldTypes $fieldTypes = self::_getFieldTypes($dbFields); $fieldTypesString = PhpCodeGenerator::genArray($fieldTypes, false, ' '); $fieldTypesString = trim($fieldTypesString); $code = <<<modelCode <?php /** * 使用单例模式的model * @Copyright (c) 2013 Ganji Inc. * @date {$dateText} * (使用code_base2/util/db/script/model_builder.php生成) */ require_once CODE_BASE2 . '/util/db/ModelV5.class.php'; class {$className} extends ModelV5 { /** * 实例 */ private static \$_instance = null; /** * 表名 */ protected \$tableName = '{$tableName}'; /** * 表字段 */ protected \$fieldTypes = {$fieldTypesString}; protected function __construct() { //require_once GANJI_CONF . '/DBConfig.class.php'; //\$this->setHandler(DBConfig::\$SERVER_MS_MASTER, DBConfig::\$SERVER_MS_SLAVE, 'ganji_vehicle'); } public static function getInstance() { if (self::\$_instance instanceof self) { return self::\$_instance; } self::\$_instance = new self(); return self::\$_instance; } } modelCode; $filePath = self::_getFilePath($fileDir, $className); file_put_contents($filePath, $code); echo "{$filePath} 生成成功!\n"; } return true; }