mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-13 08:15:14 +02:00
00cdf2de90
Align the tree with AGENTS.md/CLAUDE.md conventions: - Rewrite user-facing strings, docs, and tests to lowercase `ktx` (no bare uppercase `KTX` tokens remain outside literal identifiers). - Drop the legacy `historicSql` migration path and its now-unused helpers, per the no-backward-compat rule. - Remove `as unknown as` / `any` casts: narrow `BaseTool` generics to `z.ZodObject`, add a typed `createLookerClient`, and delete the dead `getParametersSchema`/`toAnthropicFormat` pre-AI-SDK helpers. - Use `InvalidArgumentError` for Commander parse failures. - Finish the adapter→connector prose conversion in the `ktx.yaml` docs while keeping the literal `adapters` config key.
39 lines
1.9 KiB
TypeScript
39 lines
1.9 KiB
TypeScript
import { describe, expect, it } from 'vitest';
|
|
import { KtxClickHouseDialect } from '../../../src/connectors/clickhouse/dialect.js';
|
|
|
|
describe('KtxClickHouseDialect', () => {
|
|
const dialect = new KtxClickHouseDialect();
|
|
|
|
it('quotes identifiers and formats database-qualified table names', () => {
|
|
expect(dialect.quoteIdentifier('events')).toBe('`events`');
|
|
expect(dialect.quoteIdentifier('odd`name')).toBe('`odd``name`');
|
|
expect(dialect.formatTableName({ catalog: null, db: 'analytics', name: 'events' })).toBe(
|
|
'`analytics`.`events`',
|
|
);
|
|
expect(dialect.formatTableName({ catalog: null, db: null, name: 'events' })).toBe('`events`');
|
|
});
|
|
|
|
it('maps nullable and low-cardinality ClickHouse types to ktx dimension types', () => {
|
|
expect(dialect.mapToDimensionType('Nullable(DateTime64(3))')).toBe('time');
|
|
expect(dialect.mapToDimensionType('LowCardinality(Nullable(String))')).toBe('string');
|
|
expect(dialect.mapToDimensionType('UInt64')).toBe('number');
|
|
expect(dialect.mapToDimensionType('Decimal(18, 4)')).toBe('number');
|
|
expect(dialect.mapToDimensionType('Bool')).toBe('boolean');
|
|
expect(dialect.mapToDimensionType('IPv4')).toBe('string');
|
|
expect(dialect.mapToDimensionType('')).toBe('string');
|
|
});
|
|
|
|
it('builds sampling, distinct-value, and pagination SQL', () => {
|
|
expect(dialect.generateSampleQuery('`analytics`.`events`', 25, ['id', 'event_name'])).toBe(
|
|
'SELECT `id`, `event_name` FROM `analytics`.`events` LIMIT 25',
|
|
);
|
|
expect(dialect.generateColumnSampleQuery('`analytics`.`events`', 'event_name', 10)).toBe(
|
|
"SELECT `event_name` FROM `analytics`.`events` WHERE `event_name` IS NOT NULL AND trim(toString(`event_name`)) != '' LIMIT 10",
|
|
);
|
|
expect(dialect.generateDistinctValuesQuery('`analytics`.`events`', '`event_name`', 5)).toContain(
|
|
'SELECT DISTINCT toString(`event_name`) AS val',
|
|
);
|
|
expect(dialect.getLimitOffsetClause(10, 20)).toBe('LIMIT 10 OFFSET 20');
|
|
});
|
|
|
|
});
|