[PR #4251] [CLOSED] [WIP] [TypeScript] Make db.select functions generic to make it easy to type DB query results #5285

Closed
opened 2026-02-28 21:09:51 -06:00 by GiteaMirror · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/actualbudget/actual/pull/4251
Author: @joel-jeremy
Created: 1/28/2025
Status: ❌ Closed

Base: ts-db-all ← Head: ts-db-select


📝 Commits (10+)

📊 Changes

47 files changed (+808 additions, -310 deletions)

View changed files

📝 packages/loot-core/src/mocks/budget.ts (+4 -4)
📝 packages/loot-core/src/server/accounts/app.ts (+55 -25)
📝 packages/loot-core/src/server/accounts/link.ts (+1 -1)
📝 packages/loot-core/src/server/accounts/payees.ts (+4 -5)
📝 packages/loot-core/src/server/accounts/sync.test.ts (+3 -1)
📝 packages/loot-core/src/server/accounts/sync.ts (+38 -8)
📝 packages/loot-core/src/server/api.ts (+8 -6)
📝 packages/loot-core/src/server/aql/exec.test.ts (+3 -1)
📝 packages/loot-core/src/server/aql/schema/executors.ts (+5 -3)
📝 packages/loot-core/src/server/aql/schema/index.test.ts (+42 -12)
📝 packages/loot-core/src/server/budget/actions.ts (+42 -27)
📝 packages/loot-core/src/server/budget/base.ts (+4 -2)
📝 packages/loot-core/src/server/budget/cleanup-template.ts (+5 -5)
📝 packages/loot-core/src/server/budget/goalsSchedule.ts (+4 -2)
📝 packages/loot-core/src/server/budget/goaltemplates.ts (+8 -8)
📝 packages/loot-core/src/server/budget/statements.ts (+15 -2)
📝 packages/loot-core/src/server/dashboard/app.ts (+4 -3)
📝 packages/loot-core/src/server/db/index.ts (+122 -78)
📝 packages/loot-core/src/server/db/mappings.ts (+6 -6)
📝 packages/loot-core/src/server/db/util.ts (+11 -7)

...and 27 more files

📄 Description

Follow up to https://github.com/actualbudget/actual/pull/4247

  • db.runQuery
  • db.first
  • db.firstSync
  • db.all
  • db.select
  • db.selectWithSchema
  • db.selectFirstWithSchema

🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/actualbudget/actual/pull/4251 **Author:** [@joel-jeremy](https://github.com/joel-jeremy) **Created:** 1/28/2025 **Status:** ❌ Closed **Base:** `ts-db-all` ← **Head:** `ts-db-select` --- ### 📝 Commits (10+) - [`c0fde0d`](https://github.com/actualbudget/actual/commit/c0fde0d9d09cb73ac5ded0db51d8c88e08a118d9) [TypeScript] Make db.first generic - [`7425d0c`](https://github.com/actualbudget/actual/commit/7425d0cbd3c771d50d5a3be6b25882989f9f69bb) Release notes - [`9137c4f`](https://github.com/actualbudget/actual/commit/9137c4f432687e6d889a9bcedf6391b5a94ced42) Fix typecheck error - [`19fa629`](https://github.com/actualbudget/actual/commit/19fa6295856062f41aea9f80d2063ef8f4c7d875) Cleanup type - [`e06d75a`](https://github.com/actualbudget/actual/commit/e06d75a3974cfbc6ea3d6e37cfd3132573832471) Update db.first calls - [`553e00b`](https://github.com/actualbudget/actual/commit/553e00b4dfebf7c0427dff0423f8e6dfb0359ad0) Fix strict type - [`5b8c411`](https://github.com/actualbudget/actual/commit/5b8c4111347b8cd9cd4474683260b513d73f8cca) [TypeScript] Make db.firstSync generic - [`9a52b46`](https://github.com/actualbudget/actual/commit/9a52b461a25c0d14698e29a428a2dc2b6086adb5) Release notes - [`2e23ccc`](https://github.com/actualbudget/actual/commit/2e23cccb9921d0d4787500052af120b2d441e57f) [TypeScript] Make `db.all` generic - [`42217ea`](https://github.com/actualbudget/actual/commit/42217eac3d28811cce45b77957ce8dad167ef518) Release notes ### 📊 Changes **47 files changed** (+808 additions, -310 deletions) <details> <summary>View changed files</summary> 📝 `packages/loot-core/src/mocks/budget.ts` (+4 -4) 📝 `packages/loot-core/src/server/accounts/app.ts` (+55 -25) 📝 `packages/loot-core/src/server/accounts/link.ts` (+1 -1) 📝 `packages/loot-core/src/server/accounts/payees.ts` (+4 -5) 📝 `packages/loot-core/src/server/accounts/sync.test.ts` (+3 -1) 📝 `packages/loot-core/src/server/accounts/sync.ts` (+38 -8) 📝 `packages/loot-core/src/server/api.ts` (+8 -6) 📝 `packages/loot-core/src/server/aql/exec.test.ts` (+3 -1) 📝 `packages/loot-core/src/server/aql/schema/executors.ts` (+5 -3) 📝 `packages/loot-core/src/server/aql/schema/index.test.ts` (+42 -12) 📝 `packages/loot-core/src/server/budget/actions.ts` (+42 -27) 📝 `packages/loot-core/src/server/budget/base.ts` (+4 -2) 📝 `packages/loot-core/src/server/budget/cleanup-template.ts` (+5 -5) 📝 `packages/loot-core/src/server/budget/goalsSchedule.ts` (+4 -2) 📝 `packages/loot-core/src/server/budget/goaltemplates.ts` (+8 -8) 📝 `packages/loot-core/src/server/budget/statements.ts` (+15 -2) 📝 `packages/loot-core/src/server/dashboard/app.ts` (+4 -3) 📝 `packages/loot-core/src/server/db/index.ts` (+122 -78) 📝 `packages/loot-core/src/server/db/mappings.ts` (+6 -6) 📝 `packages/loot-core/src/server/db/util.ts` (+11 -7) _...and 27 more files_ </details> ### 📄 Description <!-- Thank you for submitting a pull request! Make sure to follow the instructions to write release notes for your PR — it should only take a minute or two: https://github.com/actualbudget/docs#writing-good-release-notes --> Follow up to https://github.com/actualbudget/actual/pull/4247 - [x] `db.runQuery` - [x] `db.first` - [x] `db.firstSync` - [x] `db.all` - [x] `db.select` - [x] `db.selectWithSchema` - [x] `db.selectFirstWithSchema` --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
GiteaMirror added the pull-request label 2026-02-28 21:09:51 -06:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#5285