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 {
AUTH_TOP_ERROR_CODES_SQL_OTEL,
AUTH_TOP_RESPONSE_ERRORS_SQL_OTEL,
parseAuthErrorCodes,
parseResponseErrors,
} from '@/components/interfaces/Auth/Overview/OverviewErrors.constants'
describe('Auth overview ClickHouse queries', () => {
it('filters gateway failures and preserves the nested error header path', () => {
expect(AUTH_TOP_RESPONSE_ERRORS_SQL_OTEL).toContain("source = 'edge_logs'")
expect(AUTH_TOP_RESPONSE_ERRORS_SQL_OTEL).toContain('status_code between 400 and 599')
expect(AUTH_TOP_ERROR_CODES_SQL_OTEL).toContain('response.headers.x_sb_error_code')
expect(AUTH_TOP_ERROR_CODES_SQL_OTEL).toContain("error_code != ''")
for (const sql of [AUTH_TOP_ERROR_CODES_SQL_OTEL, AUTH_TOP_RESPONSE_ERRORS_SQL_OTEL]) {
expect(sql).toContain('count()')
expect(sql).toContain('limit 10')
expect(sql).not.toContain('unnest')
}
})
it('accepts ClickHouse string counts and legacy numeric counts', () => {
expect(
parseAuthErrorCodes([
{ error_code: 'bad_jwt', count: '12' },
{ error_code: 'expired', count: 3 },
])
).toEqual([
{ error_code: 'bad_jwt', count: 12 },
{ error_code: 'expired', count: 3 },
])
expect(
parseResponseErrors([
{ method: 'GET', path: '/auth/v1/user', status_code: '401', count: '4' },
])
).toEqual([{ method: 'GET', path: '/auth/v1/user', status_code: 401, count: 4 }])
})
it('drops malformed rows and counts', () => {
expect(
parseAuthErrorCodes([
null,
{},
{ error_code: 'error', count: 'oops' },
{ error_code: 'error', count: null },
])
).toEqual([])
expect(
parseResponseErrors([
null,
{},
{ method: 'GET', path: '/', status_code: 401, count: Infinity },
])
).toEqual([])
})
})