import { defineAction } from "@agent-native/core";
import { getRequestUserEmail } from "@agent-native/core/server";
import { eq, desc, and } from "drizzle-orm";
import { z } from "zod";

import { db, schema } from "../server/db/index.js";

export default defineAction({
  description: "List meals logged for a specific date",
  schema: z.object({
    date: z
      .string()
      .optional()
      .describe("Date in YYYY-MM-DD format (defaults to today)"),
  }),
  http: { method: "GET" },
  run: async (args) => {
    const today = new Date();
    const date =
      args.date ||
      `${today.getFullYear()}-${String(today.getMonth() + 1).padStart(2, "0")}-${String(today.getDate()).padStart(2, "0")}`;

    const ownerEmail = getRequestUserEmail();
    if (!ownerEmail) return [];

    const meals = await db()
      .select()
      .from(schema.meals)
      .where(
        and(
          eq(schema.meals.date, date),
          eq(schema.meals.owner_email, ownerEmail),
        ),
      )
      .orderBy(desc(schema.meals.created_at));

    return meals;
  },
});