xonecas.io
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}