Skip to content

Instantly share code, notes, and snippets.

@romanlehnert
Created September 17, 2013 15:54
Show Gist options
  • Save romanlehnert/6596324 to your computer and use it in GitHub Desktop.
Save romanlehnert/6596324 to your computer and use it in GitHub Desktop.
Truncate all tables in rails
ActiveRecord::Base.establish_connection
ActiveRecord::Base.connection.tables.each do |table|
next if table == 'schema_migrations'
case ActiveRecord::Base.connection.adapter_name.downcase.to_sym
when :mysql2 || :postgresql
ActiveRecord::Base.connection.execute("TRUNCATE #{table}")
when :sqlite
ActiveRecord::Base.connection.execute("DELETE FROM #{table}")
end
end
@ugifractal
Copy link

thanks. working nicely :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment