summaryrefslogtreecommitdiff
path: root/actualbudget_queries
diff options
context:
space:
mode:
authorJoe Carstairs <me@joeac.net>2025-07-17 23:15:31 +0100
committerJoe Carstairs <me@joeac.net>2025-07-17 23:15:41 +0100
commiteb5c1e031ee69e4eef68d3054c973ded23dc8e64 (patch)
tree33076accf4c5971318b148e482a877a56d5f1e8b /actualbudget_queries
parent5a75def2f5e9cd5f3421a908505c59ac074dae74 (diff)
applies formatting
Diffstat (limited to 'actualbudget_queries')
-rw-r--r--actualbudget_queries/README.md40
-rw-r--r--actualbudget_queries/tests/resources/actualbudget_test_db_metadata.json8
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
+}