Add 'number of domains' column to Adlist group management

yubiuser · February 10, 2021, 5:32am

At the moment you see the number of domains if you run a gravity update (pihole -g) or via the web interface. But likely there will be more information in the webinterface in the future:

https://github.com/pi-hole/AdminLTE/pull/1673

github.com/pi-hole/pi-hole

Store gravity details in gravity.db adlist table

development ← new/gravity_adlist_infos

opened 07:10AM - 28 Dec 20 UTC

DL6ER

+117 -10

**By submitting this pull request, I confirm the following:** - [X] I have r…ead and understood the [contributors guide](https://github.com/pi-hole/pi-hole/blob/master/CONTRIBUTING.md), as well as this entire template. - [X] I have made only one major change in my proposed changes. - [X] I have commented my proposed changes within the code. - [X] I have tested my proposed changes, and have included unit tests where possible. - [X] I am willing to help maintain this change if there are issues with it later. - [X] I give this submission freely and claim no ownership. - [X] It is compatible with the [EUPL 1.2 license](https://opensource.org/licenses/EUPL-1.1) - [X] I have squashed any insignificant commits. ([`git rebase`](http://gitready.com/advanced/2009/02/10/squashing-commits-with-rebase.html)) --- **What does this PR aim to accomplish?:** Store more gravity details in gravity.db adlist table for user display on the web interface **How does this PR accomplish the above?:** Store status of downloaded list (downloaded, using cache, some error,…) and number of (in-)valid domains on this list in the gravity database. This updates the gravity database to version 14. **What documentation changes (if any) are needed to support this PR?:** Gravity database schema changes, this needs to be accounted for in https://docs.pi-hole.net/database/gravity/groups/ in a follow-up PR.