index.mjs

import * as dotenv from "dotenv";
dotenv.config();

import { createClient } from "@supabase/supabase-js";
import { writeFileSync } from "fs";

// Create a single supabase client for interacting with your database
const supabase = createClient(
  process.env.SUPABASE_URL,
  process.env.SUPABASE_ANON_KEY
);

const { data, error } = await supabase.from("prompts").select(`
	name,
	description,
	messages,
	handles!handles_prompt_id_fkey(
		handle
	),
	created_by:profiles!prompts_created_by_fkey(
		handles!handles_user_id_fkey(
			handle
		)
	),
	star_count:user-star-prompts(
		count
	),
	created_at
`);

const result = data
  .sort((a, b) => b.star_count[0].count - a.star_count[0].count)
  // .filter((prompt) => prompt.messages && prompt.messages[0])
  .slice(0, 50)
  .map((prompt) => {
    return {
      name: prompt.name,
      description: prompt.description,
      prompt:
        prompt.messages && prompt.messages[0] ? prompt.messages[0].content : "",
      handle: prompt.handles.handle,
      created_by: prompt.created_by.handles.handle,
      star_count: prompt.star_count[0].count,
    };
  });

writeFileSync("TopPrompts.json", JSON.stringify(result, null, 2));

const promptContentList = result.map(
  (prompt, i) => `
## [${i}. ${prompt.name}](https://openprompt.co/${prompt.handle})

${prompt.description}

> ${prompt.prompt}

[&#128221;: ${prompt.created_by}](https://openprompt.co/${
	prompt.created_by
}) &#127775;: ${prompt.star_count}

`
);

// Generate README.md
const readme = `# OpenPrompt

This is a list of the most starred prompts on [OpenPrompt.co](https://openprompt.co). The list is updated every 24 hours.

The data is also available in the JSON format: [TopPrompts.json](./TopPrompts.json). If you have any suggestion for OpenPrompt, please [open an issue](https://github.com/timqian/openprompt.co/issues)

${promptContentList.join("")}
`;

writeFileSync("README.md", readme);