Function getPlugins

apps/cursor/src/data/queries.ts:333–367

({
  page = 1,
  limit = 36,
  fetchAll = false,
}: {
  page?: number;
  limit?: number;
  fetchAll?: boolean;
} = {})

// ---------------------------------------------------------------------------

export async function getPlugins({
  page = 1,
  limit = 36,
  fetchAll = false,
}: {
  page?: number;
  limit?: number;
  fetchAll?: boolean;
} = {}): Promise<{ data: PluginRow[] | null; error: unknown }> {
  "use cache";
  cacheLife("hours");
  cacheTag("plugins");

  const supabase = await createClient();

  const baseQuery = () =>
    supabase
      .from("plugins")
      .select("*, plugin_components(*)")
      .eq("active", true)
      .order("created_at", { ascending: false });

  if (fetchAll) {
    return fetchAllPages<PluginRow>(async (from, to) => {
      const { data, error } = await baseQuery().range(from, to);
      return { data: data as PluginRow[] | null, error };
    }, 100);
  }

  const { data, error } = await baseQuery()
    .limit(limit)
    .range((page - 1) * limit, page * limit - 1);

  return { data: data as PluginRow[] | null, error };
}

// Slugs of every `rule` component on an active plugin. Legacy rule URLs
// (`/{rule-slug}`) prerender a redirect to the parent plugin, and there are