/** * 批量创建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); }