structure_drop creating, but not executing, sql to drop schema

[svesely]

I was having issues where rake db:drop wouldn't actually drop either table or sequence, so I dug into the code to find where oracle-enhanced was dropping these items.

I found structure_drop, which seems to fit my needs exactly. However, when I run:
ActiveRecord::Base.connection.structure_drop

I'm getting back the SQL to drop all the tables, returned as a long string, but it's not actually executed. When I run that SQL through sqlplus, it does seem to be valid, and the tables/sequences are dropped.

I feel like I must be missing something very simple, but I'm executing that ruby statement under the same user/pass as the sqlplus, and getting different results.

I've tried this with both 1.8.7p299 and 1.9.1p378 using ActiveRecord 3.0.0beta4 and activerecord-oracle_enhanced-adapter version 1.3.0

Thoughts?

[rsim]

Currently I have not yet implemented rake db:drop and db:create tasks.

If you need to empty test schema then you can use "rake db:test:purge".
If you need to empty other environment schema then you can take a look at http://github.com/rsim/oracle-enhanced/blob/master/lib/active_record/connection_adapters/oracle_enhanced.rake#L43-51 and implement similar task which would establish connection to specified environment (and not hardcoded test environment).

[svesely]

I forked and added the rake task, as well as an option to specify a default sequence suffix (I'm working with someone who's VERY particular about sql naming). Neither of these are covered with tests yet, as I'm not the DBA here so it's non-trivial to get a testing schema, but as soon as I get them covered I'll send you a pull request if you're interested.

Thank you for providing such an excellent plugin- this really does carry a large portion of the "making Rails enterprise-friendly" burden.

--Scott