Skip to content

Instantly share code, notes, and snippets.

@jnettome

jnettome/clean.rb

Created August 23, 2013 19:40
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jnettome/6323172 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jnettome/6323172 to your computer and use it in GitHub Desktop.
Download ZIP
DatabaseCleaner SQL Server
Raw
clean.rb
ActiveRecord::Base.connection.execute "EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable '
IF OBJECTPROPERTY(object_id(''?''), ''TableHasForeignRef'') = 1
DELETE FROM ?
else
TRUNCATE TABLE ?
'
EXEC sp_MSForEachTable 'DROP TABLE ?'
-- Now enable referential integrity again
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment