The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { codeBlock } from 'common-tags'
import OpenAI from 'openai'
import { describe, expect, test } from 'vitest'
import { formatSql } from '../../test/util'
import { debugSql, titleSql } from './functions'
const openAiKey = process.env.OPENAI_API_KEY
const openai = new OpenAI({ apiKey: openAiKey })
describe('debug', () => {
test.concurrent('fix order of operations', async ({ expect }) => {
const { sql } = await debugSql(
openai,
'relation "departments" does not exist',
codeBlock`
create table employees (
id bigint primary key generated always as identity,
name text,
email text,
department_id bigint references departments (id)
);
create table departments (
id bigint primary key generated always as identity,
name text
);
`
)
expect(formatSql(sql)).toMatchSnapshot()
})
test.concurrent('fix typos', async ({ expect }) => {
const { sql, solution } = await debugSql(
openai,
'syntax error at or near "fromm"',
codeBlock`
select * fromm employees;
`
)
expect(solution).toBeDefined()
expect(formatSql(sql)).toMatchSnapshot()
})
})
describe('title', () => {
test('title matches content', async () => {
const { title, description } = await titleSql(
openai,
codeBlock`
create table employees (
id bigint primary key generated always as identity,
name text,
email text,
department_id bigint references departments (id)
);
create table departments (
id bigint primary key generated always as identity,
name text
);
`
)
await expect(title).toMatchCriteria('relates to employees and departments')
await expect(description).toMatchCriteria('describes employees and departments')
})
})