phpmysqlorm_初探PHPORM框架Doctrine

概述

环境&＃xff1a;debian

Doctrine是PHP的一个ORM框架&＃xff0c;symfony的默认用的ORM就是Doctrine。

安装Composer

首先安装Composer&＃xff0c;Composer是PHP依赖管理工具&＃xff0c;类似Debian的apt&＃xff0c;Java的Maven&＃xff0c;安装说明可参考&＃xff1a;http://docs.phpcomposer.com/00-intro.html

mkdir composer

curl -sS https://getcomposer.org/installer | php

这样就把composer.phar下载了到了composer文件夹了。

为了目录根清晰&＃xff0c;我们新建一个和composer同级的目录doctrine.

cd .. && mkdir doctrine && cd doctrine

在doctrine文件夹里&＃xff0c;编写依赖文件composer.json&＃xff0c;内容如下&＃xff1a;

{

"require": {

"doctrine/orm": "2.4.*",

"symfony/yaml": "2.*"

},

"autoload": {

"psr-0": {

"": "src/"

}

}

}

安装依赖../composer/composer.phar install

有时会报异常&＃xff1a;

[Composer\Downloader\TransportException]

Your configuration does not allow connection to

http://packagist.org. See https://getcomposer.org/doc/06-config.md#secure-http

for details.

可以多试几次&＃xff0c;如果还不行可以尝试添加一个配置项&＃xff1a;

{

"require": {

"doctrine/orm": "2.4.*",

"symfony/yaml": "2.*"

},

"autoload": {

"psr-0": {

"": "src/"

}

},

"config": {

"secure-http": false

}

}

安装完依赖后&＃xff0c;如果你尝试运行 vendor/bin/doctrine&＃xff0c;会得到类似这样的提示&＃xff1a;

You are missing a “cli-config.php” or “config/cli-config.php” file in your

project, which is required to get the Doctrine Console working. You can use the

following sample as a template:

use Doctrine\ORM\Tools\Console\ConsoleRunner;

// replace with file to your own project bootstrap

require_once ‘bootstrap.php’;

// replace with mechanism to retrieve EntityManager in your app

$entityManager &＃61; GetEntityManager();

return ConsoleRunner::createHelperSet($entityManager);

告诉缺少cli-config.php文件&＃xff0c;于是添加如下两个文件bootstrap.php和cli-config.php&＃xff1a;

use Doctrine\ORM\Tools\Setup;

require_once "vendor/autoload.php";

// Create a simple "default" Doctrine ORM configuration for XML Mapping

$isDevMode &＃61; true;

$config &＃61; Setup::createAnnotationMetadataConfiguration(array(__DIR__."/src"), $isDevMode);

// or if you prefer yaml or annotations

//$config &＃61; Setup::createXMLMetadataConfiguration(array(__DIR__."/config/xml"), $isDevMode);

//$config &＃61; Setup::createYAMLMetadataConfiguration(array(__DIR__."/config/yaml"), $isDevMode);

// database configuration parameters

/*$conn &＃61; array(

&＃39;driver&＃39; &＃61;> &＃39;pdo_sqlite&＃39;,

&＃39;path&＃39; &＃61;> __DIR__ . &＃39;/db.sqlite&＃39;,

);*/

$conn &＃61; array(

&＃39;driver&＃39; &＃61;> &＃39;pdo_mysql&＃39;,

&＃39;user&＃39; &＃61;> &＃39;root&＃39;,

&＃39;password&＃39; &＃61;> &＃39;&＃39;,

&＃39;dbname&＃39; &＃61;> &＃39;foo&＃39;,

);

// obtaining the entity manager

$entityManager &＃61; \Doctrine\ORM\EntityManager::create($conn, $config);

// cli-config.php

require_once "bootstrap.php";

$helperSet &＃61; new \Symfony\Component\Console\Helper\HelperSet(array(

&＃39;em&＃39; &＃61;> new \Doctrine\ORM\Tools\Console\Helper\EntityManagerHelper($entityManager)

));

return $helperSet;

创建数据库和表

配置好bootstrap.php中的数据库以及目录(src)&＃xff0c;编写entity&＃xff0c;如Product.php

/**

* &＃64;Entity &＃64;Table(name&＃61;"products")

*/

class Product

{

/** &＃64;Id &＃64;Column(type&＃61;"integer") &＃64;GeneratedValue */

protected $id;

/** &＃64;Column(type&＃61;"string") */

protected $name;

public function getId()

{

return $this->id;

}

public function getName()

{

return $this->name;

}

public function setName($name)

{

$this->name &＃61; $name;

}

}

先登录Mysql创建数据库foo

create database foo;

然后可以执行

vendor/bin/doctrine orm:schema-tool:create

即可创建数据库表Products.