migration.ts · part 1

14 text occurrences from packages/core/src/database/migration.ts, part 1. Every entry preserves the shipped literal and its saved verdict or selection reason.

File contents and all parts · All files

SELECT name FROM sqlite_master WHERE type = 'table' AND name NOT LIKE 'sqlite_%'

Database is not empty and has no session table

CREATE TABLE ${sql.identifier("migration")} (id TEXT PRIMARY KEY, time_completed INTEGER NOT NULL)

INSERT INTO ${sql.identifier("migration")} (id, time_completed) VALUES (${migration.id}, ${Date.now()})

CREATE TABLE IF NOT EXISTS ${sql.identifier("migration")} (id TEXT PRIMARY KEY, time_completed INTEGER NOT NULL)

SELECT id FROM ${sql.identifier("migration")}

SELECT name FROM sqlite_master WHERE type = 'table' AND name = ${"__drizzle_migrations"}

SELECT name FROM pragma_table_info('__drizzle_migrations')

            INSERT OR IGNORE INTO ${sql.identifier("migration")} (id, time_completed)
            SELECT name, ${Date.now()}
            FROM ${sql.identifier("__drizzle_migrations")}
            WHERE name IS NOT NULL
          

            SELECT created_at, strftime('%Y%m%d%H%M%S', created_at / 1000, 'unixepoch') AS prefix
            FROM ${sql.identifier("__drizzle_migrations")}
            WHERE created_at IS NOT NULL
          

Legacy migration timestamp ${entry.created_at} does not match any known migration

              INSERT OR IGNORE INTO ${sql.identifier("migration")} (id, time_completed)
              VALUES (${migration.id}, ${Date.now()})
            

SELECT id FROM ${sql.identifier("migration")}

INSERT INTO ${sql.identifier("migration")} (id, time_completed) VALUES (${migration.id}, ${Date.now()})