generate.php 文件出现 Doctrine dsn 错误
我一直在研究下面链接上的介绍,并且已经能够完成前面的步骤,但是当运行generate.php 文件时,我收到有关 dsn 的错误。是否遗漏了更改 dsn 的步骤? http: //www.doctrine-project.org/projects/orm/1.2/docs/manual/introduction-to-models/en#introduction-to-models
-----------------------------------
error output
-----------------------------------
Fatal error: Uncaught exception 'Doctrine_Connection_Exception' with message 'You must create your Doctrine_Connection by using a valid Doctrine style dsn in order to use the create/drop database functionality' in /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Connection.php:1460
Stack trace:
#0 /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Manager.php(707): Doctrine_Connection->dropDatabase()
#1 /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Core.php(972): Doctrine_Manager->dropDatabases(Array)
#2 /Users/sone/sources/doctrine1.2/doctrine_test/generate.php(8): Doctrine_Core::dropDatabases()
#3 {main}
thrown in /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Connection.php on line 1460
-----------------------------------
我在这里的generate.php文件中看到了类似的问题(上面的链接)但提供的解决方案和错误略有不同,在我的情况下不起作用。将 dsn 字符串更改为 $ conn = doctrine_manager ::连接('mysql:// sonint99:/学说');也不行。我现在收到这个错误。
si2:doctrine_test sone$ phpgenerate.php
Fatal error: Uncaught exception 'Doctrine_Manager_Exception' with message 'Unknown connection: doctrine' in /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Manager.php:512
Stack trace:
#0 /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Manager.php(554): Doctrine_Manager->getConnection('doctrine')
#1 /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Export.php(1107): Doctrine_Manager->getConnectionForComponent('Test')
#2 /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Export.php(1205): Doctrine_Export->exportSortedClassesSql(Array)
#3 /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Export.php(1100): Doctrine_Export->exportClasses(Array)
#4 /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Core.php(894): Doctrine_Export->exportSchema('models')
#5 /Users/sone/sources/doctrine1.2/doctrine_test/generate.php(11): Doctrine_Core::createTablesFromModels('models')
#6 {main}
in /Users/sone/sources/doctrine1.2/doctrine_test/lib/vendor/doctrine/Doctrine/Manager.php on line 512
我的引导带
<?php
// bootstrap.php
/**
* Bootstrap Doctrine.php, register autoloader specify
* configuration attributes and load models.
*/
require_once(dirname(__FILE__) . '/lib/vendor/doctrine/Doctrine.php');
// ...
spl_autoload_register(array('Doctrine', 'autoload'));
// ...
$manager = Doctrine_Manager::getInstance();
$manager->setAttribute(Doctrine_Core::ATTR_AUTO_ACCESSOR_OVERRIDE, true);
$manager->setAttribute(Doctrine_Core::ATTR_AUTOLOAD_TABLE_CLASSES, true);
// Setting up DB connection
$dsn = 'mysql:dbname=doctrine;host=127.0.0.1';
$user = 'sonint99';
$password = 'C2sHF9Zxq3ULXCTV';
$dbh = new PDO($dsn, $user, $password);
$conn = Doctrine_Manager::connection($dbh,'doctrine');
Doctrine_Core::loadModels('models');
//$conn = Doctrine_Manager::connection('mysql://sonint99:[email protected]/doctrine');
generate.php
<?php
// generate.php
require_once('bootstrap.php');
Doctrine_Core::dropDatabases();
Doctrine_Core::createDatabases();
Doctrine_Core::generateModelsFromYaml('schema.yml', 'models');
Doctrine_Core::createTablesFromModels('models');
schema.yml
Test:
connection: doctrine
tableName: test
columns:
id:
type: integer(8)
autoincrement: true
primary: true
name:
type: string()
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
User:
connection: doctrine
tableName: user
columns:
id:
type: integer(8)
fixed: false
unsigned: false
primary: true
autoincrement: true
first_name:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
last_name:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
username:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
password:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
type:
type: string(255)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
is_active:
type: integer(1)
fixed: false
unsigned: false
primary: false
default: '1'
notnull: false
autoincrement: false
is_super_admin:
type: integer(1)
fixed: false
unsigned: false
primary: false
default: '0'
notnull: false
autoincrement: false
created_at:
type: timestamp(25)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
updated_at:
type: timestamp(25)
fixed: false
unsigned: false
primary: false
default: '0000-00-00 00:00:00'
notnull: true
autoincrement: false
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
文档相当奇怪,因为他们提到了
::connection()
方法的 PDO。该方法甚至没有在网站上的教程中使用;)正确的连接调用可能是这样的
The Docs are rather strange because they mention PDO for the
::connection()
method. This method is not even used in the tutorials on the site ;)A proper call with the connection could be like