diff options
Diffstat (limited to 'src/lib/server/services/groceries.ts')
| -rw-r--r-- | src/lib/server/services/groceries.ts | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/src/lib/server/services/groceries.ts b/src/lib/server/services/groceries.ts index fc66300..c56599c 100644 --- a/src/lib/server/services/groceries.ts +++ b/src/lib/server/services/groceries.ts @@ -1,6 +1,7 @@ import { db as defaultDb } from '$lib/server/db'; import { groceries, categories, references } from '$lib/server/db/schema'; -import { eq, desc, inArray, asc } from 'drizzle-orm'; +import { eq, inArray, asc, desc } from 'drizzle-orm'; +import { referenceOrder } from './references'; import type { LibSQLDatabase } from 'drizzle-orm/libsql'; import type * as schema from '$lib/server/db/schema'; import type { Category, Grocery, Reference } from './types'; @@ -28,7 +29,7 @@ export async function loadUnchecked( db .select() .from(references) - .orderBy(desc(references.qualityScore), asc(references.id)), + .orderBy(...referenceOrder), ]); return { @@ -52,7 +53,7 @@ export async function loadAll( db .select() .from(references) - .orderBy(desc(references.qualityScore), asc(references.id)), + .orderBy(...referenceOrder), ]); return { |