search

zaratanDotWorld / choreWheel

Computational governance tooling
GNU Affero General Public License v3.0
9 stars 1 forks source link

Verify chore value calculations #196

Open kronosapiens opened 1 month ago

kronosapiens commented 1 month ago

If you squash a bug that no-one saw, did it even exist?

An evergreen issue for making sure chore value calculations are accurate.

kronosapiens commented 1 month ago

SQL queries

Making sure chore intervals add up to 1 every month. Only need to check 1 chore per house.

SELECT SUM((metadata->>'intervalScalar')::numeric) FROM "ChoreValue" WHERE "choreId" = 40 AND "valuedAt" >= '2024-07-01' AND "valuedAt" < '2024-08-01';