Creating tables using Doctrine in Symfony

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?

Answers


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.


Need Your Help

Pure CSS Dropdown Menu

javascript php css drop-down-menu yui-pure-css

I have been working on facebook application and you know on facebook native javascript is not allowed, they have their own implementation FBJS which is troublesome when it comes to creating stuff l...

Subquery for same column but separate values?

sql ms-access subquery

All right, I don't know how to ask this, so I'll just post the query and see if someone can help make it work.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.