mirror of
https://github.com/ruvnet/RuVector.git
synced 2026-05-24 05:43:58 +00:00
814f595995
Major additions: - Complete Next.js studio application with 1600+ components - Docker support (Dockerfile.combined, docker-compose.yml) - GCP deployment documentation and benchmarks - SQL benchmark scripts for performance testing - Sentry integration for monitoring - Comprehensive test suite and mocks Studio features: - Dashboard and admin interfaces - Data visualization components - Authentication and user management - API integration with RuVector backend - Static data and public assets 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
77 lines
2.7 KiB
TypeScript
77 lines
2.7 KiB
TypeScript
import { describe, it, expect } from 'vitest'
|
|
import { parseParameters, processParameterizedSql } from './sql-parameters'
|
|
|
|
describe('parseParameters', () => {
|
|
it('parses simple :param without @set', () => {
|
|
const result = parseParameters('SELECT * FROM table WHERE id = :userId')
|
|
expect(result).toEqual([
|
|
{
|
|
name: 'userId',
|
|
value: '',
|
|
defaultValue: undefined,
|
|
type: undefined,
|
|
possibleValues: undefined,
|
|
occurrences: 1,
|
|
},
|
|
])
|
|
})
|
|
|
|
it('parses @set with type and value', () => {
|
|
const result = parseParameters('@set userId:int = 123\nSELECT * FROM table WHERE id = :userId')
|
|
|
|
const userIdParam = result.find((p) => p.name === 'userId')
|
|
expect(userIdParam?.defaultValue).toBe('123')
|
|
expect(userIdParam?.type).toBe('int')
|
|
})
|
|
|
|
it('parses union type', () => {
|
|
const result = parseParameters(
|
|
'@set status:open|closed = open\nSELECT * FROM users WHERE status = :status'
|
|
)
|
|
|
|
const statusParam = result.find((p) => p.name === 'status')
|
|
expect(statusParam?.type).toBe('enum')
|
|
expect(statusParam?.possibleValues).toEqual(['open', 'closed'])
|
|
})
|
|
|
|
it('counts multiple occurrences', () => {
|
|
const result = parseParameters('SELECT * FROM table WHERE id = :userId OR owner_id = :userId')
|
|
|
|
const userIdParam = result.find((p) => p.name === 'userId')
|
|
expect(userIdParam?.occurrences).toBe(2)
|
|
})
|
|
})
|
|
|
|
describe('processParameterizedSql', () => {
|
|
it('replaces :param with value from parameters', () => {
|
|
const sql = 'SELECT * FROM users WHERE id = :userId'
|
|
const result = processParameterizedSql(sql, { userId: '42' })
|
|
expect(result).toBe('SELECT * FROM users WHERE id = 42')
|
|
})
|
|
|
|
it('uses default from @set if param not provided', () => {
|
|
const sql = '@set userId:int = 123\nSELECT * FROM users WHERE id = :userId'
|
|
const result = processParameterizedSql(sql, {})
|
|
expect(result).toBe('SELECT * FROM users WHERE id = 123')
|
|
})
|
|
|
|
it('overrides @set default if param is provided', () => {
|
|
const sql = '@set userId:int = 123\nSELECT * FROM users WHERE id = :userId'
|
|
const result = processParameterizedSql(sql, { userId: '999' })
|
|
expect(result).toBe('SELECT * FROM users WHERE id = 999')
|
|
})
|
|
|
|
it('throws if no param value is provided and no default exists', () => {
|
|
const sql = 'SELECT * FROM users WHERE id = :userId'
|
|
expect(() => processParameterizedSql(sql, {})).toThrowError(
|
|
'Missing value for parameter: userId'
|
|
)
|
|
})
|
|
|
|
it('removes @set lines from final SQL', () => {
|
|
const sql = '@set status:open|closed = open\nSELECT * FROM items WHERE status = :status'
|
|
const result = processParameterizedSql(sql, {})
|
|
expect(result).toBe('SELECT * FROM items WHERE status = open')
|
|
expect(result).not.toContain('@set')
|
|
})
|
|
})
|