php PHP实体类生成器
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10149224/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
PHP entity class generator
提问by U?ur Gümü?han
I am creating entity (of entity-view-controller)(in other words, model of MVC) classes which theoreticlly match the databse table I have. Is there a tool which reads mysql table and creates a model class code? (NOT on execution, a code output is required) I expect an output like
我正在创建实体（实体-视图-控制器）（换句话说，MVC 模型）类，这些类在理论上与我拥有的数据库表相匹配。是否有读取mysql表并创建模型类代码的工具？（不是在执行时，需要代码输出）我希望输出像
class{
public $columnname1;
public $columnname2;
public $columnname3;
public $columnname4;
public $columnname5;
public $columnname6;
function __construct(&$columnname1, &$columnname2){...}
function insert(&$columnname1, &$columnname2){}
function delete(&$columnname1){}
...
}
A tool which would also create insert,update and delete by id functions would help me a lot.
一个也可以通过 id 函数创建插入、更新和删除的工具对我有很大帮助。
The tool may be free or paid.
该工具可能是免费的，也可能是付费的。
采纳答案by Madara's Ghost
PDO can fetch results into an object.
PDO 可以将结果提取到一个对象中。
Design a class which matches your database/query structure, and use Misread the question, my bad.PDO::FETCH_INTOto fetch the result set into an already instantiated object.
设计一个与您的数据库/查询结构相匹配的类，并用于误读了这个问题，我的错。PDO::FETCH_INTO将结果集提取到已实例化的对象中。
To generate the class itself from the database structure, there are several projects (I haven't tested, but this came up on a very simple search).
为了从数据库结构生成类本身，有几个项目（我没有测试过，但这是一个非常简单的搜索）。
回答by Benny Hill
The following code is what I've used for a long time to create PHP models for MySQL and DB2 tables. I've got stubs in place for MSSQL, PGSQL and SQLite but have never needed to complete them.
以下代码是我长期以来用于为 MySQL 和 DB2 表创建 PHP 模型的代码。我已经为 MSSQL、PGSQL 和 SQLite 准备了存根，但从未需要完成它们。
Here's the code generator class:
这是代码生成器类：
<?php
/**
* @license http://opensource.org/licenses/MIT The MIT License
* @version 1.0.0_20130220000000
*/
/**
* This class will generate PHP source code for a "model" that interfaces with
* a database table.
*
* @license http://opensource.org/licenses/MIT The MIT License
* @version 1.0.0_20130220000000
*/
class db_code_generator{
private $closing_tag;
private $columns;
private $database;
private $host;
private $password;
private $port;
private $table;
private $type;
private $username;
/**
* Constructor. By default we will try to connect to a MySQL database on
* localhost.
*
* @param string $database The name of the database the user wants to connect
* to.
*
* @param string $table The name of the table to generate code for.
*
* @param string $username The username we should use to connect to the
* database.
*
* @param string $password The password we need to connect to the database.
*
* @param string $host The host or server we will try to connect to. If the
* user doesn't give us a host we default to localhost.
*
* @param string $port The port we should try to connect to. Typically this
* will not be passed so we default to NULL.
*
* @param string $type The type of database we are connecting to. Valid
* values are: db2, mssql, mysql, pgsql, sqlite.
*/
public function __construct($database = NULL,
$table = NULL,
$username = NULL,
$password = NULL,
$host = 'localhost',
$type = 'mysql',
$port = NULL,
$closing_tag = TRUE){
$this->database = $database;
$this->table = $table;
$this->username = $username;
$this->password = $password;
$this->host = $host;
$this->port = $port;
$this->type = $type;
$this->closing_tag = $closing_tag;
}
/**
* Generate the code for a model that represents a record in a table.
*
* @return string The PHP code generated for this model.
*/
public function get_code(){
$this->get_data_definition();
$code = $this->get_file_head();
$code .= $this->get_properties();
$code .= $this->get_ctor();
$code .= $this->get_dtor();
$code .= $this->get_method_stubs();
$code .= $this->get_file_foot();
return $code;
}
/**
* Create the code needed for the __construct function.
*
* @return string The PHP code for the __construct function.
*/
private function get_ctor(){
$code = "\t/**\n";
$code .= "\t * Constructor.\n";
$code .= "\t *\n";
$code .= "\t * @param mixed $id The unique id for a record in this table. Defaults to NULL\n";
if ('db2' === $this->type){
$code .= "\n\t * @param string $library The library where the physical file resides. Defaults to LIBRARY\n";
}
$code .= "\t *\n";
$code .= "\t * @see base_$this->type::__construct\n";
$code .= "\t */\n";
if ('db2' === $this->type){
$code .= "\tpublic function __construct($id = NULL, $library = 'LIBRARY'){\n";
$code .= "\t\tparent::__construct($id, $library);\n";
}else{
$code .= "\tpublic function __construct($id = NULL){\n";
$code .= "\t\tparent::__construct($id);\n";
}
$code .= "\t}\n\n";
return $code;
}
/**
* Connect to the requested database and get the data definition for the
* requested table.
*/
private function get_data_definition(){
try{
switch ($this->type){
case 'db2':
$this->get_data_definition_db2();
break;
case 'mssql':
$this->get_data_definition_mssql();
break;
case 'mysql':
$this->get_data_definition_mysql();
break;
case 'pgsql':
$this->get_data_definition_pgsql();
break;
case 'sqlite':
$this->get_data_definition_sqlite();
break;
}
}catch(PDOException $e){
}
}
/**
* Get data definition information for a DB2 table.
*/
private function get_data_definition_db2(){
$con = new PDO("odbc:DRIVER={iSeries Access ODBC Driver};SYSTEM=$this->host;PROTOCOL=TCPIP", $this->username, $this->password);
$sql = "SELECT COLUMN_NAME, COLUMN_SIZE, COLUMN_TEXT, DECIMAL_DIGITS, ORDINAL_POSITION, TYPE_NAME FROM SYSIBM.SQLCOLUMNS WHERE TABLE_SCHEM = '". strtoupper($this->database) ."' AND TABLE_NAME = '". strtoupper($this->table) ."'";
$statement = $con->prepare($sql);
if ($statement->execute()){
while ($row = $statement->fetch()){
if (NULL !== $row['DECIMAL_DIGITS']){
$decimal = $row['DECIMAL_DIGITS'];
}else{
$decimal = NULL;
}
if ('DECIMAL' === $row['TYPE_NAME'] && NULL !== $row['DECIMAL_DIGITS'] && '0' !== $row['DECIMAL_DIGITS']){
$type = 'float';
}else if ('DECIMAL' === $row['TYPE_NAME']){
$type = 'integer';
}else{
$type = strtolower($row['TYPE_NAME']);
}
if ('1' === $row['ORDINAL_POSITION']){
$key = 'PRI';
}else{
$key = NULL;
}
$this->columns[$row['COLUMN_NAME']] = array('allow_null' => TRUE,
'decimal' => $decimal,
'default' => NULL,
'extra' => NULL,
'key' => $key,
'length' => $row['COLUMN_SIZE'],
'name' => $row['COLUMN_NAME'],
'text' => $row['COLUMN_TEXT'],
'type' => $type);
}
ksort($this->columns);
}
}
/**
* Get data definition information for a MS SQL table.
*/
private function get_data_definition_mssql(){
return "The code for generating MS SQL models is not yet implemented.\n";
}
/**
* Get data definition information for a MySQL table.
*/
private function get_data_definition_mysql(){
$dsn = "mysql:host=$this->host;";
if (NULL !== $this->port){
$dsn .= "port=$this->port;";
}
$dsn .= "dbname=$this->database";
$con = new PDO($dsn, $this->username, $this->password);
$sql = "SHOW COLUMNS FROM $this->table";
$statement = $con->prepare($sql);
if ($statement->execute()){
while ($row = $statement->fetch()){
$this->columns[$row['Field']] = array('allow_null' => $row['Null'],
'decimal' => NULL,
'default' => $row['Default'],
'extra' => $row['Extra'],
'key' => $row['Key'],
'length' => NULL,
'name' => $row['Field'],
'text' => NULL,
'type' => $row['Type']);
}
ksort($this->columns);
}
}
/**
* Get data definition information for a PostgreSQL table.
*/
private function get_data_definition_pgsql(){
return "The code for generating PostgreSQL models is not yet implemented.\n";
}
/**
* Get data definition information for a SQLite table.
*/
private function get_data_definition_sqlite(){
return "The code for generating SQLite models is not yet implemented.\n";
}
/**
* Create the code needed for the __destruct function.
*
* @return string The PHP code for the __destruct function.
*/
private function get_dtor(){
$code = "\t/**\n";
$code .= "\t * Destructor.\n";
$code .= "\t */\n";
$code .= "\tpublic function __destruct(){\n";
$code .= "\t\tparent::__destruct();\n";
$code .= "\t}\n\n";
return $code;
}
/**
* Generate the code found at the end of the file - the closing brace, the
* ending PHP tag and a new line. Some PHP programmers prefer to not have a
* closing PHP tag while others want the closing tag and trailing newline -
* it probably just depends on their programming background. Regardless it's
* best to let everyone have things the way they want.
*/
private function get_file_foot(){
$code = '';
if ($this->closing_tag){
$code .= "}\n?>\n";
}else{
$code .= '}';
}
return $code;
}
/**
* Generate the code found at the beginning of the file - the PHPDocumentor
* doc block, the require_once for the correct base class and the class name.
*
* @return string The code generated for the beginning of the file.
*/
private function get_file_head(){
$code = "<?php\n";
$code .= "/**\n";
$code .= " * Please enter a description of this class.\n";
$code .= " *\n";
$code .= " * @author XXX <[email protected]>\n";
$code .= " * @copyright Copyright (c) ". date('Y') ."\n";
$code .= " * @license http://www.gnu.org/licenses/gpl-3.0.html GPLv3\n";
$code .= " * @version ". date('Ymd') ."\n";
$code .= " */\n\n";
$code .= "require_once('base_$this->type.php');\n\n";
$code .= "class ". strtolower($this->table) ." extends base_$this->type{\n";
return $code;
}
/**
* Generate the code for a delete method stub.
*
* @return string The PHP code for the method stub.
*/
private function get_method_stub_delete(){
$code = "\t/**\n";
$code .= "\t * Override the delete method found in the base class.\n";
$code .= "\t *\n";
$code .= "\t * @param mixed $id The unique record ID to be deleted.\n";
$code .= "\t *\n";
$code .= "\t * @return bool TRUE if a record was successfully deleted from the table, FALSE otherwise.\n";
$code .= "\t */\n";
$code .= "\tpublic function delete($id){\n";
$code .= "\t\treturn parent::delete($id);\n";
$code .= "\t}\n\n";
return $code;
}
/**
* Generate the code for an insert method stub.
*
* @return string The PHP code for the method stub.
*/
private function get_method_stub_insert(){
$code = "\t/**\n";
$code .= "\t * Override the insert method found in the base class.\n";
$code .= "\t *\n";
$code .= "\t * @param array $parms An array of data, probably the $_POST array.\n";
$code .= "\t * @param bool $get_insert_id A flag indicating if we should get the autoincrement value of the record just created.\n";
$code .= "\t *\n";
$code .= "\t * @return bool TRUE if a record was successfully inserted into the table, FALSE otherwise.\n";
$code .= "\t */\n";
$code .= "\tpublic function insert($parms, $get_insert_id = FALSE){\n";
$code .= "\t\treturn parent::insert($parms, $get_insert_id);\n";
$code .= "\t}\n\n";
return $code;
}
/**
* Generate the code for an update method stub.
*
* @return string The PHP code for the method stub.
*/
private function get_method_stub_update(){
$code = "\t/**\n";
$code .= "\t * Override the update method found in the base class.\n";
$code .= "\t *\n";
$code .= "\t * @param array &$parms An array of key=>value pairs - most likely the $_POST array.\n";
$code .= "\t *\n";
$code .= "\t * @param integer $limit The number of records to update. Defaults to NULL.\n";
$code .= "\t *\n";
$code .= "\t * @return bool TRUE if a record was successfully updated, FALSE otherwise.\n";
$code .= "\t */\n";
$code .= "\tpublic function update($parms, $limit = NULL){\n";
$code .= "\t\treturn parent::update($parms, $limit);\n";
$code .= "\t}\n\n";
return $code;
}
/**
* Create method stubs for create, delete and update.
*
* @return string The PHP code for these stubs.
*/
private function get_method_stubs(){
$code = $this->get_method_stub_delete();
$code .= $this->get_method_stub_insert();
$code .= $this->get_method_stub_update();
return $code;
}
private function get_properties(){
$code = '';
if (count($this->columns)){
foreach ($this->columns AS $index => $col){
$code .= "\t/**\n";
if (NULL !== $col['text']){
$code .= "\t * $col[text]\n";
}else{
$code .= "\t * Description\n";
}
$code .= "\t * @var ". $col['type'];
if (NULL !== $col['length']){
$code .= " ($col[length]";
if (NULL !== $col['decimal']){
$code .= ",$col[decimal]";
}
$code .= ")";
}
$code .= "\n\t */\n";
$temp_name = str_replace('#', '_', $col['name']);
$code .= "\tpublic $$temp_name;\n\n";
}
}
return $code;
}
}
?>
and here's a simple page to use it:
这是一个使用它的简单页面：
<?php
/**
* @license GPLv3 (http://www.gnu.org/licenses/gpl-3.0.html)
* @version 1.0.0_20130220000000
*/
require_once('db_code_generator.php');
$table_type = array();
$table_type['db2'] = 'DB2/400 (db2)';
$table_type['mssql'] = 'Microsoft SQL Server (mssql)';
$table_type['mysql'] = 'MySQL (mysql)';
$table_type['pgsql'] = 'PostGRESQL (pgsql)';
$table_type['sqlite'] = 'SQLite (sqlite)';
$database = (isset($_POST['database'])) ? $_POST['database'] : 'my_database';
$host = (isset($_POST['host'])) ? $_POST['host'] : 'localhost';
$username = (isset($_POST['username'])) ? $_POST['username'] : 'root';
$password = (isset($_POST['password'])) ? $_POST['password'] : '';
$table = (isset($_POST['table'])) ? $_POST['table'] : '';
$type = (isset($_POST['type'])) ? $_POST['type'] : 'mysql';
$library = (isset($_POST['library'])) ? $_POST['library'] : 'LIBRARY';
$file = (isset($_POST['file'])) ? $_POST['file'] : 'STATES';
//---------------------------------------------------------------------------
?>
<div class="data_input">
<form action="" method="post">
<fieldset class="top">
<legend>Code Generator</legend>
<label for="host">Hostname or IP:
<input id="host" maxlength="32" name="host" tabindex="<?php echo $tabindex++; ?>" title="Enter the database host name" type="text" value="<?php echo $host; ?>" />
</label>
<br />
<label for="username">Username:
<input id="username" maxlength="32" name="username" tabindex="<?php echo $tabindex++; ?>" title="Enter the database username" type="text" value="<?php echo $username; ?>" />
</label>
<br />
<label for="password">Password:
<input id="password" maxlength="32" name="password" tabindex="<?php echo $tabindex++; ?>" title="Enter the database password" type="password" value="<?php echo $password; ?>" />
</label>
<br />
<label for="type">Type:
<select id="type" name="type" tabindex="<?php echo $tabindex++; ?>">
<?php
foreach ($table_type AS $key=>$value){
echo('<option ');
if ($key == $type){
echo 'selected="selected" ';
}
echo 'value="'. $key .'">'. $value .'</option>';
}
?>
</select>
</label>
<br />
</fieldset>
<fieldset class="top">
<legend>PostGRESQL/MSSQL/MySQL Parameters</legend>
<label for="database">Database:
<input id="database" maxlength="100" name="database" tabindex="<?php echo $tabindex++; ?>" title="Enter the database name" type="text" value="<?php echo $database; ?>" />
</label>
<br />
<label for="table">Table:
<input id="table" maxlength="100" name="table" tabindex="<?php echo $tabindex++; ?>" title="Enter the table name" type="text" value="<?php echo $table; ?>" />
</label>
<br />
</fieldset>
<fieldset class="top">
<legend>DB2 Parameters</legend>
<label for="library">Library:
<input id="library" maxlength="10" name="library" tabindex="<?php echo $tabindex++; ?>" title="Enter the library name" type="text" value="<?php echo $library; ?>" />
</label>
<br />
<label for="file">Physical File:
<input id="file" maxlength="10" name="file" tabindex="<?php echo $tabindex++; ?>" title="Enter the file name" type="text" value="<?php echo $file; ?>" />
</label>
<br />
</fieldset>
<fieldset class="bottom">
<button tabindex="<?php echo $tabindex++; ?>" type="submit">Generate!</button>
</fieldset>
</form>
</div>
<?php
if (isset($_POST['host'])){
if ('db2' == $_POST['type']){
$_POST['database'] = strtoupper($_POST['library']); // Library
$_POST['table'] = strtoupper($_POST['file']); // Physical file
$_POST['host'] = 'db2_host';
$_POST['username'] = 'db2_username';
$_POST['password'] = 'db2_password';
}
$object = new db_code_generator($_POST['database'], $_POST['table'], $_POST['username'], $_POST['password'], $_POST['host'], $_POST['type']);
echo('<textarea rows="75" style="margin-left : 50px; width : 90%;" onfocus="select()">'. $object->get_code() .'</textarea>');
}
?>
回答by Crazy Chuck
I understand you're looking for a ORM kind of a thing.
我知道您正在寻找一种 ORM 类型的东西。
hope this helps
希望这可以帮助
http://www.doctrine-project.org/
回答by SteAp
For what it's worth, Rafael Rochashares code here.
就其价值而言，Rafael Rocha在这里分享了代码。
Still, I strongly propose to use an ORM. Transforming MySQL structure back to a database-abstraction layer is anything but good...
不过，我强烈建议使用 ORM。将 MySQL 结构转换回数据库抽象层绝非好事...
回答by Halcyon
What about symfony? It does exactly what you say and you get a beastly good framework to go with it.
symfony怎么样？它完全按照你说的去做，你得到了一个非常好的框架来配合它。
symfony 'compiles' classes for you based on a data model that you supply. It will make sure that compiled classes and MySQL database structure are in sync.
symfony 根据您提供的数据模型为您“编译”类。它将确保编译的类和 MySQL 数据库结构是同步的。
This approach is favorable over a Reflectionbased approach as it's simply too slow.
这种方法优于Reflection基于方法的方法，因为它太慢了。
回答by user5386167
Try this https://github.com/rcarvello/mysqlreflection
试试这个 https://github.com/rcarvello/mysqlreflection
A useful utility I built for the Object Relation Mapping of MySQL databases.
我为 MySQL 数据库的对象关系映射构建的一个有用的实用程序。
The utility generates automatically PHP classes for any tables of a given database schema.
该实用程序为给定数据库模式的任何表自动生成 PHP 类。
The package is extracted from my personal PHP Web MVC Framework.
该包是从我个人的 PHP Web MVC 框架中提取的。
回答by Channaveer Hakari
I have written a PHP code which will automatically detect all the databases in MYSQL database, on selecting any of the database all of its related tables are loaded. You can select all the tables or any respective table to generate the Modal Class.
我写了一个 PHP 代码，它会自动检测 MYSQL 数据库中的所有数据库，在选择任何一个数据库时，它的所有相关表都被加载。您可以选择所有表或任何相应的表来生成模态类。
The following is the link to my repository
以下是我的存储库的链接
https://github.com/channaveer/EntityGenerator
https://github.com/channaveer/EntityGenerator
This will automatically create Entity folder and dump all the entity class into that folder.
这将自动创建实体文件夹并将所有实体类转储到该文件夹中。
NOTE - Currently only supported for MYSQL
注意 - 目前仅支持 MYSQL
Hope it helps. Happy Coding!
希望能帮助到你。快乐编码！
回答by Mayukh Roy
Yes, Doctrine is what you need.
是的，Doctrine 正是您所需要的。
Run a command, and you get all your tables' metadata in XML or YML format(choice is yours)
$ php app/console doctrine:mapping:convert xml ./src/Bundle/Resources/config/doctrine/metadata/orm --from-database --force
Once you generate the Metadata, command Doctrine to import the schema to build related entity classes you need. You will find all GET and SET functionality(read SELECT, UPDATEand INSERT) inside.
1.$ php app/console doctrine:mapping:import Bundle annotation
2.$ php app/console doctrine:generate:entities Bundle
运行一个命令，您将获得 XML 或 YML 格式的所有表格元数据（选择权在您手中）
$ php 应用程序/控制台学说：映射：转换 xml ./src/Bundle/Resources/config/doctrine/metadata/orm --from-database --force
生成元数据后，命令 Doctrine 导入架构以构建所需的相关实体类。您将在其中找到所有 GET 和 SET 功能（读取SELECT、UPDATE和INSERT）。
1.$ php app/console 原理:mapping:import Bundle注解
2.$ php app/console 原理:generate:entities Bundle
回答by Pavel Kostenko
Fat free frameworkallows you to work with existing tables using code like:
Fat free 框架允许您使用以下代码处理现有表：
$user=new DB\SQL\Mapper($db,'users');
// or $user=new DB\Mongo\Mapper($db,'users');
// or $user=new DB\Jig\Mapper($db,'users');
$user->userID='jane';
$user->password=md5('secret');
$user->visits=0;
$user->save();
The code above creates new record in userstable
上面的代码在用户表中创建新记录
回答by Mrigesh Raj Shrestha
I think you should make itout on your on. Every project and requirement of Model Code is different in my opinion. Two mysql queries will keep you in ease.
我想你应该把它拿出来。我认为每个项目和 Model Code 的要求都是不同的。两个 mysql 查询将使您轻松自在。
SHOW TABLES FROM db_NAME //this gives the table listing, so its Master LooperDESC tbl_name //detail query that fetches column information of given table
SHOW TABLES FROM db_NAME //this gives the table listing, so its Master LooperDESC tbl_name //detail query that fetches column information of given table
DESC tbl_namewill give Field, Type, Null, Key, Default and Extra Columns.
DESC tbl_name将给出字段、类型、空值、键、默认和额外列。
e.g. values seperated in pipes (|):
例如用管道 (|) 分隔的值：
Id | int(11) | NO | PRI | NULL | auto_increment |
身 | 整数(11) | 否 | PRI | 空 | 自动增量|
I followed these to make Model, controller and Viewer files supporting CRUD operation in Codeigniter 2 way back. It worked just fine.
我按照这些来制作支持 Codeigniter 2 中的 CRUD 操作的模型、控制器和查看器文件。它工作得很好。
![php SQLSTATE[42S22]：未找到列：1054 未知列](/res/img/loading.gif)