1import { defineTestSpec } from '@lssm-tech/lib.contracts-spec/tests';
2
3export const CreateQueryTest = defineTestSpec({
4	meta: {
5		key: 'analytics.query.create.test',
6		version: '1.0.0',
7		title: 'Create Query Test',
8		description: 'Verifies query creation flow',
9		owners: ['@example.analytics-dashboard'],
10		tags: ['analytics', 'query', 'test'],
11		stability: 'stable',
12	},
13	target: {
14		type: 'operation',
15		operation: { key: 'analytics.query.create', version: '1.0.0' },
16	},
17	scenarios: [
18		{
19			key: 'success',
20			description: 'Successfully create a query',
21			when: {
22				operation: { key: 'analytics.query.create', version: '1.0.0' },
23				input: {
24					name: 'Revenue Query',
25					sql: 'SELECT * FROM revenue',
26				},
27			},
28			then: [
29				{
30					type: 'expectOutput',
31					match: {
32						name: 'Revenue Query',
33						type: 'sql',
34					},
35				},
36			],
37		},
38		{
39			key: 'error-invalid-sql',
40			description: 'Fail with invalid SQL',
41			when: {
42				operation: { key: 'analytics.query.create', version: '1.0.0' },
43				input: {
44					name: 'Bad Query',
45					sql: '',
46				},
47			},
48			then: [
49				{
50					type: 'expectError',
51					messageIncludes: 'VALIDATION_ERROR',
52				},
53			],
54		},
55	],
56});