Bug 34587: Remove counter files from API embedding to improve performance
authorMatt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Tue, 19 Sep 2023 12:07:55 +0000 (12:07 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Tue, 31 Oct 2023 19:46:21 +0000 (16:46 -0300)
commit979ff589d9c617ceade865797e6cbc5005c6f0f5
tree57b257418e4ef751d2fe8da1669a5b67cdc14d4c
parent040f6ef1935caf94d3fc1b372a6faf022d683018
Bug 34587: Remove counter files from API embedding to improve performance

Rather than fetching the counter files and embedding the counter logs, we now add a foreign key to the data provider in the counter logs table and fetch them directly.

Signed-off-by: Jessica Zairo <jzairo@bywatersolutions.com>
Signed-off-by: Michaela Sieber <michaela.sieber@kit.edu>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
13 files changed:
Koha/ERM/EUsage/CounterFile.pm
Koha/REST/V1/ERM/EUsage/CounterLogs.pm [new file with mode: 0644]
Koha/REST/V1/ERM/EUsage/UsageDataProviders.pm
Koha/Schema/Result/ErmCounterLog.pm
Koha/Schema/Result/ErmUsageDataProvider.pm
api/v1/swagger/definitions/erm_counter_log.yaml
api/v1/swagger/definitions/erm_usage_data_provider.yaml
api/v1/swagger/paths/erm_counter_logs.yaml [new file with mode: 0644]
api/v1/swagger/swagger.yaml
installer/data/mysql/atomicupdate/erm_usage_statistics_tables.pl
installer/data/mysql/kohastructure.sql
koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/UsageStatisticsDataProvidersCounterLogs.vue
koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/UsageStatisticsDataProvidersList.vue