Database

pnpm dev

docker compose up --build -d

docker compose --profile tools run --rm psql

services:
  db:
    ports:
      - "5432:5432"

# Either export it for the session:
export DATABASE_URL=postgres://aoa:aoa@localhost:5432/aoa
# …or write it into the AoA config dir's .env (NOT the repo root):
#   ~/.aoa/instances/default/.env

DATABASE_URL=postgres://aoa:aoa@localhost:5432/aoa \
  npx drizzle-kit push

INSERT INTO instance_settings (singleton_key, general)
VALUES ('default', '{"migrationSnapshots":["0188"]}'::jsonb)
ON CONFLICT (singleton_key) DO UPDATE
SET general = jsonb_set(
      instance_settings.general,
      '{migrationSnapshots}',
      (
        SELECT CASE
          WHEN cleaned.markers @> '["0188"]'::jsonb THEN cleaned.markers
          ELSE cleaned.markers || '["0188"]'::jsonb
        END
        FROM (
          SELECT COALESCE(jsonb_agg(candidate.marker), '[]'::jsonb) AS markers
          FROM jsonb_array_elements(
            CASE
              WHEN jsonb_typeof(instance_settings.general->'migrationSnapshots') = 'array'
                THEN instance_settings.general->'migrationSnapshots'
              ELSE '[]'::jsonb
            END
          ) AS candidate(marker)
          WHERE jsonb_typeof(candidate.marker) = 'string'
        ) AS cleaned
      ),
      true
    ),
    updated_at = now();

SELECT general->'migrationSnapshots' AS migration_snapshots
FROM instance_settings
WHERE singleton_key = 'default';

BEGIN;

SELECT id, provider, status, provider_ref, process_owner_id, started_at
FROM workspace_runtime_services
WHERE id IN ('00000000-0000-0000-0000-000000000000')
FOR UPDATE;

-- Continue only after every listed PID/process group is confirmed absent on
-- its original host. Otherwise ROLLBACK and remediate the OS process first.
UPDATE workspace_runtime_services
SET provider_ref = NULL,
    process_owner_id = NULL,
    status = 'stopped',
    health_status = 'unknown',
    stopped_at = now(),
    last_used_at = now(),
    updated_at = now()
WHERE id IN ('00000000-0000-0000-0000-000000000000')
  AND provider = 'local_process';

COMMIT;

// packages/db/src/client.ts
export function createDb(url: string) {
  const sql = postgres(url, { prepare: false });
  return drizzlePg(sql, { schema });
}