diff options
Diffstat (limited to 'src/lib/server/services/groceries.ts')
| -rw-r--r-- | src/lib/server/services/groceries.ts | 17 |
1 files changed, 13 insertions, 4 deletions
diff --git a/src/lib/server/services/groceries.ts b/src/lib/server/services/groceries.ts index 9aa8102..fc66300 100644 --- a/src/lib/server/services/groceries.ts +++ b/src/lib/server/services/groceries.ts @@ -20,12 +20,15 @@ export async function loadUnchecked( .select() .from(groceries) .where(eq(groceries.checked, false)) - .orderBy(desc(groceries.createdAt)), + .orderBy(desc(groceries.createdAt), desc(groceries.id)), db .select() .from(categories) .orderBy(asc(categories.order), asc(categories.name)), - db.select().from(references).orderBy(desc(references.qualityScore)), + db + .select() + .from(references) + .orderBy(desc(references.qualityScore), asc(references.id)), ]); return { @@ -38,12 +41,18 @@ export async function loadAll( db = defaultDb, ): Promise<{ items: EnrichedGrocery[]; categories: Category[] }> { const [items, cats, refs] = await Promise.all([ - db.select().from(groceries).orderBy(desc(groceries.createdAt)), + db + .select() + .from(groceries) + .orderBy(desc(groceries.createdAt), desc(groceries.id)), db .select() .from(categories) .orderBy(asc(categories.order), asc(categories.name)), - db.select().from(references).orderBy(desc(references.qualityScore)), + db + .select() + .from(references) + .orderBy(desc(references.qualityScore), asc(references.id)), ]); return { |