Create a data validator module - Githubissues

katefike / sage

A personal finance app that's like Mint, but better. It uses a dockerized postfix/dovecot email server. Parses transaction data from alert emails.

MIT License

5 stars 0 forks source link

Create a data validator module #143

Closed katefike closed 5 months ago

katefike commented 5 months ago

PROBLEM

How do I know if the data in the db is accurate? If the data looks wrong, how can I quickly diff it against data from the bank?
How do I know duplicate forwards weren't double-counted (Idempotency)?

STEPS

Get an mbox file of emails
Get a transaction export from the bank
Specify the mbox in the .env
Run sage
Validate the data in the db against the bank's transaction export
- count of transactions are the same
- there's a 1:1 match for each transaction in the bank export to the transactions in the DB
- there are no duplicate transactions in the DB

DONE WHEN

In local development, I can provide an mbox file and an export from my bank and get all the validation data ✔️