I don't have access to oracle setup at this time, and it's hard to tell what the problem might be without specific info about your setup .... but, since you mentioned schema.rb in your op, I'm wondering if by chance you forgot to re-run your tests after mod'ing environment.rb to use sql (which results the dumping of db/ development_structure.sql) instead of AR's schema dumper (which results in dumping of db/schema.rb)?
Assuming you did mod db/environment.rb accordingly, and you saved your oracle-specific constraints defined in the approp place(s) in your migrations files (and successfully re-migrated and confirmed that those constraints are in effect in your dev db?), try the following: $ rm db/development_structure.sql $ rake test:units ... $ cat db/development_structure.sql ... and see if those constraints don't show up in db/ development_structure.sql then. If they don't, another longshot thought is .... are you running an old version of rails, ie 1.x? Because iirc I used to have to do some extra fiddling to get such migrations-defined constraints to apply to test db under rails 1.x. No longer needed under rails 2.x tho. If still having problems, maybe post your specific config/setup and code? Jeff On Feb 18, 1:23 pm, Greg Donald <gdon...@gmail.com> wrote: > On Wed, Feb 18, 2009 at 2:03 PM, Jeff Lewis <jeff.bu...@gmail.com> wrote: > > Then, after migrating, that constraint should show up in db/ > > development_structure.sql, which your tests will then use when re- > > creating test db: > > > ... > > CREATE TABLE `books` ( > > ... > > CONSTRAINT `fk_book_author` FOREIGN KEY (`author_id`) REFERENCES > > `authors` (`id`) ON DELETE CASCADE > > Right, that's what I'm saying. This does not occur for Oracle. > > The development_structure.sql I get is CONSTRAINT-less. > > -- > Greg Donaldhttp://destiney.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
