Skip to content

OpenPanel is an open-source web and product analytics platform, an open-source alternative to Mixpanel with optional self-hosting.

1.2 KB
Raw Blame
// core keeps its own copies of @openpanel/db's ClickHouse date helpers; a
// divergence would show up as silently wrong date literals in a query.

import { describe, expect, it } from 'bun:test';
import * as dbClient from '@openpanel/db/src/clickhouse/client';
import { convertClickhouseDateToJs, formatClickhouseDate } from './ch-dates';

const CASES = [
  new Date('2026-09-06T12:34:56.789Z'),
  new Date('2026-01-01T00:00:00.000Z'),
  new Date('1970-01-01T00:00:00.000Z'),
  '2026-09-06T23:59:59.999Z',
  '2026-02-28 08:00:00',
];

describe('ch-dates parity with @openpanel/db', () => {
  it('formats identically, with and without skipTime', () => {
    for (const input of CASES) {
      expect(formatClickhouseDate(input)).toBe(
        dbClient.formatClickhouseDate(input)
      );
      expect(formatClickhouseDate(input, true)).toBe(
        dbClient.formatClickhouseDate(input, true)
      );
    }
  });

  it('parses identically', () => {
    for (const input of CASES) {
      const formatted = formatClickhouseDate(input);
      expect(convertClickhouseDateToJs(formatted).toISOString()).toBe(
        dbClient.convertClickhouseDateToJs(formatted).toISOString()
      );
    }
  });
});