556
Bn
bees-nest / files
bees-nest / src / app / api / search / route.ts
1.1 KB
1import { eq, sql } from "drizzle-orm"; 2import { NextResponse } from "next/server"; 3import { pages, urls } from "@/db/schema"; 4import { db } from "@/lib/db"; 5 6export const dynamic = "force-dynamic"; 7 8export async function GET(req: Request) { 9 const { searchParams } = new URL(req.url); 10 const q = searchParams.get("q"); 11 12 if (!q) { 13 return NextResponse.json({ results: [] }); 14 } 15 16 // Full Text Search using Postgres tsvector 17 const searchVector = sql`to_tsvector('english', coalesce(${pages.title}, '') || ' ' || coalesce(${pages.description}, '') || ' ' || coalesce(${pages.content}, ''))`; 18 const query = sql`websearch_to_tsquery('english', ${q})`; 19 20 const results = await db 21 .select({ 22 id: pages.id, 23 title: pages.title, 24 description: pages.description, 25 url: urls.url, 26 image: pages.image, 27 siteName: pages.siteName, 28 rank: sql`ts_rank(${searchVector}, ${query})`.as("rank"), 29 }) 30 .from(pages) 31 .innerJoin(urls, eq(pages.urlId, urls.id)) 32 .where(sql`${searchVector} @@ ${query}`) 33 .orderBy(sql`ts_rank(${searchVector}, ${query}) DESC`) 34 .limit(20); 35 36 return NextResponse.json({ results }); 37}