Download Plugin (zip)

Stats

Version

0.9

Wheels Compatibility

1.1.6, 1.1.5, 1.1.4, 1.1.3, 1.1, 1.1 RC 1, 1.0.5, 1.0.4, 1.0.3, 1.0.2, 1.0.1, 1.0

Downloads

542

Last Updated

November 28, 2011

About Plugins

Plugins allow you to extend or modify default Wheels application behavior. To use, you just drop the zip file into your plugins directory and reload your application.

Read Using and Creating Plugins for more information.

DBMigrate

This plugin adds Database Migration functionality to CFWheels similar to Rails' Active Record migrations.

Author

Ryan Hoppitt

Project Home

https://github.com/talltroym/cfwheels-dbmigrate-plugin

Description

Migrations are an easy way to build and alter your database structure using cfscript. They allow your database structure to be version controlled along with the rest of your application environment and make deployment and working with databases in a team environment much easier.

Credits

Thanks to Raúl Reira, Chris Peters and Tom Hoen for contributing code to this plugin.

From version 0.7.2 the development of the project has been taken over by Troy Murray.

Original project home can still be found at: http://code.google.com/p/cfwheels-dbmigrate/

Usage/Examples

View the project wiki for usage, examples and tutorial.

Documentation for previous versions can still be found at the old Google Code site - Click here.

Change Log

Version 0.9—November 28, 2011 Download

  • Fixed: Simple syntax error in Migration.cfc was causing the createObjectFromRoot to throw an exception. Fixed syntax error and migrations work again.
  • Fixed: String values with more then one single quote aren't being escaped in generated SQL
  • Wheels compatibility: 1.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.1, 1.1 RC 1, 1.1.3, 1.1.4, 1.1.5, 1.1.6.

Version 0.8.2—November 6, 2011 Download

  • updateRecord bug fix
  • Wheels compatibility: 1.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.1, 1.1 RC 1, 1.1.3, 1.1.4, 1.1.5, 1.1.6.

Version 0.8.1—November 2, 2011 Download

  • Bug fix
  • Wheels Compatibility upgrade to 1.1.6
  • Wheels compatibility: 1.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.1, 1.1 RC 1, 1.1.3, 1.1.4, 1.1.5, 1.1.6.

Version 0.8.0—September 21, 2011 Download

  • Add Oracle code specific block to basefunctions.cfm - code changes from Raúl Riera
  • Add transaction wrapping in dbmigrate.cfc - code changes from Raúl Riera
  • Add foreign key column removal when dropping a table in migration.cfc - code changes from Raúl Riera
  • Add ability to trigger migrations by calling plugin from URL with migrateToVersion URL parameter
  • DBMigrate automatically determines correct path for Extends in migration files
  • Add plugin version number to plugin page
  • Resolve issue #6 when using renameColumn() with MySQL
  • Wheels compatibility: 1.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.1, 1.1 RC 1, 1.1.3, 1.1.4, 1.1.5.

Version 0.7.2—September 13, 2011 Download

  • MySQL fixes
  • Additional templates
  • Updated plugin compatibility
  • Wheels compatibility: 1.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.1, 1.1 RC 1, 1.1.3, 1.1.4, 1.1.5.

Version 0.6—October 28, 2010 Download

  • SQLite support provided by Raúl
  • Patches supplied by Raúl and Chris
  • Setting default to null for empty string on non-string columns and some other bug fixes.
  • Wheels compatibility: 1.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.1 RC 1.

Version 0.3—January 6, 2010 Download

  • Fixed migration version tracking so you can run all non-migrated versions
  • SQL Server and Oracle adapter updates
  • Access to Wheels model() function within migrations
  • Wheels compatibility: 1.0.

Version 0.2—January 5, 2010 Download

  • Added functionality to plugin page to create migrations from templates
  • Wheels compatibility: 1.0.

Version 0.1—January 4, 2010 Download

  • Initial release for feedback and suggestions
  • Tested with ColdFusion8 and MySQL (working on other databases)
  • Wheels compatibility: 1.0.