Deleting all records in a database table

Question

How do I delete all records in one of my database tables in a Ruby on Rails app

User · Answer

if you want to completely empty the database and not just delete a model or models attached to it you can do   rake db purge   you can also do it on the test database  rake db test purge

User · Answer

To delete via SQL  Item delete all   accepts optional conditions  To delete by calling each model s destroy method  expensive but ensures callbacks are called   Item destroy all   accepts optional conditions  All here

User · Answer

If you are looking for a way to it without SQL you should be able to use delete all    Post delete all   or with a criteria  Post delete all  person id   5 AND  category    Something  OR category    Else      See here for more information   The records are deleted without loading them first which makes it very fast but will break functionality like counter cache that depends on rails code to be executed upon deletion

User · Answer

BlogPost find each  amp  destroy

User · Answer

If you mean delete every instance of all models  I would use  ActiveRecord  Base connection tables map  amp  classify     map  name  name constantize if Object const defined  name      compact each  amp  delete all

User · Answer

More recent answer in the case you want to delete every entries in every tables   def reset     Rails application eager load      ActiveRecord  Base descendants each    c  c delete all unless c    ActiveRecord  SchemaMigration    end   More information about the eager load here   After calling it  we can access to all of the descendants of ActiveRecord  Base and we can apply a delete all on all the models   Note that we make sure not to clear the SchemaMigration table

User · Answer

If your model is called BlogPost  it would be   BlogPost all map  amp  destroy

[ruby-on-rails] Deleting all records in a database table

Examples related to ruby-on-rails

Examples related to ruby

Examples related to database

Examples related to ruby-on-rails-3