feat: script to count product contributions by year

[stephanegigandet]

Sample output on the dev test database:

year	active_editors	new_editors	products_edited	products_added	total_products
2012	2	2	1	1	1
2013	5	4	3	2	3
2014	6	4	3	2	5
2015	7	3	6	5	10
2016	6	4	5	3	13
2017	12	7	27	21	34
2018	21	11	55	44	78
2019	26	18	74	40	118
2020	31	17	120	53	171
2021	34	21	92	40	211
2022	36	17	147	67	278
2023	55	30	117	34	312
2024	48	21	96	49	361
all	159	159	361	361	361

Output on the whole database: https://docs.google.com/spreadsheets/d/11nrerWDwzFV1gZb0i16TI_shh9C3XgddYn5KcGl4DO8/edit?gid=0#gid=0

[john-gom]

You are aware that we can do this in off-query now as well, right?

[stephanegigandet]

You are aware that we can do this in off-query now as well, right?

Hi @john-gom , right, we have all the events there now? I need to look into it. Should I just connect to the postgres db directly and query the events table?

[john-gom]

You are aware that we can do this in off-query now as well, right?

Hi @john-gom , right, we have all the events there now? I need to look into it. Should I just connect to the postgres db directly and query the events table?

There is a view called product_updates_by_owner in the views schema. There is a viewer postgres user with a password of off

[sonarcloud]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarQube Cloud