diff options
| author | nsfisis <nsfisis@gmail.com> | 2025-12-31 20:34:27 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2025-12-31 20:34:27 +0900 |
| commit | e3a84df9fcae8f25c8ea1d527638c2bfaafb942e (patch) | |
| tree | 605f909c78e8b4510b7110d57749c1c0fe566360 /src/server/repositories/deck.ts | |
| parent | b69fd1353c449baa3262016c2bb8f653932bd932 (diff) | |
| download | kioku-e3a84df9fcae8f25c8ea1d527638c2bfaafb942e.tar.gz kioku-e3a84df9fcae8f25c8ea1d527638c2bfaafb942e.tar.zst kioku-e3a84df9fcae8f25c8ea1d527638c2bfaafb942e.zip | |
feat(db): add ORDER BY to repository SELECT queries
Ensures deterministic ordering for all multi-row SELECT queries:
- deck/note/noteType findByUserId/findByDeckId: order by createdAt
- card findByNoteId: order by isReversed (normal card first)
- note field values: order by noteFieldTypeId
- sync pull queries: order by id
This guarantees consistent UI display and sync results regardless
of PostgreSQL's internal row ordering.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
Diffstat (limited to 'src/server/repositories/deck.ts')
| -rw-r--r-- | src/server/repositories/deck.ts | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/server/repositories/deck.ts b/src/server/repositories/deck.ts index 77985a7..647c5cb 100644 --- a/src/server/repositories/deck.ts +++ b/src/server/repositories/deck.ts @@ -8,7 +8,8 @@ export const deckRepository: DeckRepository = { const result = await db .select() .from(decks) - .where(and(eq(decks.userId, userId), isNull(decks.deletedAt))); + .where(and(eq(decks.userId, userId), isNull(decks.deletedAt))) + .orderBy(decks.createdAt); return result; }, |