triggerdotdev--trigger.dev/apps/webapp/prisma/seed.ts

import { PrismaClient } from ".prisma/client";
import { readFile } from "fs/promises";
import path from "node:path";

const prisma = new PrismaClient();

async function readTemplateDocsFile(slug: string) {
  const currentWorkingDir = process.cwd();

  const resolvedPath = path.resolve(
    currentWorkingDir,
    `./templates/docs/${slug}.md`
  );

  console.log(
    `📖 Reading template docs file for ${slug} at ${resolvedPath} being in ${currentWorkingDir}`
  );

  return readFile(resolvedPath, "utf8");
}

async function seed() {
  console.log(`Database has been seeded. 🌱`);

  const blankStarter = {
    repositoryUrl: "https://github.com/triggerdotdev/blank-starter",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/db8c4256-8ec7-44bf-14f7-55334acc5e00/public",
    title: "A blank starter ready to run your own workflow",
    shortTitle: "Blank Starter",
    description:
      "This is a great place to start if you want to build your own workflow from scratch.",
    priority: 0,
    services: [],
    workflowIds: [],
    markdownDocs: await readTemplateDocsFile("blank-starter"),
  };

  const helloWorld = {
    repositoryUrl: "https://github.com/triggerdotdev/hello-world",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/54ee6eed-4095-4bb2-4ea8-8adbcffa9a00/public",
    title: "'Hello World' with a simple custom event trigger",
    shortTitle: "Hello World",
    description:
      "This is a great place to start if you're new to Trigger.dev and want to learn how to build a simple workflow.",
    priority: 10,
    services: [],
    workflowIds: ["hello-world"],
    markdownDocs: await readTemplateDocsFile("hello-world"),
  };

  const cronBasic = {
    repositoryUrl: "https://github.com/triggerdotdev/cron-basic",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/7cb7e740-0a1a-453a-3f07-4a85f3ec9200/public",
    title: "A basic CRON job workflow template",
    shortTitle: "CRON basic",
    description:
      "This template contains a simple CRON job workflow that runs every weekday at 9:00 AM UTC.",
    priority: 15,
    services: [],
    workflowIds: [],
    markdownDocs: await readTemplateDocsFile("cron-basic"),
  };

  const scheduledHealthcheck = {
    repositoryUrl: "https://github.com/triggerdotdev/scheduled-healthcheck",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/507fc0d0-056e-4ff0-7cb0-72b7ea44c600/public",
    title: "Run a scheduled healthcheck on your website every 5 minutes",
    shortTitle: "Scheduled Healthcheck",
    description:
      "This will run every 5 minutes and send a Slack message if a website url returns a non-200 response.",
    priority: 20,
    services: ["slack"],
    workflowIds: ["scheduled-healthcheck"],
    markdownDocs: await readTemplateDocsFile("scheduled-healthcheck"),
    runLocalDocs: await readTemplateDocsFile("scheduled-healthcheck-local"),
  };

  const githubStarsToSlack = {
    repositoryUrl: "https://github.com/triggerdotdev/github-stars-to-slack",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/0ec1b94e-2941-4336-d443-7c80c3673900/public",
    title: "Post to Slack every time a GitHub repo is starred",
    shortTitle: "GitHub stars to Slack",
    description:
      "When a GitHub repo is starred, post information about the user to Slack.",
    priority: 30,
    services: ["github", "slack"],
    workflowIds: ["github-stars-to-slack"],
    markdownDocs: await readTemplateDocsFile("github-stars-to-slack"),
    runLocalDocs: await readTemplateDocsFile("github-stars-to-slack-local"),
  };

  const githubIssuesToSlack = {
    repositoryUrl: "https://github.com/triggerdotdev/github-issues-to-slack",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/726c0203-467d-40f2-58aa-55b3e10a9900/public",
    title: "Post to Slack when a GitHub issue is created or modified",
    shortTitle: "GitHub issues to Slack",
    description:
      "When a GitHub issue is created or modified, post a message and link to the issue in a specific Slack channel.",
    priority: 40,
    services: ["github", "slack"],
    workflowIds: ["github-issues-to-slack"],
    markdownDocs: await readTemplateDocsFile("github-issues-to-slack"),
    runLocalDocs: await readTemplateDocsFile("github-issues-to-slack-local"),
  };

  const githubIssuesToNotion = {
    repositoryUrl: "https://github.com/triggerdotdev/github-issues-to-notion",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/05bfa3fc-d0a5-4d09-aab9-6fa24e7c5c00/public",
    title: "Sync a new GitHub issue to a Notion database",
    shortTitle: "Sync GitHub issues to Notion",
    description:
      "When a GitHub issue is created, sync it to your Notion database, with any properties you want.",
    priority: 23,
    services: ["github", "notion"],
    workflowIds: ["github-issues-to-notion"],
    markdownDocs: await readTemplateDocsFile("github-issues-to-notion"),
    runLocalDocs: await readTemplateDocsFile("github-issues-to-notion-local"),
  };

  const resendWelcomeDripCampaign = {
    repositoryUrl:
      "https://github.com/triggerdotdev/resend-welcome-drip-campaign",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/286c6a9a-0420-48a5-be55-29c5bbf80300/public",
    title: "A Resend email drip campaign when a new user signs up",
    shortTitle: "Resend.com drip campaign",
    description:
      "When a new user is created, send them a welcome drip campaign from Resend.com and react.email.",
    priority: 50,
    services: ["resend"],
    workflowIds: ["resend-welcome-drip-campaign"],
    markdownDocs: await readTemplateDocsFile("resend-welcome-drip-campaign"),
    runLocalDocs: await readTemplateDocsFile(
      "resend-welcome-drip-campaign-local"
    ),
  };

  const sendgridWelcomeDripCampaign = {
    repositoryUrl:
      "https://github.com/triggerdotdev/sendgrid-welcome-drip-campaign",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/515e4c54-c5ec-47e6-07a1-85254599fb00/public",
    title: "A SendGrid email drip campaign when a new user signs up",
    shortTitle: "SendGrid drip campaign",
    description:
      "When a new user is created, send them a welcome drip campaign from SendGrid.",
    priority: 51,
    services: ["sendgrid"],
    workflowIds: ["sendgrid-welcome-drip-campaign"],
    markdownDocs: await readTemplateDocsFile("sendgrid-welcome-drip-campaign"),
  };

  const supabaseToDiscord = {
    repositoryUrl: "https://github.com/triggerdotdev/supabase-to-discord",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/26c93ad0-4207-4c9e-2ae2-35a9ff8e8300/public",
    title: "Send a message to Discord from a Supabase webhook",
    shortTitle: "Supabase to Discord",
    description:
      "Send a message to a Discord channel when a new row is inserted into a Supabase table.",
    priority: 42,
    services: [],
    workflowIds: ["supabase-to-discord"],
    markdownDocs: await readTemplateDocsFile("supabase-to-discord"),
  };

  const supabaseToLoops = {
    repositoryUrl: "https://github.com/triggerdotdev/supabase-to-loops",
    imageUrl:
      "https://imagedelivery.net/3TbraffuDZ4aEf8KWOmI_w/08cf39d8-f473-43d0-1de6-4668b60ae300/public",
    title: "Create a Loops.so contact from a Supabase webhook",
    shortTitle: "Supabase to Loops.so",
    description:
      "Create a contact in Loops.so when a new user row is inserted into a Supabase table, using Supabase webhooks.",
    priority: 41,
    services: [],
    workflowIds: ["supabase-to-loops"],
    markdownDocs: await readTemplateDocsFile("supabase-to-loops"),
  };

  await prisma.template.updateMany({
    where: {
      slug: "basic-starter",
    },
    data: {
      isLive: false,
    },
  });

  await prisma.template.upsert({
    where: { slug: "blank-starter" },
    update: blankStarter,
    create: {
      slug: "blank-starter",
      ...blankStarter,
    },
  });

  await prisma.template.upsert({
    where: { slug: "cron-basic" },
    update: cronBasic,
    create: {
      slug: "cron-basic",
      ...cronBasic,
    },
  });

  await prisma.template.upsert({
    where: { slug: "hello-world" },
    update: helloWorld,
    create: {
      slug: "hello-world",
      ...helloWorld,
    },
  });

  await prisma.template.upsert({
    where: { slug: "scheduled-healthcheck" },
    update: scheduledHealthcheck,
    create: {
      slug: "scheduled-healthcheck",
      ...scheduledHealthcheck,
    },
  });

  await prisma.template.upsert({
    where: { slug: "github-stars-to-slack" },
    update: githubStarsToSlack,
    create: {
      slug: "github-stars-to-slack",
      ...githubStarsToSlack,
    },
  });

  await prisma.template.upsert({
    where: { slug: "github-issues-to-slack" },
    update: githubIssuesToSlack,
    create: {
      slug: "github-issues-to-slack",
      ...githubIssuesToSlack,
    },
  });

  await prisma.template.upsert({
    where: { slug: "github-issues-to-notion" },
    update: githubIssuesToNotion,
    create: {
      slug: "github-issues-to-notion",
      ...githubIssuesToNotion,
    },
  });

  await prisma.template.upsert({
    where: { slug: "resend-welcome-drip-campaign" },
    update: resendWelcomeDripCampaign,
    create: {
      slug: "resend-welcome-drip-campaign",
      ...resendWelcomeDripCampaign,
    },
  });

  await prisma.template.upsert({
    where: { slug: "sendgrid-welcome-drip-campaign" },
    update: sendgridWelcomeDripCampaign,
    create: {
      slug: "sendgrid-welcome-drip-campaign",
      ...sendgridWelcomeDripCampaign,
    },
  });

  await prisma.template.upsert({
    where: { slug: "supabase-to-discord" },
    update: supabaseToDiscord,
    create: {
      slug: "supabase-to-discord",
      ...supabaseToDiscord,
    },
  });

  await prisma.template.upsert({
    where: { slug: "supabase-to-loops" },
    update: supabaseToLoops,
    create: {
      slug: "supabase-to-loops",
      ...supabaseToLoops,
    },
  });
}

seed()
  .catch((e) => {
    console.error(e);
    process.exit(1);
  })
  .finally(async () => {
    await prisma.$disconnect();
  });