database tools for CakePHP

Question

I'm a newbie to CakePHP and was wondering if there is any tool that can show my model classes and their relationship in a visual / graphical environment?

Answer 1

I was using an UML tool for a while called poseidon. They apparently had a for pay module that would let you import your PHP classes and it would pull up UML models for them. Disclaimer: I never used that portion of the tool. The UML mapping was cool though.

Answer 2

You could try cakeapp.com, though it works on the table level, and not on the model level.

Answer 3

I usually build my database schema using MySQL workbench.

There are some experimental plug-ins for the latest version that will output the schema files, but I've not had much luck getting them to work.

Answer 4

May I suggest the CAKE Bake utility. The advantage of using Cake is to rapidly develop your application(s) based on the model schema. Once you design the database tables, cake bake will allow you to create all of the CRUD (Create, Read, Update, Delete) pages with all of the relationships included.

Answer 5

I used to use DBDesigner (Windows and Linux only) to visualise my schema. This can be exported to SQL CREATE TABLE statements. Once all my tables had been created I would just use the bake utility, as others have suggested, to scaffold out all the code - it's a great way to learn the framework.

Answer 6

Hi,

Give MySQL Workbench a try.

WB 5.1: - replaced DBDesigner (Data Modeling)

WB 5.2 (in beta): - replaces MySQL Query Browser - replaces MySQL Administrator

And, here are ORM Plugins for Propel, Doctrine, Symfonny, CakePHP: http://forums.mysql.com/read.php?153,208229

• MySQL Workbench

Answer 7

You can also try ORM Designer, which is ERD tool with a support for CakePHP model attributes. You can create the whole model visually with all model attributes and than export the model to php files with generated classes. orm-designer.com/cakephp.