The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
type KeyValueFieldName = string
export type KeyValueFieldArrayValidationIssue<TFieldName extends KeyValueFieldName> = {
path: [number, TFieldName]
message: string
}
type GetKeyValueFieldArrayValidationIssuesParams<
TRow extends Record<string, unknown>,
TKeyFieldName extends Extract<keyof TRow, string>,
TValueFieldName extends Extract<keyof TRow, string>,
> = {
rows: TRow[]
keyFieldName: TKeyFieldName
valueFieldName: TValueFieldName
keyRequiredMessage: string
valueRequiredMessage: string
duplicateKeyMessage?: string
allowEmptyRows?: boolean
normaliseKey?: (key: string) => string
}
const getTrimmedString = (value: unknown) => (typeof value === 'string' ? value.trim() : '')
export type StripEmptyKeyValueFieldArrayRowsParams<
TRow extends Record<string, unknown>,
TKeyFieldName extends Extract<keyof TRow, string>,
TValueFieldName extends Extract<keyof TRow, string>,
> = {
rows: TRow[]
keyFieldName: TKeyFieldName
valueFieldName: TValueFieldName
}
/**
* Removes fully empty draft rows before persisting field-array values.
*/
export const stripEmptyKeyValueFieldArrayRows = <
TRow extends Record<string, unknown>,
TKeyFieldName extends Extract<keyof TRow, string>,
TValueFieldName extends Extract<keyof TRow, string>,
>({
rows,
keyFieldName,
valueFieldName,
}: StripEmptyKeyValueFieldArrayRowsParams<TRow, TKeyFieldName, TValueFieldName>) =>
rows.filter((row) => {
const key = getTrimmedString(row[keyFieldName])
const value = getTrimmedString(row[valueFieldName])
return key.length > 0 || value.length > 0
})
/**
* Returns per-cell validation issues for draft-friendly key/value rows.
*
* Consumers should feed these issues into their resolver schema, typically via
* `zod.superRefine(...)`, so validation stays declarative and local to the form.
*/
export const getKeyValueFieldArrayValidationIssues = <
TRow extends Record<string, unknown>,
TKeyFieldName extends Extract<keyof TRow, string>,
TValueFieldName extends Extract<keyof TRow, string>,
>({
rows,
keyFieldName,
valueFieldName,
keyRequiredMessage,
valueRequiredMessage,
duplicateKeyMessage,
allowEmptyRows = true,
normaliseKey = (key) => key,
}: GetKeyValueFieldArrayValidationIssuesParams<TRow, TKeyFieldName, TValueFieldName>) => {
const issues: KeyValueFieldArrayValidationIssue<TKeyFieldName | TValueFieldName>[] = []
const rowIndexesByKey = duplicateKeyMessage ? new Map<string, number[]>() : null
rows.forEach((row, index) => {
const key = getTrimmedString(row[keyFieldName])
const value = getTrimmedString(row[valueFieldName])
if (!key && !value) {
if (!allowEmptyRows) {
issues.push({ path: [index, keyFieldName], message: keyRequiredMessage })
issues.push({ path: [index, valueFieldName], message: valueRequiredMessage })
}
return
}
if (!key) {
issues.push({ path: [index, keyFieldName], message: keyRequiredMessage })
return
}
if (!value) {
issues.push({ path: [index, valueFieldName], message: valueRequiredMessage })
return
}
if (!rowIndexesByKey) return
const normalisedKey = normaliseKey(key)
if (!normalisedKey) return
rowIndexesByKey.set(normalisedKey, [...(rowIndexesByKey.get(normalisedKey) ?? []), index])
})
if (!rowIndexesByKey || !duplicateKeyMessage) return issues
rowIndexesByKey.forEach((indexes) => {
if (indexes.length < 2) return
indexes.forEach((index) => {
issues.push({
path: [index, keyFieldName],
message: duplicateKeyMessage,
})
})
})
return issues
}