Rake clone_schema_to_test -- default time values

Rails
1

Hey everyone,

For a number of my ‘time’ columns, I use a default value of “00:00:00”.
Unfortunately, when trying to clone this db structure to my test
database using “rake clone_schema_to_test”, Ruby substitutes the string
“Sat Jan 01 00:00:00 Eastern Standard Time 2000” (without quotations)
for those default values, which results in a syntax error.

./db/schema.rb:95: syntax error
t.column “duration”, :time, :default => Sat Jan 01 00:00:00 Eastern
Standard Time 2000, :null => false

Anyone know a way around this?

Thanks,
Ben

2

Anyone?

This is particularly annoying, because everytime I run “rake test” it
rebuilds schema.rb with these long date strings – so I can’t test
anything!

  • Ben

Ben W. wrote:

Hey everyone,

For a number of my ‘time’ columns, I use a default value of “00:00:00”.
Unfortunately, when trying to clone this db structure to my test
database using “rake clone_schema_to_test”, Ruby substitutes the string
“Sat Jan 01 00:00:00 Eastern Standard Time 2000” (without quotations)
for those default values, which results in a syntax error.

./db/schema.rb:95: syntax error
t.column “duration”, :time, :default => Sat Jan 01 00:00:00 Eastern
Standard Time 2000, :null => false

Anyone know a way around this?

Thanks,
Ben

3

http://wiki.rubyonrails.org/rails/pages/RakeErrorsAfterUpdatingToRails1.1.x

Looks like there’s no easy solution :frowning: