Skip to content

Open-source Grok Bot alternative for named AI teammates. Local-first desktop, web, and mobile clients with per-bot tools, instructions, and memory. Independent fork of T3 Code.

12.2 KB
Raw Blame
/**
 * MigrationsLive - Migration runner with inline loader
 *
 * Uses Migrator.make with fromRecord to define migrations inline.
 * All migrations are statically imported - no dynamic file system loading.
 *
 * Migrations run automatically when the MigrationLayer is provided,
 * ensuring the database schema is always up-to-date before the application starts.
 */

import * as Migrator from "effect/unstable/sql/Migrator";
import * as Effect from "effect/Effect";
import * as Layer from "effect/Layer";

// Import all migrations statically
import Migration0001 from "./Migrations/001_OrchestrationEvents.ts";
import Migration0002 from "./Migrations/002_OrchestrationCommandReceipts.ts";
import Migration0003 from "./Migrations/003_CheckpointDiffBlobs.ts";
import Migration0004 from "./Migrations/004_ProviderSessionRuntime.ts";
import Migration0005 from "./Migrations/005_Projections.ts";
import Migration0006 from "./Migrations/006_ProjectionThreadSessionRuntimeModeColumns.ts";
import Migration0007 from "./Migrations/007_ProjectionThreadMessageAttachments.ts";
import Migration0008 from "./Migrations/008_ProjectionThreadActivitySequence.ts";
import Migration0009 from "./Migrations/009_ProviderSessionRuntimeMode.ts";
import Migration0010 from "./Migrations/010_ProjectionThreadsRuntimeMode.ts";
import Migration0011 from "./Migrations/011_OrchestrationThreadCreatedRuntimeMode.ts";
import Migration0012 from "./Migrations/012_ProjectionThreadsInteractionMode.ts";
import Migration0013 from "./Migrations/013_ProjectionThreadProposedPlans.ts";
import Migration0014 from "./Migrations/014_ProjectionThreadProposedPlanImplementation.ts";
import Migration0015 from "./Migrations/015_ProjectionTurnsSourceProposedPlan.ts";
import Migration0016 from "./Migrations/016_CanonicalizeModelSelections.ts";
import Migration0017 from "./Migrations/017_ProjectionThreadsArchivedAt.ts";
import Migration0018 from "./Migrations/018_ProjectionThreadsArchivedAtIndex.ts";
import Migration0019 from "./Migrations/019_ProjectionSnapshotLookupIndexes.ts";
import Migration0020 from "./Migrations/020_AuthAccessManagement.ts";
import Migration0021 from "./Migrations/021_AuthSessionClientMetadata.ts";
import Migration0022 from "./Migrations/022_AuthSessionLastConnectedAt.ts";
import Migration0023 from "./Migrations/023_ProjectionThreadShellSummary.ts";
import Migration0024 from "./Migrations/024_BackfillProjectionThreadShellSummary.ts";
import Migration0025 from "./Migrations/025_CleanupInvalidProjectionPendingApprovals.ts";
import Migration0026 from "./Migrations/026_CanonicalizeModelSelectionOptions.ts";
import Migration0027 from "./Migrations/027_ProviderSessionRuntimeInstanceId.ts";
import Migration0028 from "./Migrations/028_ProjectionThreadSessionInstanceId.ts";
import Migration0029 from "./Migrations/029_ProjectionThreadDetailOrderingIndexes.ts";
import Migration0030 from "./Migrations/030_ProjectionThreadShellArchiveIndexes.ts";
import Migration0031 from "./Migrations/031_AuthAuthorizationScopes.ts";
import Migration0032 from "./Migrations/032_AuthPairingProofKeyThumbprint.ts";
import Migration0033 from "./Migrations/033_ProjectionThreadsSettled.ts";
import Migration0034 from "./Migrations/034_ProjectionThreadsSnoozed.ts";
import Migration0035 from "./Migrations/035_ProjectionThreadTitleRegeneration.ts";
import Migration0036 from "./Migrations/036_ProjectionThreadsPinned.ts";
import Migration0037 from "./Migrations/037_ProjectionTurnsKeysetIndex.ts";
import Migration0038 from "./Migrations/038_ProjectionThreadsPinOrderKey.ts";
import Migration0039 from "./Migrations/039_ProjectionProjectsDefaultThreadEnvMode.ts";
import Migration0040 from "./Migrations/040_ProjectionProjectFaviconPath.ts";
import Migration0041 from "./Migrations/041_AuthSessionClientConnection.ts";
import Migration0042 from "./Migrations/042_ProjectionThreadLinkedPullRequest.ts";
import Migration0043 from "./Migrations/043_ProjectionThreadsUnsettledAt.ts";
import Migration0044 from "./Migrations/044_LinkedPullRequestAndAuthSessionClientColumns.ts";
import Migration0045 from "./Migrations/045_ProjectionBotsAndGroups.ts";
import Migration0046 from "./Migrations/046_ProjectionThreadOwnership.ts";
import Migration0047 from "./Migrations/047_ProjectionMcpServers.ts";
import Migration0048 from "./Migrations/048_GroupMembershipAndRespondingBots.ts";
import Migration0049 from "./Migrations/049_BotRuntimeModeAndUsageCap.ts";
import Migration0050 from "./Migrations/050_BotProfileMetadata.ts";
import Migration0051 from "./Migrations/051_BotDisabledMcpServers.ts";
import Migration0052 from "./Migrations/052_ExecutorPluginCommand.ts";
import Migration0053 from "./Migrations/053_BotVoiceEnabled.ts";
import Migration0054 from "./Migrations/054_AkeruEntityMemory.ts";
import Migration0055 from "./Migrations/055_AkeruMemoryCandidates.ts";
import Migration0056 from "./Migrations/056_AkeruBotUsageLedger.ts";
import Migration0057 from "./Migrations/057_AkeruMemoryCandidateUpdates.ts";
import Migration0058 from "./Migrations/058_ProjectionDelegations.ts";
import Migration0059 from "./Migrations/059_ProjectionThreadSessionMcpServers.ts";
import Migration0060 from "./Migrations/060_ProjectionMessageReactions.ts";
import Migration0061 from "./Migrations/061_ExternalChannels.ts";
import Migration0062 from "./Migrations/062_Routines.ts";
import Migration0063 from "./Migrations/063_RoutineTargetThreadRepair.ts";
import Migration0064 from "./Migrations/064_ExternalChannelProviders.ts";
import Migration0065 from "./Migrations/065_ProjectionThreadUserInputLifecycleIndex.ts";
import Migration0066 from "./Migrations/066_BotPersonalityTone.ts";
import Migration0067 from "./Migrations/067_BotImageProvider.ts";
import Migration0068 from "./Migrations/068_AkeruBotUsageCacheTokens.ts";
import Migration0069 from "./Migrations/069_ProjectionThreadParentLinks.ts";
import Migration0070 from "./Migrations/070_McpServerInstructions.ts";
import Migration0071 from "./Migrations/071_RoutineDelegateToBot.ts";
import Migration0072 from "./Migrations/072_ProjectionThreadMessageChannelDelivery.ts";
import Migration0073 from "./Migrations/073_RoutineCanceledClaims.ts";

