import { asc } from "drizzle-orm";
import { db } from "./index";
import { teamMember } from "./schema";

export type TeamMemberRow = {
  id: number;
  firstName: string;
  lastName: string;
  age: number;
  profession: string;
  image: string;
  sortOrder: number | null;
};

export async function getTeamMembers(): Promise<TeamMemberRow[]> {
  if (!db) return [];
  try {
    const rows = await db
      .select()
      .from(teamMember)
      .orderBy(asc(teamMember.sortOrder), asc(teamMember.id));
    return rows as TeamMemberRow[];
  } catch {
    return [];
  }
}
