Databases
StackOverflow2013
Postsdbo
POGood DB Migrations for CakePHP?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGood DB Migrations for CakePHP?
    primarykey
    data
    text
    <p>I have been trying a few migration scripts for CakePHP but I ran into problems with all of the in some form or another.</p> <p>Please advice me on a migration option for Cake that you use live and know works.</p> <p>I'd like the following "features":</p> <ul> <li>Support CakePHP 1.2 (e.g. CakeDCs migrations will only be an option when 1.3 is stable and my app migrated to the new codebase)</li> <li>Support for (or at least not halt on) Models with a different database config.</li> <li>Support Models in sub-folders of app/models</li> <li>Support Models in plugins</li> <li>Support tables that do not conform to Cake conventions (I have a few special tables that do not have a single primary key field and need to keep them)</li> <li>Plays well with automated deployment via Capistrano and Git.</li> </ul> <p>I do not need rails-style versioned files a git versioned schema file that is compared live to the existing schema will do. That is: I like the SchemaShell in Cake apart from it not being compatible with most of my requirements above.</p> <p>I have looked at and tested:</p> <ul> <li>CakePHP Schema Shell <a href="http://book.cakephp.org/view/734/Schema-management-and-migrations" rel="noreferrer">http://book.cakephp.org/view/734/Schema-management-and-migrations</a></li> <li>CakeDC migrations <a href="http://cakedc.com/downloads/view/cakephp_migrations_plugin" rel="noreferrer">http://cakedc.com/downloads/view/cakephp_migrations_plugin</a></li> <li>YAML migrations <a href="http://github.com/georgious/cakephp-yaml-migrations-and-fixtures" rel="noreferrer">http://github.com/georgious/cakephp-yaml-migrations-and-fixtures</a></li> <li>joelmoss migrations <a href="http://code.google.com/p/cakephp-migrations" rel="noreferrer">http://code.google.com/p/cakephp-migrations</a></li> </ul>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USÁlvaro González
    1. USMartin Westin
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POGood DB Migrations for CakePHP?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POGood DB Migrations for CakePHP?
      1. USDaniel Wright
      1. VTFavorite
    3. VO
      singulars
      1. POGood DB Migrations for CakePHP?
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1, interesting question
      singulars
      1. POGood DB Migrations for CakePHP?
      1. USDaniel Wright
    2. COBy ignoring the documentation and reading the source I have discovered how to make the Schema Shell do pretty much all I need. I found out that -f does not "force 'generate' to create a new schema.". It is used "To force generation of all tables into the schema...". But not only that, and this is not in the docs: It can also be used to force update to ignore the Model classes in the same way as generate and therefore update a schema generated using the option.
      singulars
      1. POGood DB Migrations for CakePHP?
      1. USMartin Westin
    3. CO@Matin Westin -- why not contribute those insights to the documentation wiki?
      singulars
      1. POGood DB Migrations for CakePHP?
      1. USstevenf
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload