This gem allows you to keep a "footprint" of the sql queries that your application runs. It's like logging all the sql you're executing except that we remove all the value parameters and dedupe similar queries. This footprint should be valuable in determining if changes you've made will significantly change the way you're querying the database.
Add this line to your application's Gemfile:
gem 'sql_footprint', group: [:development, :test]And then execute:
$ bundle
Typically, you would want to run this while you're running your specs. For example w/ RSpec:
RSpec.configure do |config|
config.before(:suite) { SqlFootprint.start }
config.after(:suite) { SqlFootprint.stop }
endMinitest (in test_helper.rb) add the following:
SqlFootprint.start
Minitest.after_run { SqlFootprint.stop }You can also add a Custom rule to SqlAnonymizer before running start:
RSpec.configure do |config|
SqlFootprint::SqlAnonymizer.add_rule(/SELECT (.+) AS (.+)/, 'SELECT [redacted] AS [redacted]')
config.before(:suite) { SqlFootprint.start }
config.after(:suite) { SqlFootprint.stop }
endAfter running your specs you'll find a 'footprint.*.sql' file in your project. Footprints are per-database. For example, if you're using DB1 AND DB2 in your app, you would end up with two footprint files. (footprint.db1.sql, footprint.db2.sql)
If you're using an in-memory database, you'll end up with footprint.:memory:.sql.
If you want to exclude queries that your tests generate for fixture data, you can use the .exclude method. For example:
before do
SqlFootprint.exclude do
Model.create!(args*) # this query will not be included in your footprint
end
endOr if you're using FactoryBot you could do something like this:
RSpec.configure do |config|
module FactoryKid
def create(*args)
SqlFootprint.exclude { FactoryBot.create(*args) }
end
end
config.include FactoryKid
end- For Rails < 6.0 compatibility, please use v2.0.1.
- For Rails >= 6.0 compatibility, please use v3.0.0.
- For Rails >= 7.0, please use v3.0.1
DO NOT run SqlFootprint in production!
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent