The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { describe, expect, it } from 'vitest'
import { otelFieldsFromKeys, toOtelFieldSchemas, type LogFieldSchema } from './Logs.fieldReference'
const edgeSchema: LogFieldSchema = {
name: 'API Gateway',
reference: 'edge_logs',
fields: [
{ path: 'id', type: 'string' },
{ path: 'timestamp', type: 'datetime' },
{ path: 'event_message', type: 'string' },
{ path: 'identifier', type: 'string' },
{ path: 'metadata.request.method', type: 'string' },
{ path: 'metadata.request.cf.asn', type: 'number' },
],
}
describe('toOtelFieldSchemas', () => {
it('keeps source name and reference', () => {
const [otel] = toOtelFieldSchemas([edgeSchema])
expect(otel.name).toBe('API Gateway')
expect(otel.reference).toBe('edge_logs')
})
it('keeps id/timestamp/event_message as real columns and adds source + severity_text', () => {
const [otel] = toOtelFieldSchemas([edgeSchema])
const paths = otel.fields.map((f) => f.path)
expect(paths.slice(0, 5)).toEqual([
'id',
'timestamp',
'event_message',
'severity_text',
'source',
])
})
it('moves non-column fields into log_attributes, dropping the metadata root', () => {
const [otel] = toOtelFieldSchemas([edgeSchema])
const paths = otel.fields.map((f) => f.path)
expect(paths).toContain("log_attributes['identifier']")
expect(paths).toContain("log_attributes['request.method']")
expect(paths).toContain("log_attributes['request.cf.asn']")
expect(paths).not.toContain('metadata.request.method')
expect(paths).not.toContain('identifier')
})
it('preserves the original field type for casting hints', () => {
const [otel] = toOtelFieldSchemas([edgeSchema])
const asn = otel.fields.find((f) => f.path === "log_attributes['request.cf.asn']")
expect(asn?.type).toBe('number')
})
})
describe('otelFieldsFromKeys', () => {
it('starts with the five base OTEL columns', () => {
const fields = otelFieldsFromKeys(['request.cf.asn'])
const paths = fields.map((f) => f.path)
expect(paths.slice(0, 5)).toEqual([
'id',
'timestamp',
'event_message',
'severity_text',
'source',
])
})
it('maps discovered keys to log_attributes lookups', () => {
const fields = otelFieldsFromKeys(['request.cf.asn', 'response.headers.x-foo'])
const paths = fields.map((f) => f.path)
expect(paths).toContain("log_attributes['request.cf.asn']")
expect(paths).toContain("log_attributes['response.headers.x-foo']")
})
it('excludes keys that are real OTEL columns', () => {
const fields = otelFieldsFromKeys([
'id',
'timestamp',
'event_message',
'severity_text',
'source',
'trace_id',
])
const paths = fields.map((f) => f.path)
for (const column of ['id', 'timestamp', 'event_message', 'severity_text', 'source']) {
expect(paths.filter((p) => p === column)).toHaveLength(1)
expect(paths).not.toContain(`log_attributes['${column}']`)
}
expect(paths).toContain("log_attributes['trace_id']")
})
it('escapes quotes and backslashes in discovered keys', () => {
const fields = otelFieldsFromKeys(["weird'key", 'back\\slash'])
const paths = fields.map((f) => f.path)
expect(paths).toContain("log_attributes['weird''key']")
expect(paths).toContain("log_attributes['back\\\\slash']")
})
it('returns only base fields for an empty key list', () => {
const fields = otelFieldsFromKeys([])
expect(fields).toHaveLength(5)
})
})