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

在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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 我需要全国每个城市的最新小区名字等数据。
  • ¥15 开发一个小区生态的小程序
  • ¥15 MddBootstrapInitialize2失败
  • ¥15 LCD Flicker
  • ¥15 Spring MVC项目,访问不到相应的控制器方法
  • ¥15 esp32在micropython环境下使用ssl/tls连接mqtt服务器出现以下报错Connected on 192.168.154.223发生意外错误: 5无法连接到 MQTT 代理,如何解决?
  • ¥15 关于#genesiscsheel#的问题,如何解决?
  • ¥15 Android aidl for hal
  • ¥15 STM32CubeIDE下载程序报错
  • ¥15 微信好友如何转变为会员系统?(相关搜索:小程序)