Skip to content

The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.

2.5 KB
Raw Blame
import { createClient } from '@supabase/supabase-js'
import { Router } from 'itty-router'
import { json, status, withContent } from 'itty-router-extras'
import { readFrom, writeTo } from './utils/cache'

const router = new Router()

router.get('/read-kv', async (request, { ARTICLES }) => {
  const articles = await readFrom(ARTICLES, '/articles')
  return json(articles)
})

router.get('/write-kv', async (request, { ARTICLES }) => {
  const articles = [{ title: 'test3' }, { title: 'test4' }]
  await writeTo(ARTICLES, '/articles', articles)

  return json(articles)
})

router.get('/articles', async (request, { SUPABASE_URL, SUPABASE_PUBLISHABLE_KEY, ARTICLES }) => {
  const cachedArticles = await readFrom(ARTICLES, '/articles')

  if (cachedArticles) {
    console.log('sending the cache')
    return json(cachedArticles)
  }

  console.log('fetching fresh articles')

  const supabase = createClient(SUPABASE_URL, SUPABASE_PUBLISHABLE_KEY)

  const { data } = await supabase.from('articles').select('*')
  await writeTo(ARTICLES, '/articles', data)
  return json(data)
})

router.get(
  '/articles/:id',
  async (request, { SUPABASE_URL, SUPABASE_PUBLISHABLE_KEY, ARTICLES }) => {
    const { id } = request.params
    const cachedArticle = await readFrom(ARTICLES, `/articles/${id}`)

    if (cachedArticle) {
      console.log('sending the cache')
      return json(cachedArticle)
    }

    console.log('fetching fresh article')

    const supabase = createClient(SUPABASE_URL, SUPABASE_PUBLISHABLE_KEY)

    const { data } = await supabase.from('articles').select('*').match({ id }).single()

    await writeTo(ARTICLES, `/articles/${id}`, data)

    return json(data)
  }
)

router.post(
  '/revalidate',
  withContent,
  async (request, { SUPABASE_URL, SUPABASE_PUBLISHABLE_KEY, ARTICLES }, context) => {
    const updateCache = async () => {
      const { type, record, old_record } = request.content
      const supabase = createClient(SUPABASE_URL, SUPABASE_PUBLISHABLE_KEY)

      if (type === 'INSERT' || type === 'UPDATE') {
        await writeTo(ARTICLES, `/articles/${record.id}`, record)
      }

      if (type === 'DELETE') {
        await ARTICLES.delete(`/articles/${old_record.id}`)
      }

      const { data: articles } = await supabase.from('articles').select('*')
      await writeTo(ARTICLES, '/articles', articles)
      console.log('updated cache')
    }

    context.waitUntil(updateCache())

    console.log('sending response')

    return json({ received: true })
  }
)

router.all('*', () => status(404, 'Not found'))

export default {
  fetch: router.handle,
}