Query about a payment

npx recaseai init

export default recase.workflow({
  id: "Query payment details",
  inputs: {
    paymentId: {
      name: "Payment ID",
      type: "string",
    },
    query: {
      name: "Query",
      type: "string",
    },
  }
});

import recase from "recaseai";
import { createClient } from "@supabase/supabase-js";

// Initialize Supabase client
const supabase = createClient(
  process.env.SUPABASE_URL || '',
  process.env.SUPABASE_KEY || ''
);

export default recase.workflow({
  //Workflow name and inputs as defined above
  id: "Query payment details",
  inputs: {
    paymentId: {
      name: "Payment ID",
      type: "string",
    },
    query: {
      name: "Query",
      type: "string",
    },
  },

  run: async ({ inputs }: any) => {

    // Query payment details from Supabase
    const { data: paymentData, error } = await supabase
      .from('payments')
      .select('*')
      .eq('payment_id', inputs.paymentId)
      .single();

    if (error) {
      throw new Error(`Failed to fetch payment: ${error.message}`);
    }

    // Use LLM to analyze payment data and answer query
    const answer = await recase.llm({
      message: `Given this payment information: ${JSON.stringify(paymentData)}
                Please answer this question: ${inputs.query}`,
      model: 'claude-3-5'
    });

    recase.log("Answer: ", answer);
  },
});

npx recase deploy --file workflow.ts