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/card.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/card.ts')
| -rw-r--r-- | src/server/repositories/card.ts | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/server/repositories/card.ts b/src/server/repositories/card.ts index 761b317..04425a2 100644 --- a/src/server/repositories/card.ts +++ b/src/server/repositories/card.ts @@ -20,7 +20,8 @@ export const cardRepository: CardRepository = { const result = await db .select() .from(cards) - .where(and(eq(cards.deckId, deckId), isNull(cards.deletedAt))); + .where(and(eq(cards.deckId, deckId), isNull(cards.deletedAt))) + .orderBy(cards.createdAt); return result; }, @@ -73,7 +74,8 @@ export const cardRepository: CardRepository = { const result = await db .select() .from(cards) - .where(and(eq(cards.noteId, noteId), isNull(cards.deletedAt))); + .where(and(eq(cards.noteId, noteId), isNull(cards.deletedAt))) + .orderBy(cards.isReversed); return result; }, |