diff options
| author | Joe Carstairs <me@joeac.net> | 2025-07-17 23:15:31 +0100 |
|---|---|---|
| committer | Joe Carstairs <me@joeac.net> | 2025-07-17 23:15:41 +0100 |
| commit | eb5c1e031ee69e4eef68d3054c973ded23dc8e64 (patch) | |
| tree | 33076accf4c5971318b148e482a877a56d5f1e8b /actualbudget_queries | |
| parent | 5a75def2f5e9cd5f3421a908505c59ac074dae74 (diff) | |
applies formatting
Diffstat (limited to 'actualbudget_queries')
| -rw-r--r-- | actualbudget_queries/README.md | 40 | ||||
| -rw-r--r-- | actualbudget_queries/tests/resources/actualbudget_test_db_metadata.json | 8 |
2 files changed, 28 insertions, 20 deletions
diff --git a/actualbudget_queries/README.md b/actualbudget_queries/README.md index 69ab0e7..39df4cf 100644 --- a/actualbudget_queries/README.md +++ b/actualbudget_queries/README.md @@ -16,32 +16,34 @@ To re-create the test database from scratch: 5. Add a new local account, called 'Category transfers', with an initial balance of nil 6. Move the Starting Balance transaction for both to 1 Aug 2024 -6. Go to the Budgets tab -7. Adjust the budgets for the existing categories for August 2024: - - Usual Expenses, under which: - - Food: 200 - - General: 100 - - Bills: 125 - - Bills (flexible): 25 - - Investments and Savings, under which: - - Savings: 400 -8. Add transactions for Income for 846.46 in the 'My bank account' on 21 Aug, +7. Go to the Budgets tab +8. Adjust the budgets for the existing categories for August 2024: + +- Usual Expenses, under which: + - Food: 200 + - General: 100 + - Bills: 125 + - Bills (flexible): 25 +- Investments and Savings, under which: + - Savings: 400 + +9. Add transactions for Income for 846.46 in the 'My bank account' on 21 Aug, Sept, Oct and Nov 2024, with the 'Note' column set to 'Salary', ticking the 'cleared' box -9. On 10 Sept 2024, add a transaction in 'My bank account' transferring 80.00 to - 'My cash account' with no Note, and tick the 'cleared' box -10. Add transactions for 200.00 to 'Tesco' in 'My bank account', categorised as +10. On 10 Sept 2024, add a transaction in 'My bank account' transferring 80.00 + to 'My cash account' with no Note, and tick the 'cleared' box +11. Add transactions for 200.00 to 'Tesco' in 'My bank account', categorised as 'Food', for 8 Aug, Sept, Oct, and Nov 2024 -11. In the 'Category transfers' account, add a transaction for 23rd Oct 2024, +12. In the 'Category transfers' account, add a transaction for 23rd Oct 2024, transferring 120.00 from 'Savings' to 'General' -12. Export the database by going to Settings > Export data -13. Download the resulting ZIP archive -14. Extract `db.sqlite` and `metadata.json` -15. Move them to +13. Export the database by going to Settings > Export data +14. Download the resulting ZIP archive +15. Extract `db.sqlite` and `metadata.json` +16. Move them to `actualbudget_queries/tests/resources/actualbudget_test_db.sqlite` and `actualbudget_queries/tests/resources/actualbudget_test_db_metadata.json` respectively, overwriting the files which are already there -16. Format the JSON in `actualbudget_test_db_metadata.json` to minimise diffs +17. Format the JSON in `actualbudget_test_db_metadata.json` to minimise diffs ## Updating the test database diff --git a/actualbudget_queries/tests/resources/actualbudget_test_db_metadata.json b/actualbudget_queries/tests/resources/actualbudget_test_db_metadata.json index 4d83f81..006b23d 100644 --- a/actualbudget_queries/tests/resources/actualbudget_test_db_metadata.json +++ b/actualbudget_queries/tests/resources/actualbudget_test_db_metadata.json @@ -1 +1,7 @@ -{"id":"My-Finances-1-36ec11a","budgetName":"My Finances 1","userId":"fec9ba17-c260-4f55-8d44-676ef0ec5da9","lastScheduleRun":"2024-11-21","resetClock":true}
\ No newline at end of file +{ + "id": "My-Finances-1-36ec11a", + "budgetName": "My Finances 1", + "userId": "fec9ba17-c260-4f55-8d44-676ef0ec5da9", + "lastScheduleRun": "2024-11-21", + "resetClock": true +} |
