import {
  SessionState,
  GoogleSheetsInsertRowOptions,
  ChatLog,
} from "indite-js/schemas";
import { parseNewRowObject } from "./helpers/parseNewRowObject";
import { getAuthenticatedGoogleDoc } from "./helpers/getAuthenticatedGoogleDoc";
import { ExecuteIntegrationResponse } from "../../../types";

export const insertRow = async (
  state: SessionState,
  {
    outgoingEdgeId,
    options,
  }: { outgoingEdgeId?: string; options: GoogleSheetsInsertRowOptions }
): Promise<ExecuteIntegrationResponse> => {
  const { variables } = state.botsQueue[0].bot;
  if (!options.cellsToInsert || !options.sheetId) return { outgoingEdgeId };

  const logs: ChatLog[] = [];

  const doc = await getAuthenticatedGoogleDoc({
    credentialsId: options.credentialsId,
    spreadsheetId: options.spreadsheetId,
  });

  const parsedValues = parseNewRowObject(variables)(options.cellsToInsert);

  try {
    await doc.loadInfo();
    const sheet = doc.sheetsById[Number(options.sheetId)];
    await sheet.addRow(parsedValues);
    logs.push({
      status: "success",
      description: `Succesfully inserted row in ${doc.title} > ${sheet.title}`,
    });
  } catch (err) {
    logs.push({
      status: "error",
      description: `An error occured while inserting the row`,
      details: err,
    });
  }

  return { outgoingEdgeId, logs };
};