Add a set of named pipes for your Koha instances that output useful information
This role works for the Debian package version of Koha
Define in number of pipes to be created in under the 'queries' variable, which is a list of hashes. Each element in the queries list should have a name and sql key, the description is for humans only and is not used by Ansible for anything.
queries:
- name: bibcount
description: Outputs the number of marc records in the database
sql: "SELECT COUNT(*) FROM biblio"
- name: patroncount
description: Outputs the number of patrons in the database
sql: "SELECT COUNT(*) FROM borrowers"
Once installed, when you run
cat /var/lib/koha/<instance>/dashboard/bibcount
you'll see
+----------+
| count(*) |
+----------+
| 12 |
+----------+
This role has no dependencies on other Ansible roles
- hosts: all
roles:
- koha-dashboard
CC-BY
Kyle M Hall, ByWater Solutions http://kylehall.info http://bywatersolutions.com