import { createRouter, publicQuery } from "../middleware";
import { getDb } from "../queries/connection";
import { faqs } from "@db/schema";
import { eq, asc } from "drizzle-orm";

export const faqRouter = createRouter({
  list: publicQuery.query(async () => {
    const db = getDb();
    return db
      .select()
      .from(faqs)
      .where(eq(faqs.isActive, true))
      .orderBy(asc(faqs.sortOrder));
  }),
});