Function fetchPage

lib/hooks/useDocumentsLoader.ts:41–79

(page: number)

  };

  const fetchPage = async (page: number) => {
    const { data: documents, error } = await supabase.rpc("get_sections", {
      _limit: PAGE_SIZE,
      _offset: (page - 1) * PAGE_SIZE,
    });

    if (error) {
      console.error(error);
      return;
    }

    if (!documents?.length) return;

    const newDocuments: Document[] = [];

    for (const document of documents) {
      try {
        const documentRowIds = document.ids.split(",");
        const { data: documentChunks } = await supabase
          .from("doc_chunks")
          .select("*")
          .in("id", documentRowIds);

        if (documentChunks?.length) {
          newDocuments.push({
            docChunks: documentChunks,
            pageName: document.result_page_title,
            sectionName: document.result_section_title,
            createdAt: document.latest_created_at,
            url: document.result_page_url,
          });
        }
      } catch (error) {
        console.error(error);
      }
    }

    setDocs(newDocuments);
  };

  const refreshPage = async () => {
    await fetchPage(docPage);