Projects

enforce-schema-rules

This rails plugin provides a way to validate your model against databse rules you've already created in your schema, including column lengths for strings, "not null" designations, and ensuring integer input for integer columns.

schema-definition

== Schema Definition A Ruby on Rails plugin for easy migration generation. Based on Auto-Migrations by PJ Hyett pjhyett@gmail.com . == Usage Create a copy of your schema.rb file and name it definition.rb. Now, when you need to change database schema, edit definition.rb file. Then, invoke $ ... [More] ruby/script generate migration It will generate a new migration with all differencies of definition.rb against your current database schema! You can migrate immediately, or add some more tweaks to your migration, or something else. Why is it great? Because you don't need to remember all that syntax like change_column, add_column, etc - you just modify your schema (in file definition.rb). Nice bonus: migrations are automatically named (of course you may override name suggested). == How to install ruby script/plugin install http://schema-definition.googlecode.com/svn/tags/stable/schema-definition == Todo Indices are partially supported at the moment. == Changelog Workaround on views. Thanks to Cyril Boswell. == Legal Found a bug? Email it to me: pavel.vasev@gmail.com Want to add a feature? Implement it and email patch to me! Pavel Vasev pavel.vasev@gmail.com Released under the MIT license (included) p.s. Schema-Definition plugin is hugely based on Auto-Migrations by PJ Hyett pjhyett@gmail.com [Less]

smooth-migration

Smooth Migration PluginThe Smooth Migration plugin allows database migrations to continue running instead of aborting on failure. The rake db:migrate task will fail at the end of the migration instead of in the middle. This helps prevent getting stuck between migrations and needing to comment out ... [More] code to continue migrating. RequirementsRails >= 1.2 InstallationThe traditional way: ruby script/plugin install http://smooth-migration.googlecode.com/svn/trunk/smooth_migration/ Or with piston: piston import http://smooth-migration.googlecode.com/svn/trunk/smooth_migration/ vendor/plugins/smooth_migration ExampleBefore Smooth Migration == CreateSomeTable: migrating ================================================= -- create_table(:users) -> 0.0039s -- add_column(:users, :email, :string) -> 0.0075s -- add_column(:table_does_not_exist, :foo, :string) rake aborted! SQLite3::SQLException: no such table: table_does_not_exist: ALTER TABLE table_does_not_exist ADD 'foo' varchar(255)In this example, the migration created the users table, but then failed when attempting to add a column to a table that does not exist. One problem is that your database is still on the previous schema version, so the next time you try to migrate, it will fail on creating the users table. After Smooth Migration == CreateSomeTable: migrating ================================================= -- create_table(:users) -> 0.0042s -- add_column(:users, :email, :string) -> 0.3769s -- add_column(:table_does_not_exist, :foo, :string) -> ActiveRecord::StatementInvalid -> SQLite3::SQLException: no such table: table_does_not_exist: ALTER TABLE table_does_not_exist ADD 'foo' varchar(255) -- add_column(:users, :bar, :string) -> 0.0081s == CreateSomeTable: migrated (0.3910s) ======================================== rake aborted! -- 1 Failures! Review console output.The exception messages are displayed inline and the migration continues. At the end of the migration an exception is thrown to abort the rake task and a failure notice is displayed. UsageYour migrations will become smooth after installing the plugin. If you want to migrate the old way, use: rake db:migrate SMOOTH=false Or, in your environment configuration file: SmoothMigration.disabled = trueCopyright (c) 2007 Dan Manges, released under the MIT license. [Less]

uuid-schema-dumper

If you use UUIDs or GUIDs for column IDs in your Ruby on Rails application, you might have noticed that your tests always fail. It's because the schema dumper used to build the schema.rb file that the test framework in turn uses to build your test database, doesn't understand non-integer id ... [More] columns. This plugin will do the trick and get you back on your feet with tests. [Less]

DotNetMigrations

Ruby on Rails "Migrations" ported to .NET Migrations are a way to define your database schema in such a way that it is easy to: * put into source control (know which schema changes relate to which code changes) * share between developers * rollback or upgrade to any version of t