在
MySQL中创建了“motor”DB之后,我使用以下命令在Symfony中配置了数据库:
$php symfony configure:database "mysql:host=localhost;dbname=motor" root
在appname / config / doctrine /下我有一个schema.yml文件.
在这个文件中我定义了下表:
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 }
然后我执行了命令:
$php symfony doctrine:build --model
这给了我以下输出:
>> 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
之后我继续用这个命令生成sql:
$php symfony doctrine:build --sql
输出是:
>> 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
但是在appname / data / sql /下生成的schema.sql文件为空.
所以这个命令$php symfony doctrine:insert-sql,没有在我的DB中生成任何表.但是它给出了一个成功的消息输出:
>> doctrine creating tables
>> doctrine created tables successfully
命令$php symfony doctrine:build –all,也没用.
知道我可能做错了吗?