dongyue0225
2012-09-21 11:21
浏览 105
已采纳

在Symfony中使用Doctrine创建表

After I had created a "motor" DB in MySQL, I configured the DB in Symfony with this command:

$ php symfony configure:database "mysql:host=localhost;dbname=motor" root <mypassword>

Under appname/config/doctrine/ I have a schema.yml file.

In this file I defined the following table:

Car:
  actAs: { Timestampable: ~ }
  columns: 
    brand: { type: string(255), notnull: true }
    model: { type: string(255), notnull: true }
    version: { type: string(255), notnull: true }
    url: { type: string(255), notnull: true }
    year: { type: string(4), notnull: true }
    info: { type: string(10000), notnull: true }
    updated_at: { type: timestamp, notnull: true }
    created_at: { type: timestamp, notnull: true } 

Then I executed the command:

$ php symfony doctrine:build --model

Which gave me the following output:

>> doctrine  generating model classes
>> file+     /tmp/doctrine_schema_57936.yml
>> tokens    /home/username/webapps/www/appname/lib/model/doctrine/CarTable.class.php
>> tokens    /home/username/webapps/www/appname/lib/model/doctrine/Car.class.php
>> tokens    /home/username/webapps/www/appname/lib/model/doctrine/base/BaseCar.class.php
>> autoload  Resetting application autoloaders
>> file-     /home/username/webapps/www/appname/cache/frontend/dev/config/config_autoload.yml.php

After that I proceeded to generate the sql with this command:

$ php symfony doctrine:build --sql

The output is:

>> doctrine  generating model classes
>> file+     /tmp/doctrine_schema_89541.yml
>> tokens    /home/username/webapps/www/motor/lib/model/doctrine/base/BaseCar.class.php
>> autoload  Resetting application autoloaders
>> file-     /home/username/webapps/www/motor/cache/frontend/dev/config/config_autoload.yml.php
>> doctrine  generating sql for models
>> doctrine  Generated SQL successfully for models

However under appname/data/sql/ the file schema.sql generated is empty.

So this command $ php symfony doctrine:insert-sql, didn't generated any table in my DB. However it gave a successful message output:

>> doctrine  creating tables
>> doctrine  created tables successfully

The command $ php symfony doctrine:build --all, didn't work either.

Any idea what I could be doing wrong?

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • duanni5726 2012-09-23 17:05
    已采纳

    It seems that there was nothing wrong with the methodology I was using in order to do this.

    The problem resided in the Symfony version I was using, which for some reason wasn't working correctly.

    In order to fix it I downloaded the latest Symfony 1.4.18 version and run the code again, this time it worked properly.

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题