timestamp db type (postgresql) about admingeneratorgeneratorbundle

[cedriclombardot]

Please set 4 ` to make a pre block your question would be easiest to read.

timestampseems not be a good type http://www.doctrine-project.org/docs/orm/2.0/en/reference/basic-mapping.html, you've to use datetime

datetime: Type that maps an SQL DATETIME/TIMESTAMP to a PHP DateTime object.

[suncat2000]

I am read this part of doctrine doc, but i need use PostgreSQL, in which no 'datetime' type.
Use of 2 fields: 'date' and 'time'? Not gracefully...
Especially if the entity has:

• creation date
• date of change
• date start of activity
• date end of activity

[cedriclombardot]

I don t know how doctrine will store your timestamp type but you can overwrite the dbType option for the field telling at the admingenerator thats a datetime. If you find a documentation or code about doctrine and timestamp i could include this field into the guesser to determine it automatically

[suncat2000]

New experiment:
From My.orm.yml:

...
fields:
    is_published:
        type: boolean
    date_create:
        type: datetime
    date_change:
        type: datetime
...

Create entity and update schema. In db fields (date_create, date_change) 'timestamp' type.
After fixtures:load in this fields i have strings in format: 2011-09-27 00:10:10.

When trying to display a list of entities that get the exception:

An exception has been thrown during the rendering of a template ("Catchable Fatal Error: Object of class DateTime could not be converted to string in ../app/cache/dev/twig/7c/bf/b46427bd1f75816d1dedbe6c2164.php line 336") in "Admingenerated/AdminTextBundle/Resources/views/TextList/index.html.twig" at line 136.

It string (136):

{% block list_td_column_date_create %}{{ Text.dateCreate }}{% endblock %}

[cedriclombardot]

I'll try this but i think thats because the list haven't recognize the type "date" and fallback to default

[cedriclombardot]

Ok should work now

[suncat2000]

Its work, thanks