mirror of
https://github.com/supabase/supabase.git
synced 2026-10-05 17:35:10 +03:00
Joshen Lim
1baaded0bb
## Context Just some clean up as I was going through stuff - `useExecuteSqlQuery` is deprecated and not used at all - As such `execute-sql-query` is technically irrelevant, the more relevant file is `execute-sql-mutation` - Hence opting to consolidate `execute-sql-query` into `execute-sql-mutation` - Also removing `ExecuteSqlError` since its just re-exporting the `ResponseError` type There's a lot of file changes but its essentially just updating the importing statements across the files
61 lines
1.9 KiB
TypeScript
61 lines
1.9 KiB
TypeScript
import { safeSql } from '@supabase/pg-meta/src/pg-format'
|
|
import { useQuery } from '@tanstack/react-query'
|
|
|
|
import { executeSql } from '../sql/execute-sql-mutation'
|
|
import { tableKeys } from './keys'
|
|
import type { ResponseError, UseCustomQueryOptions } from '@/types'
|
|
|
|
export type TableName = {
|
|
id: number
|
|
schema: string
|
|
name: string
|
|
}
|
|
|
|
export type TableNamesVariables = {
|
|
projectRef?: string
|
|
connectionString?: string | null
|
|
}
|
|
|
|
const TABLE_NAMES_SQL = safeSql`
|
|
select
|
|
c.oid::int8 as id,
|
|
nc.nspname as schema,
|
|
c.relname as name
|
|
from pg_namespace nc
|
|
join pg_class c on nc.oid = c.relnamespace
|
|
where c.relkind in ('r', 'p')
|
|
and not pg_is_other_temp_schema(nc.oid)
|
|
and nc.nspname not in ('information_schema', 'pg_catalog', 'pg_toast')
|
|
and (
|
|
pg_has_role(c.relowner, 'USAGE')
|
|
or has_table_privilege(c.oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER')
|
|
or has_any_column_privilege(c.oid, 'SELECT, INSERT, UPDATE, REFERENCES')
|
|
)
|
|
order by nc.nspname, c.relname
|
|
`
|
|
|
|
export async function getTableNames(
|
|
{ projectRef, connectionString }: TableNamesVariables,
|
|
signal?: AbortSignal
|
|
) {
|
|
const { result } = await executeSql<TableName[]>(
|
|
{ projectRef, connectionString, sql: TABLE_NAMES_SQL, queryKey: ['table-names'] },
|
|
signal
|
|
)
|
|
return result
|
|
}
|
|
|
|
export type TableNamesData = Awaited<ReturnType<typeof getTableNames>>
|
|
export type TableNamesError = ResponseError
|
|
|
|
export const useTableNamesQuery = <TData = TableNamesData>(
|
|
{ projectRef, connectionString }: TableNamesVariables,
|
|
{ enabled = true, ...options }: UseCustomQueryOptions<TableNamesData, TableNamesError, TData> = {}
|
|
) =>
|
|
useQuery<TableNamesData, TableNamesError, TData>({
|
|
queryKey: tableKeys.names(projectRef),
|
|
queryFn: ({ signal }) => getTableNames({ projectRef, connectionString }, signal),
|
|
enabled: enabled && typeof projectRef !== 'undefined',
|
|
...options,
|
|
})
|