Skip to content

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

2.0 KB
Raw Blame
import { SEARCH_ENTITIES_MAX_QUERY_LENGTH } from '@supabase/pg-meta'

import type { EntitySearchTable } from '@/data/database/entity-search-query'

// Each search runs SQL against the user's database, so keep it to queries that
// are specific enough to be useful: short queries match too broadly to be worth
// the round-trip.
export const ENTITY_SEARCH_MIN_QUERY_LENGTH = 3
export const ENTITY_SEARCH_DEBOUNCE_MS = 300

export function getEntitySearchQuery(query: string) {
  const trimmed = query.trim()
  const isSearchable =
    trimmed.length >= ENTITY_SEARCH_MIN_QUERY_LENGTH &&
    trimmed.length <= SEARCH_ENTITIES_MAX_QUERY_LENGTH
  return { query: trimmed, isSearchable }
}

/**
 * Client-side mirror of the matching in getSearchEntitiesSql: the name contains
 * the query, or for `schema.name` queries, the schema starts with the part
 * before the first dot and the name contains the part after it. Used to narrow
 * results from a previous search while the current one is still in flight.
 */
export function matchesEntitySearch(
  { schema, name }: Pick<EntitySearchTable, 'schema' | 'name'>,
  query: string
) {
  const lowerQuery = query.toLowerCase()
  const lowerName = name.toLowerCase()
  if (lowerName.includes(lowerQuery)) return true

  const dotIndex = lowerQuery.indexOf('.')
  if (dotIndex === -1) return false

  const schemaPart = lowerQuery.slice(0, dotIndex)
  const namePart = lowerQuery.slice(dotIndex + 1)
  return schema.toLowerCase().startsWith(schemaPart) && lowerName.includes(namePart)
}

export function formatTableSearchDetails({
  policy_count,
  rls_enabled,
}: Pick<EntitySearchTable, 'policy_count' | 'rls_enabled'>) {
  const policies = `${policy_count} ${policy_count === 1 ? 'policy' : 'policies'}`
  return `${policies} • RLS ${rls_enabled ? 'enabled' : 'disabled'}`
}

export function getTableEditorRoute(
  projectRef: string,
  table: Pick<EntitySearchTable, 'id' | 'schema'>
): `/${string}` {
  return `/project/${projectRef}/editor/${table.id}?schema=${encodeURIComponent(table.schema)}`
}