Skip to content

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

1.7 KB
Raw Blame
import { ident, safeSql, type SafeSqlFragment } from '@supabase/pg-meta/src/pg-format'

import { Hook } from './hooks.constants'

export const extractMethod = (
  uri: string,
  secret?: string
):
  | { type: 'postgres'; schema: string; functionName: string }
  | { type: 'https'; url: string; secret: string } => {
  if (uri.startsWith('https')) {
    return { type: 'https', url: uri, secret: secret || '' }
  } else {
    const [_proto, _x, _db, schema, functionName] = (uri || '').split('/')

    return {
      type: 'postgres',
      schema: schema || '',
      functionName: functionName || '',
    }
  }
}

export const isValidHook = (h: Hook) => {
  return (
    (h.method.type === 'postgres' &&
      h.method.schema.length > 0 &&
      h.method.functionName.length > 0) ||
    (h.method.type === 'https' && h.method.url.startsWith('https') && h.method.secret.length > 0)
  )
}

/**
 *
 * @param schema the schema that the function belongs to
 * @param functionName the function name associated with the hook
 * @returns an array of SQL statements to restore the original permissions to the function
 */
export const getRevokePermissionStatements = (
  schema: string,
  functionName: string
): Array<SafeSqlFragment> => {
  return [
    safeSql`-- Revoke access to function from supabase_auth_admin
revoke execute on function ${ident(schema)}.${ident(functionName)} from supabase_auth_admin;`,
    safeSql`-- Revoke access to schema from supabase_auth_admin
revoke usage on schema ${ident(schema)} from supabase_auth_admin;`,
    safeSql`-- Restore function permissions to authenticated, anon and public
grant execute on function ${ident(schema)}.${ident(functionName)} to authenticated, anon, public;`,
  ]
}