Skip to content

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

1.4 KB
Raw Blame
import { TABLE_NAMES } from '../clickhouse/client';
import {
  addColumns,
  createTable,
  runClickhouseMigrationCommands,
} from '../clickhouse/migration';
import { type CodeMigrationEnv, getIsCluster, writeSqlDump } from './helpers';

export async function up(env: CodeMigrationEnv) {
  const isClustered = getIsCluster(env);

  const sqls: string[] = [
    ...addColumns(
      'events',
      ['`groups` Array(String) DEFAULT [] CODEC(ZSTD(3)) AFTER session_id'],
      isClustered
    ),
    ...addColumns(
      'sessions',
      ['`groups` Array(String) DEFAULT [] CODEC(ZSTD(3)) AFTER device_id'],
      isClustered
    ),
    ...addColumns(
      'profiles',
      ['`groups` Array(String) DEFAULT [] CODEC(ZSTD(3)) AFTER project_id'],
      isClustered
    ),
    ...createTable({
      name: TABLE_NAMES.groups,
      columns: [
        '`id` String',
        '`project_id` String',
        '`type` String',
        '`name` String',
        '`properties` Map(String, String)',
        '`created_at` DateTime',
        '`version` UInt64',
        '`deleted` UInt8 DEFAULT 0',
      ],
      engine: 'ReplacingMergeTree(version, deleted)',
      orderBy: ['project_id', 'id'],
      distributionHash: 'cityHash64(project_id, id)',
      replicatedVersion: '1',
      isClustered,
    }),
  ];

  writeSqlDump(import.meta.url, sqls);

  if (!process.argv.includes('--dry')) {
    await runClickhouseMigrationCommands(sqls);
  }
}