32 lines
1.1 KiB
JavaScript
32 lines
1.1 KiB
JavaScript
import { readMigrationFiles } from "../migrator.js";
|
|
import { sql } from "../sql/sql.js";
|
|
async function migrate(db, callback, config) {
|
|
const migrations = readMigrationFiles(config);
|
|
const migrationTableCreate = sql`
|
|
CREATE TABLE IF NOT EXISTS "drizzle"."__drizzle_migrations" (
|
|
id SERIAL PRIMARY KEY,
|
|
hash text NOT NULL,
|
|
created_at numeric
|
|
)
|
|
`;
|
|
await db.execute(sql`CREATE SCHEMA IF NOT EXISTS "drizzle"`);
|
|
await db.execute(migrationTableCreate);
|
|
const dbMigrations = await db.execute(
|
|
sql`SELECT id, hash, created_at FROM "drizzle"."__drizzle_migrations" ORDER BY created_at DESC LIMIT 1`
|
|
);
|
|
const lastDbMigration = dbMigrations[0] ?? void 0;
|
|
const queriesToRun = [];
|
|
for (const migration of migrations) {
|
|
if (!lastDbMigration || Number(lastDbMigration.created_at) < migration.folderMillis) {
|
|
queriesToRun.push(
|
|
...migration.sql,
|
|
`INSERT INTO "drizzle"."__drizzle_migrations" ("hash", "created_at") VALUES('${migration.hash}', '${migration.folderMillis}')`
|
|
);
|
|
}
|
|
}
|
|
await callback(queriesToRun);
|
|
}
|
|
export {
|
|
migrate
|
|
};
|
|
//# sourceMappingURL=migrator.js.map
|