/**
 * Migration loader with all migrations defined inline.
 *
 * Key format: "{id}_{name}" where:
 * - id: numeric migration ID (determines execution order)
 * - name: descriptive name for the migration
 *
 * Uses Migrator.fromRecord which parses the key format and
 * returns migrations sorted by ID.
 */
export const migrationEntries = [
  [1, "OrchestrationEvents", Migration0001],
  [2, "OrchestrationCommandReceipts", Migration0002],
  [3, "CheckpointDiffBlobs", Migration0003],
  [4, "ProviderSessionRuntime", Migration0004],
  [5, "Projections", Migration0005],
  [6, "ProjectionThreadSessionRuntimeModeColumns", Migration0006],
  [7, "ProjectionThreadMessageAttachments", Migration0007],
  [8, "ProjectionThreadActivitySequence", Migration0008],
  [9, "ProviderSessionRuntimeMode", Migration0009],
  [10, "ProjectionThreadsRuntimeMode", Migration0010],
  [11, "OrchestrationThreadCreatedRuntimeMode", Migration0011],
  [12, "ProjectionThreadsInteractionMode", Migration0012],
  [13, "ProjectionThreadProposedPlans", Migration0013],
  [14, "ProjectionThreadProposedPlanImplementation", Migration0014],
  [15, "ProjectionTurnsSourceProposedPlan", Migration0015],
  [16, "CanonicalizeModelSelections", Migration0016],
  [17, "ProjectionThreadsArchivedAt", Migration0017],
  [18, "ProjectionThreadsArchivedAtIndex", Migration0018],
  [19, "ProjectionSnapshotLookupIndexes", Migration0019],
  [20, "AuthAccessManagement", Migration0020],
  [21, "AuthSessionClientMetadata", Migration0021],
  [22, "AuthSessionLastConnectedAt", Migration0022],
  [23, "ProjectionThreadShellSummary", Migration0023],
  [24, "BackfillProjectionThreadShellSummary", Migration0024],
  [25, "CleanupInvalidProjectionPendingApprovals", Migration0025],
  [26, "CanonicalizeModelSelectionOptions", Migration0026],
  [27, "ProviderSessionRuntimeInstanceId", Migration0027],
  [28, "ProjectionThreadSessionInstanceId", Migration0028],
  [29, "ProjectionThreadDetailOrderingIndexes", Migration0029],
  [30, "ProjectionThreadShellArchiveIndexes", Migration0030],
  [31, "AuthAuthorizationScopes", Migration0031],
  [32, "AuthPairingProofKeyThumbprint", Migration0032],
  [33, "ProjectionThreadsSettled", Migration0033],
  [34, "ProjectionThreadsSnoozed", Migration0034],
  [35, "ProjectionThreadTitleRegeneration", Migration0035],
  [36, "ProjectionThreadsPinned", Migration0036],
  [37, "ProjectionTurnsKeysetIndex", Migration0037],
  [38, "ProjectionThreadsPinOrderKey", Migration0038],
  [39, "ProjectionProjectsDefaultThreadEnvMode", Migration0039],
  [40, "ProjectionProjectFaviconPath", Migration0040],
  [41, "AuthSessionClientConnection", Migration0041],
  [42, "ProjectionThreadLinkedPullRequest", Migration0042],
  [43, "ProjectionThreadsUnsettledAt", Migration0043],
  [44, "LinkedPullRequestAndAuthSessionClientColumns", Migration0044],
  [45, "ProjectionBotsAndGroups", Migration0045],
  [46, "ProjectionThreadOwnership", Migration0046],
  [47, "ProjectionMcpServers", Migration0047],
  [48, "GroupMembershipAndRespondingBots", Migration0048],
  [49, "BotRuntimeModeAndUsageCap", Migration0049],
  [50, "BotProfileMetadata", Migration0050],
  [51, "BotDisabledMcpServers", Migration0051],
  [52, "ExecutorPluginCommand", Migration0052],
  [53, "BotVoiceEnabled", Migration0053],
  [54, "AkeruEntityMemory", Migration0054],
  [55, "AkeruMemoryCandidates", Migration0055],
  [56, "AkeruBotUsageLedger", Migration0056],
  [57, "AkeruMemoryCandidateUpdates", Migration0057],
  [58, "ProjectionDelegations", Migration0058],
  [59, "ProjectionThreadSessionMcpServers", Migration0059],
  [60, "ProjectionMessageReactions", Migration0060],
  [61, "ExternalChannels", Migration0061],
  [62, "Routines", Migration0062],
  [63, "RoutineTargetThreadRepair", Migration0063],
  [64, "ExternalChannelProviders", Migration0064],
  [65, "ProjectionThreadUserInputLifecycleIndex", Migration0065],
  [66, "BotPersonalityTone", Migration0066],
  [67, "BotImageProvider", Migration0067],
  [68, "AkeruBotUsageCacheTokens", Migration0068],
  [69, "ProjectionThreadParentLinks", Migration0069],
  [70, "McpServerInstructions", Migration0070],
  [71, "RoutineDelegateToBot", Migration0071],
  [72, "ProjectionThreadMessageChannelDelivery", Migration0072],
  [73, "RoutineCanceledClaims", Migration0073],
] as const;

