Test Database fails to initialize

rubyonrails-talk
1

Hi, yes, I'm still using rails 1.2.6, as I haven't made the time to migrate.

when I try to do run tests using rake, it fails to initialize the database correctly..

I create the database using migrations, and I wanted to index a text field in mysql. The default add_index command does not handle adding the index correctly, as mysql requires a length for indexing a test field, for how much of the text field to index.

so, in my migration I have a

Model.connection.execute('CREATE INDEX index_name ON table_name ( field1, field2, text_field(20) )')

however, rails records that in the schema.rb as

add_index "table", ["field1","field2","text_field"], :name => "index_name"

which fails.

I don't want to eliminate the index, as it gives me a considerable speed increase when looking for an exact match in the text_field..

Ideas?

2

Switch from using the ruby schema dumper to the sql one (it's an option in environment.rb)

3

Yay, that worked, thanks..

just for the record, I added in

Rails::Initializer.run do |config|   ... stuff that was already there ...   config.active_record.schema_format = :sql end