A Weblog written, styled and hacked by Joel Moss
CakePHP DB Migrations v4.0 is now Stable
7Oct2008 Filed under: DB Migrations Author: JoelAfter months and months of delays due to work constraints, and other crap, I decided that I needed to get my head down and release v4.0 of CakePHP DB Migrations. So that is exactly what I just did!
v4.0 is now available in all its glory at the Google Code repo at http://code.google.com/p/cakephp-migrations so get it while it is hot.
You can download it here.
I plan on creating a new screencast soon(ish), that will include all the updated features and shortcuts, and will also be easier to hear me and will hopefully be a little shorter and concise. But until then, please play around and let me know if you have any questions at all.
Here’s the changes taken directly from the changelog:
[*] errr… lots of fixes
[*] Fixed bug with old style version numbers
[*] Fixed bug where fkeys were trying to be created with auto_increment
[+] Can now specify whether to use Cake’s UUID for the ID column within migration files. Example: “id: uuid”
[+] Can now pass “id: false” within migration file, and no ID column will be created.
[-] Deprecated “no_id: true” in favour of “id: false”
[*] ID column is now correctly set as Primary Key when using UUID type.
[+] Added support for MySQL specific table options (comments, engine/type, collate and charset)
[+] Version numbers now use timestamps so as to minimize conflicts
[+] Now supports interleaved migrations;
when migrating up, will run migrations that have not yet been run, and will ignore any non-run migrations when running down.
[+] Added info option (cake migrate info), which shows information on migrations
[+] Can now specify version number when running up/down, thus allowing you to only run the up/down block of a specific migration
[+] Schema table name is now customizable
[+] Now supports PHP arrays in migration files
I hope to write more about these when I don’t have so much decorating on the house to do.
9 Responses to “CakePHP DB Migrations v4.0 is now Stable”
Leave a reply
Who is Developing with Style?
My name is Joel Moss, a web developer and all round nice guy, living in Manchester, England. I am currently working full time for ShermansTravel.com, but I fill whatever spare time I have with lots of good and wholesome "stuff"! Like developing my own ideas; such as Tooum, contributing to the excellent CakePHP framework, and doing more work for ShermansTravel.
So this is my blog - my soap box! Here I attempt to share my likes, my dislikes, and my opinions. As well as providing some occasional respite from the daily crap we all endure. Enjoy ;)
Hey, if you want to reach me, i'm available via email:joel[at]developwithstyle[dot]com, and AIM:joelkmoss.
Funky Weasel
October 10th, 2008 at 2:30 pm
I noticed that running the new stable version throws: “Notice: Uninitialized string offset:” for lines 839,844,849,855, three times in the same sequence on an existing YAML script.
Also - I’ve had trouble trying to set default values of fields - currently I can either have fields default to NULL or 1, the latter with:
UP:create_table:
requests:
some_text:
- not_null
some_flag:
type: boolean
- default: 0
Omitting the dash before ‘default’ causes no default to be set. The only way I have found round this so far is to explicity define a field in a migration script using an ‘alter table’ statement.
Joel
October 16th, 2008 at 12:48 am
Please open up a ticket at http://code.google.com/p/cakephp-migrations/issues/list about the first issue, and be sure to include the YAML you are running.
As for the second issue, a better way to write your migrations is as follows:
UP:
create_table:
requests:
some_text: not_null
some_flag: bool
Antoine
October 21st, 2008 at 7:12 pm
Hi,
Just wondering, are you still maintaining your Fixtures project ? Found a little bug on my side.
Had to change on line #178
$data = Spyc::YAMLDump($this->_parsePhp($file));
to :
$data = Spyc::YAMLLoad($this->_parsePhp($file));
Joel
October 22nd, 2008 at 12:48 pm
Yes I am, because I use it. Think I fixed that in 4.0 stable.
Antoine
October 24th, 2008 at 2:09 pm
I got this error from the stable version downloaded on monday from Google Code.
Thanks for this great shell, really really enjoying it. No more mysql dump importations.
Joel
October 26th, 2008 at 11:01 am
Please go ahead and open up a ticket. Thx.
Daniel Vecchiato
October 29th, 2008 at 8:41 am
great job Joel!
I’ll test it out!
Yammy!
;o)
Dan
Alan Whitney
October 29th, 2008 at 2:42 pm
This looks very good. I tried it out a bit and I have a question, does it work with UUID’s instead of int primary keys.
Alan Whitney
October 29th, 2008 at 2:49 pm
My bad, I see yes it is in version 4