Monitoring: Negative balance DB

[tomsmith8]

Task

• Find all workspaces with negative balance
• Nullify
• Add function that checks balances in table for withdraw > deposit

SQL qeury:

[tomsmith8]

Stub: Monitoring where withdraw > deposits balance

[fvalentiner]

The SQL command to find workspaces with balances different than the sum of workspace transactions:

select ph.workspace_uuid, w.name, SUM(case when payment_type = 'withdraw' THEN amount -1 ELSE amount END) as amount, bb.total_budget, MAX(ph.updated) as last_transaction, MIN(ph.updated) as first_transaction from payment_histories as ph inner join workspaces as w on w.uuid = ph.workspace_uuid inner join bounty_budgets as bb on bb.workspace_uuid = ph.workspace_uuid WHERE status = true GROUP BY ph.workspace_uuid, w.name, bb.total_budget HAVING SUM(case when payment_type = 'withdraw' THEN amount -1 ELSE amount END) <> total_budget ORDER by amount DESC