Database Usage Report

The feature was to create a way to keep track and report database usage. While working on this feature I also moved the ip_location to a separate service and corrected some comments in the public controllers.

New or Modified Files

app/assets/javascripts/interface.js
app/assets/javascripts/plugins/stat_csv_export.js
app/assets/stylesheets/interface/elements/_filter.scss
app/controllers/admin/link_tracking_controller.rb
app/controllers/admin/statistics_controller.rb
app/controllers/public/base_controller.rb
app/controllers/public/connect_controller.rb
app/controllers/public/search_controller.rb
app/models/database.rb
app/models/link_tracking.rb
app/services/ip_location_service.rb
app/services/statistics/base.rb
app/services/statistics/csv.rb
app/views/admin/_navigation.html.erb
config/routes.rb
config/locales/en.yml
app/views/admin/link_tracking/index.html.erb
db/seeds.rb
db/migrate/20210218183646_create_link_trackings.rb
db/schema.rb
spec/controllers/admin/admin_statistics_controller_spec.rb
spec/factories/link_tracking.rb
spec/features/admin/admin_link_tracking_spec.rb
spec/models/database_spec.rb
spec/models/link_tracking_spec.rb
spec/services/statistics/statistics_base_spec.rb

Description

Requested feature was to be able to keep track of databases usage and be able to export data based on date range to csv files.

Motivation and Context

The feature request was to have a way to track usage for the various databases and be able to export that information into csv files. This information would be used to determine what databases were being used and would allow us to determine what databases to continue subscribing to.

How Has This Been Tested?

New features have been tested through Rspec and Manual testing.

wvulibraries / databases