/**
* 获取从库句柄
* @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;
}
