sailfork / t3code-github / apps/ server/ src/ persistence/ Migrations/ 077_RepairBooleanSettledOverride.ts

import * as Effect from "effect/Effect";
import * as SqlClient from "effect/sql/SqlClient";

// Thread projections may hold a boolean settledOverride, which the thread schema rejects.
export default Effect.gen(function* () {
  const sql = yield* SqlClient.SqlClient;
  yield* sql`
    UPDATE orchestration_v2_projection_threads
    SET payload_json = json_set(payload_json, '$.settledOverride',
      IIF(json_type(payload_json, '$.settledOverride') = 'true', 'settled', NULL))
    WHERE json_valid(payload_json)
      AND json_type(payload_json, '$.settledOverride') IN ('true', 'false')
  `;
});