Example of an implementation using Netlify' On Demand Builder functions for DPR

dpr-example-fetch-and-render-on-demand.js

require('dotenv').config();

const { builder } = require("@netlify/functions");

// Use the same page template our SSG uses dureing the build
const pageTemplate = require('../../src/site/_includes/layouts/idea.11ty.js');

const {
  DATABASE_URL,
  SUPABASE_SERVICE_API_KEY
} = process.env;


const handler = async event => {

  // connect to database
  const { createClient } = require('@supabase/supabase-js');
  const supabase = createClient(DATABASE_URL, SUPABASE_SERVICE_API_KEY);
  
  // Fetch the content at the specified path
  const path = event.path.split("idea/")[1];
  let { data: ideas, error } = await supabase
    .from('ideas')
    .select('*')
    .eq('path', path);

  
  console.log(`ODB render of ${path}`);
  
  // render the data into the template
  return {
    statusCode: 200,
    headers: {
      "Content-Type": "text/html",
    },
    body: pageTemplate(ideas[0])
  }
}

exports.handler = builder(handler);