[Closed] timestamp mysql

0 votes
asked Aug 25, 2015 in Solved by msellers (120 points)
recategorized Oct 12, 2015 by ludek.vodicka
commented Aug 25, 2015 by ludek.vodicka Skipper developer (140,450 points)

Hi, can you be please more specific what do you mean by this?

commented Aug 25, 2015 by msellers (120 points)

Sorry. I am new to this forum and accidentally hit the wrong button.

I am using Doctrine 2 with Symfony 2 to create a new app that integrates with an existing database. This database has the mysql timestamp for typical created and updated fields. As you may know, the timestamp fields in mysql are basically integers that reflect the number of seconds from a particular date. The database automatically inserts the timestamp when a field is created or updated. From the application perspective, these are read-only integers.

What is the best way to map this in the Skipper tool?

1 Answer

0 votes
answered Aug 25, 2015 by ludek.vodicka Skipper developer (140,450 points)

No problem ;-)

Because Mysql is "hidden" by Doctrine ORM there is no need to do something special for mysql via Skipper.

You can define your model in Skipper in the exact way like you're defining it manually in the schema files (xml / yml / annotations).

I suppose that you should define it as timestamp type and Doctrine2 handles value storage for you.

...