sqlite.ts · part 1

13 text occurrences from packages/effect-drizzle-sqlite/src/up-migrations/sqlite.ts, part 1. Every entry preserves the shipped literal and its saved verdict or selection reason.

File contents and all parts · All files

While upgrading your database migrations table we found ${unmatched.length} (${unmatched
      .map((it) => `[id: ${it.id}, created_at: ${it.created_at}]`)
      .join(
        ", ",
      )}) migrations in the database that do not match any local migration. This means that some migrations were applied to the database but are missing from the local environment

ALTER TABLE ${table} ADD COLUMN ${sql.identifier("name")} text

ALTER TABLE ${table} ADD COLUMN ${sql.identifier("applied_at")} TEXT

UPDATE ${table} SET ${sql.identifier("name")} = ${backfillEntry.name}, ${sql.identifier(
      "applied_at",
    )} = NULL WHERE

 ${sql.identifier(backfillEntry.selector.column)} = ${backfillEntry.selector.value}

SELECT 1 FROM sqlite_master WHERE type = 'table' AND name = ${migrationsTable}

SELECT name as column_name FROM pragma_table_info(${migrationsTable})

No upgrade path from migration table version ${v} to ${v + 1}

SELECT id, hash, created_at FROM ${table} ORDER BY id ASC

SELECT 1 FROM sqlite_master WHERE type = 'table' AND name = ${migrationsTable}

SELECT name as column_name FROM pragma_table_info(${migrationsTable})

No upgrade path from migration table version ${v} to ${v + 1}

SELECT id, hash, created_at FROM ${table} ORDER BY id ASC