import db from "./db";

export interface Page {
  id: number;
  title: string;
  type: string;
  description: string;
  isActive: number;
  created_at: string;
  updated_at: string;
}

export async function getPage(type: string): Promise<Page | null> {
  const [rows] = await db.execute(
    `
      SELECT
        id,
        title,
        type,
        description,
        isActive,
        created_at,
        updated_at
      FROM pages
      WHERE type = ?
      AND isActive = 1
      LIMIT 1
    `,
    [type]
  );

  const pages = rows as Page[];

  return pages.length > 0 ? pages[0] : null;
}