export const migrationManifest = migrationEntries.map(([id, name]) => [id, name] as const);

export const makeMigrationLoader = (throughId?: number) =>
  Migrator.fromRecord(
    Object.fromEntries(
      migrationEntries.flatMap(([id, name, migration]) =>
        throughId === undefined || id <= throughId ? [[`${id}_${name}`, migration]] : [],
      ),
    ),
  );

/**
 * Migrator run function - no schema dumping needed
 * Uses the base Migrator.make without platform dependencies
 */
const run = Migrator.make({});

export interface RunMigrationsOptions {
  readonly toMigrationInclusive?: number | undefined;
}

/**
 * Run all pending migrations.
 *
 * Creates the migrations tracking table (effect_sql_migrations) if it doesn't exist,
 * then runs any migrations with ID greater than the latest recorded migration.
 *
 * Returns array of [id, name] tuples for migrations that were run.
 *
 * @returns Effect containing array of executed migrations
 */
export const runMigrations = Effect.fn("runMigrations")(function* ({
  toMigrationInclusive,
}: RunMigrationsOptions = {}) {
  const executedMigrations = yield* run({ loader: makeMigrationLoader(toMigrationInclusive) });
  const migrations = executedMigrations.map(([id, name]) => `${id}_${name}`);
  yield* migrations.length === 0
    ? Effect.logDebug("Database schema is current")
    : Effect.log("Migrations ran successfully").pipe(Effect.annotateLogs({ migrations }));

  return executedMigrations;
});

/**
 * Layer that runs migrations when the layer is built.
 *
 * Use this to ensure migrations run before your application starts.
 * Migrations are run automatically - no separate script is needed.
 *
 * @example
 * ```typescript
 * import { MigrationsLive } from "@acme/db/Migrations"
 * import * as SqliteClient from "@acme/db/SqliteClient"
 *
 * // Migrations run automatically when SqliteClient is provided
 * const AppLayer = MigrationsLive.pipe(
 *   Layer.provideMerge(SqliteClient.layer({ filename: "database.sqlite" }))
 * )
 * ```
 */
export const MigrationsLive = Layer.effectDiscard(runMigrations());