Scott Taylor wrote:
>
> On Sep 20, 2008, at 7:18 PM, Ben Mabey wrote:
>
>> Todd Tyree wrote:
>>> Ok, here's what I've come up with on the spur of the moment (goes in
>>> spec_helper.rb):
>>>
>>> config.after(:each) do
>>> result = ActiveRecord::Base.connection.execute('SHOW TABLES;')
>>> while table = result.fetch_row
>>> # Or whatever you think is appropriate.
>>> next if table.index('schema_migrations') or table.index('roles')
>>> ActiveRecord::Base.connection.execute("TRUNCATE #{table}")
>>> end
>>> end
>>>
>>
>> I've used a similar method before.. However, your 'SHOW TABLES' and next
>> is not needed:
>>
>>
>> (ActiveRecord::Base.connection.tables - %w{schema_migrations}).each do
>> |table_name|
>
> Yeah, that's just a cleaner way of doing it - I'm sure if you tailed
> your logs you'd find a 'SHOW TABLES'
>
Yeah, depending on the rails environment it probably and caching it
probably would.
>>
>> ActiveRecord::Base.connection.execute("TRUNCATE TABLE #{table_name};")
>
> Seems like you might also want to add a truncate_table method onto
> ActiveRecord::Base.
Yeah, I tend to ussually add this to my projects as well:
class ActiveRecord::Base
class << self
def truncate
self.connection.execute("TRUNCATE TABLE #{table_name};")
end
end
end
>
>>
>> end
>>
>>
>> Also, to address Pat's statement about FKs... if ordering the truncates
>> is too cumbersome you could just turn off the FK checks:
>>
>> ActiveRecord::Base.connection.execute("SET FOREIGN_KEY_CHECKS = 0;")
>> (ActiveRecord::Base.connection.tables - %w{schema_migrations}).each do
>> |table_name|
>> ActiveRecord::Base.connection.execute("TRUNCATE TABLE #{table_name};")
>> end
>> ActiveRecord::Base.connection.execute("SET FOREIGN_KEY_CHECKS = 1;")
>>
>
> Nice.
>
> Scott
>
> _______________________________________________
> rspec-users mailing list
> rspec-users@rubyforge.org
> http://rubyforge.org/mailman/listinfo/rspec-users
_______________________________________________
rspec-users mailing list
rspec-users@rubyforge.org
http://rubyforge.org/mailman/listinfo/rspec-users
