Mysql utils for migrations and stored procedures.
Replaces the db:test:prepare with a mysqldump sequence which attempts to safely duplicate triggers and store procedures.
Provides a includable module ActiverecordStoredprocedure which provides a find_by_procedure ActiveRecord method for calling stored procedures from models as well as handling and mapping MySQL signals to ruby exceptions.
Provides rake tasks for converting multi-statement SQL files into rails database migrations.
Add this line to your application's Gemfile:
And then execute:
Or install it yourself as:
$ gem install mytrilogy
class MyRecord < ActiveRecord::Base include ActiverecordStoredprocedure end # The columns returned from 'name_of_procedure' become the columns of the # MyRecord instance. MyRecord.find_by_procedure(:name_of_procedure, 'param1', 'param2') # Uses ActiveRecord '?' to replace parameter values with SQL type safe values # To execute without result set MyRecord.call_procedure(:name_of_procedure, 'param1', 'param2')
MySQL procedures can signal errors in a format that triggers familiar ruby exceptions. Example:
SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = '#ActiveRecord::RecordNotFound# Unable to find or create MyRecord';
The ActiverecordStoredprocedure will convert and raise classes named between to hash '#' symbols.
Prepare a test database with triggers and more:
$ rake db:test:prepare
Convert multi-statement sql file to a migration file:
$ rake db:mysql:sql2rb IN=/tmp/somefile.sql OUT=db/migrate/20130319210111_some_sql.rb
Convert a dump of the current database environment to a migration file:
$ rake db:mysql:dump2rb OUT=db/migrate/20130214210111_copy_schema.rb
Convert potentially updated db:migrate_sql output back to a ruby migration
$ rake db:mysql:migrate_sql2rb
- Fork it
- Create your feature branch (
git checkout -b my-new-feature)
- Commit your changes (
git commit -am 'Add some feature')
- Push to the branch (
git push origin my-new-feature)
- Create new Pull Request