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 type { AdvisorSignalItem } from './AdvisorPanel.types'
import {
createAdvisorLintItems,
createAdvisorNotificationItems,
getAdvisorItemSecondaryText,
getAdvisorItemTelemetryCategory,
sortAdvisorItems,
} from './AdvisorPanel.utils'
import type { Lint } from '@/data/lint/lint-query'
import type { Notification } from '@/data/notifications/notifications-v2-query'
const createLint = (overrides: Partial<Lint> = {}): Lint =>
({
cache_key: 'lint-1',
name: 'unknown_lint',
detail: 'Critical lint detail',
level: 'ERROR',
categories: ['SECURITY'],
metadata: {},
...overrides,
}) as Lint
const createNotification = (overrides: Partial<Notification> = {}): Notification =>
({
id: 'notification-1',
inserted_at: '2026-03-01T00:00:00.000Z',
priority: 'Info',
status: 'seen',
data: {
title: 'Notification title',
message: 'Notification body',
actions: [],
},
...overrides,
}) as Notification
const createBannedIPSignalItem = (ip: string): AdvisorSignalItem => ({
id: `signal:banned-ip:${ip}:v1`,
dismissalKey: `signal:banned-ip:${ip}:v1`,
source: 'signal',
type: 'banned-ip',
severity: 'warning',
category: 'security',
title: 'Banned IP address',
summary: `The IP address \`${ip}\` is temporarily blocked.`,
docsUrl: 'https://supabase.com/docs/reference/cli/supabase-network-bans',
actions: [],
sourceData: { type: 'banned-ip', ip },
})
describe('AdvisorPanel.utils', () => {
it('orders mixed lint, signal and notification items by severity and recency', () => {
const lintItems = createAdvisorLintItems([
createLint({ cache_key: 'lint-critical', detail: 'Critical lint detail' }),
])
const signalItems = [createBannedIPSignalItem('203.0.113.10')]
const notificationItems = createAdvisorNotificationItems([
createNotification({
id: 'notification-info',
data: { title: 'Notification title', message: 'Body', actions: [] },
}),
])
const sorted = sortAdvisorItems([...notificationItems, ...signalItems, ...lintItems])
expect(sorted.map((item) => item.source)).toEqual(['lint', 'signal', 'notification'])
})
it('uses database surface-area metadata and the IP address for banned IP signals', () => {
const bannedIpSignal = createBannedIPSignalItem('203.0.113.10')
expect(getAdvisorItemSecondaryText(bannedIpSignal)).toBe('Database · 203.0.113.10')
})
describe('lint categories', () => {
it('files a health lint under the health category', () => {
const [item] = createAdvisorLintItems([
createLint({
cache_key: 'instance_db_down',
name: 'instance_db_down',
categories: ['HEALTH'],
metadata: { type: 'health', entity: 'Database' },
}),
])
expect(item?.category).toBe('health')
expect(getAdvisorItemTelemetryCategory(item!)).toBe('HEALTH')
})
it('keeps security ahead of health when a lint carries both categories', () => {
const [item] = createAdvisorLintItems([
createLint({ cache_key: 'both', categories: ['HEALTH', 'SECURITY'] }),
])
expect(item?.category).toBe('security')
expect(getAdvisorItemTelemetryCategory(item!)).toBe('SECURITY')
})
it('drops lints with no recognised category', () => {
expect(
createAdvisorLintItems([createLint({ categories: [] as Lint['categories'] })])
).toEqual([])
})
})
describe('notification secondary text', () => {
const [notificationWithProject] = createAdvisorNotificationItems([
createNotification({
id: 'notification-with-project',
data: {
title: 'CPU usage is high on my-project.',
message: 'Project my-project has high CPU usage.',
project_ref: 'abcd1234',
actions: [],
},
}),
])
const [notificationWithoutProject] = createAdvisorNotificationItems([
createNotification({
id: 'notification-without-project',
data: { title: 'Generic notification', message: 'Body', actions: [] },
}),
])
it('returns the resolved project name when available in the map', () => {
const projectNameByRef = new Map([['abcd1234', 'my-production-db']])
expect(getAdvisorItemSecondaryText(notificationWithProject, projectNameByRef)).toBe(
'my-production-db'
)
})
it('falls back to the project ref when the name is missing from the map', () => {
expect(getAdvisorItemSecondaryText(notificationWithProject, new Map())).toBe('abcd1234')
})
it('falls back to the project ref when no map is provided', () => {
expect(getAdvisorItemSecondaryText(notificationWithProject)).toBe('abcd1234')
})
it('returns undefined for notifications without a project_ref', () => {
expect(getAdvisorItemSecondaryText(notificationWithoutProject)).toBeUndefined()
})
})
})