/**
* 批量创建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;
}
public function getAll($sql)
{
assert($this->_handle);
return DBMysqlNamespace::getAll($this->_handle, $sql);
}
/**
* 获取所有记录
* @param string|array $where where条件
* string e.g. string 'id=3 and create_at<2222222 or type in (2,3)'
* array e.g. array('id' => 3, 'type' => 2)
* @param string $orderBy 排序条件 e.g. 'id desc'
* @param int $limit 数量
* @param int $offset 偏移
* @param string $fields 选择的字段 'id,type,create_at'
* @return array
*/
public function getAll($where = '', $orderBy = '', $limit = 0, $offset = 0, $fields = '*')
{
if (empty($fields)) {
return array();
}
$sql = $this->sqlBuilder->createSelectSql($fields, $where, $orderBy, $limit, $offset);
if (empty($sql)) {
return array();
}
self::addSqlHistory($sql);
return DBMysqlNamespace::getAll($this->getSlaveDb(), $sql);
}
