wehub-resource-sync
64 lines
2.1 KiB
TypeScript
64 lines
2.1 KiB
TypeScript
import { convertSqlTypeToColumnType } from '../../src/utils/utils';
|
|
import { ColumnType } from '@insforge/shared-schemas';
|
|
import { describe, it, expect } from 'vitest';
|
|
describe('convertSqlTypeToColumnType', () => {
|
|
it('converts UUID correctly', () => {
|
|
expect(convertSqlTypeToColumnType('uuid')).toBe(ColumnType.UUID);
|
|
expect(convertSqlTypeToColumnType('UUID')).toBe(ColumnType.UUID);
|
|
});
|
|
|
|
it('converts timestamp types correctly', () => {
|
|
expect(convertSqlTypeToColumnType('timestamptz')).toBe(ColumnType.DATETIME);
|
|
expect(convertSqlTypeToColumnType('timestamp with time zone')).toBe(ColumnType.DATETIME);
|
|
});
|
|
|
|
it('converts integer types correctly', () => {
|
|
const integers = [
|
|
'integer',
|
|
'bigint',
|
|
'smallint',
|
|
'int',
|
|
'int2',
|
|
'int4',
|
|
'serial',
|
|
'serial2',
|
|
'serial4',
|
|
'serial8',
|
|
'smallserial',
|
|
'bigserial',
|
|
];
|
|
integers.forEach((type) => {
|
|
expect(convertSqlTypeToColumnType(type)).toBe(ColumnType.INTEGER);
|
|
});
|
|
});
|
|
|
|
it('converts float types correctly', () => {
|
|
const floats = ['double precision', 'real', 'numeric', 'float', 'float4', 'float8', 'decimal'];
|
|
floats.forEach((type) => {
|
|
expect(convertSqlTypeToColumnType(type)).toBe(ColumnType.FLOAT);
|
|
});
|
|
});
|
|
|
|
it('converts boolean types correctly', () => {
|
|
expect(convertSqlTypeToColumnType('boolean')).toBe(ColumnType.BOOLEAN);
|
|
expect(convertSqlTypeToColumnType('bool')).toBe(ColumnType.BOOLEAN);
|
|
});
|
|
|
|
it('converts JSON types correctly', () => {
|
|
expect(convertSqlTypeToColumnType('json')).toBe(ColumnType.JSON);
|
|
expect(convertSqlTypeToColumnType('jsonb')).toBe(ColumnType.JSON);
|
|
expect(convertSqlTypeToColumnType('array')).toBe(ColumnType.JSON);
|
|
});
|
|
|
|
it('converts string types correctly', () => {
|
|
const strings = ['text', 'varchar', 'char', 'character', 'character varying'];
|
|
strings.forEach((type) => {
|
|
expect(convertSqlTypeToColumnType(type)).toBe(ColumnType.STRING);
|
|
});
|
|
});
|
|
|
|
it('returns first 8 chars for unknown types', () => {
|
|
expect(convertSqlTypeToColumnType('customtype')).toBe('customty');
|
|
});
|
|
});
|