From e3a84df9fcae8f25c8ea1d527638c2bfaafb942e Mon Sep 17 00:00:00 2001 From: nsfisis Date: Wed, 31 Dec 2025 20:34:27 +0900 Subject: feat(db): add ORDER BY to repository SELECT queries MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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 --- src/server/repositories/deck.ts | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src/server/repositories/deck.ts') 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; }, -- cgit v1.2.3-70-g09d2