import assert from 'node:assert/strict';
import test from 'node:test';

import {
  buildContainerPgConnectionString,
  buildPgConnectionString,
  makeIsolatedDatabaseName,
} from './local-stack.mjs';

test('isolated database names are bounded and identifier-safe', () => {
  const name = makeIsolatedDatabaseName('Gate 2026-07-26 / ABC', 'memind_gate');
  assert.equal(name, 'memind_gate_gate_2026_07_26_abc');
  assert.match(name, /^[a-z][a-z0-9_]+$/);
  assert.ok(name.length <= 63);
});

test('PostgreSQL Unix socket DSN is preserved while database is isolated', () => {
  const dsn = buildPgConnectionString(
    'postgresql://gate:secret@localhost/base?host=%2Ftmp&port=5433',
    'mindspace_gate_abc',
  );
  const parsed = new URL(dsn);
  assert.equal(parsed.pathname, '/mindspace_gate_abc');
  assert.equal(parsed.searchParams.get('host'), '/tmp');
  assert.equal(parsed.searchParams.get('port'), '5433');
});

test('container PostgreSQL DSN keeps credentials and host while isolating database', () => {
  const dsn = buildContainerPgConnectionString(
    'postgresql://john:secret@host.docker.internal:5433/mindspace_userdata_dev',
    'mindspace_gate_abc',
  );
  const parsed = new URL(dsn);
  assert.equal(parsed.hostname, 'host.docker.internal');
  assert.equal(parsed.port, '5433');
  assert.equal(parsed.username, 'john');
  assert.equal(parsed.password, 'secret');
  assert.equal(parsed.pathname, '/mindspace_gate_abc');
});

test('isolated database names reject empty or unsafe prefixes', () => {
  assert.throws(() => makeIsolatedDatabaseName('abc', '../bad'), /Unsafe/);
});