Generate Database Tables from Models

Question

Generate Database Tables from Models

wamd-bozem Jul '13

Created Jul '13	Last Reply Mar '15	Replies 2	Views 4995	Votes 2

wamd-bozem 4.9k

Jul '13

I know it's possible to auto-generate .php files for models by creating tables in the database first. Is it also possible to do it the other way around? So that I can create a model.php file and update my database accordingly so that it creates the table for the model together with its columns?

This works, for example, in doctrine, where you define your models metadata (in a .yml file for example) and then it creates the necessary SQL statements to update the database.

2

jeffreycahyono · Answer 1 · 2013-08-01T07:17:32-07:00

jeffreycahyono
27.7k

Aug '13

Yes you can https://docs.phalcon.io/en/latest/reference/tools.html#generating-models

wamd-bozem · Answer 2 · 2013-08-01T14:47:48-07:00

Could you please explain exactly how I do this? I've read that page and watched the video but I can't figure out how to do it. How do I declare which Columns my Table should have and which type they are etc. ?

Pablo Moreno · Answer 3 · 2015-03-10T01:30:33-07:00

Long time ago since this discussion started, I'm looking after the same functionality. I have written some models and I want to replicate its structure to my database. Is it possible?