Rails—count of all records in db?

Question

I have a very snowballing program that creates a whole heap of records (from different models).

I want to delete the main record, and make sure all the other records associated have also been deleted.

Is there a way to simply count all records in my DB, regardless of what table? Then I can create everything, trigger the main delete, then check if there's anything left in the DB.

Mori · Accepted Answer · 2017-06-13 01:25:42Z

4

Rails.application.eager_load!
ActiveRecord::Base.subclasses.sum(&:count)

edited Jun 13, 2017 at 1:25

answered Jun 13, 2017 at 1:20

Mori

27.8k10 gold badges71 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

tadman Over a year ago

As a note on large databases with a lot of active writes this can take a consderable amount of time.

Mirror318 Over a year ago

Tried this, the second line only returned: [ApplicationRecord(abstract), ActiveRecord::SchemaMigration(version: string)]

Mori Over a year ago

@Mirror318, it sounds like you have a non-default subclass between ActiveRecord::Base and your models, e.g. class MyBase < ActiveRecord::Base. Find that subclass and call MyBase.subclasses.sum(&:count).

Mirror318 Over a year ago

Oh right, I had a base class called ApplicationRecord, so this worked: ApplicationRecord.subclasses.sum(&:count)

Collectives™ on Stack Overflow

Rails—count of all records in db?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related