60 lines
2.3 KiB
JavaScript
60 lines
2.3 KiB
JavaScript
"use strict";
|
|
var __defProp = Object.defineProperty;
|
|
var __getOwnPropDesc = Object.getOwnPropertyDescriptor;
|
|
var __getOwnPropNames = Object.getOwnPropertyNames;
|
|
var __hasOwnProp = Object.prototype.hasOwnProperty;
|
|
var __export = (target, all) => {
|
|
for (var name in all)
|
|
__defProp(target, name, { get: all[name], enumerable: true });
|
|
};
|
|
var __copyProps = (to, from, except, desc) => {
|
|
if (from && typeof from === "object" || typeof from === "function") {
|
|
for (let key of __getOwnPropNames(from))
|
|
if (!__hasOwnProp.call(to, key) && key !== except)
|
|
__defProp(to, key, { get: () => from[key], enumerable: !(desc = __getOwnPropDesc(from, key)) || desc.enumerable });
|
|
}
|
|
return to;
|
|
};
|
|
var __toCommonJS = (mod) => __copyProps(__defProp({}, "__esModule", { value: true }), mod);
|
|
var migrator_exports = {};
|
|
__export(migrator_exports, {
|
|
migrate: () => migrate
|
|
});
|
|
module.exports = __toCommonJS(migrator_exports);
|
|
var import_migrator = require("../migrator.cjs");
|
|
var import_sql = require("../sql/sql.cjs");
|
|
async function migrate(db, config) {
|
|
const migrations = (0, import_migrator.readMigrationFiles)(config);
|
|
const migrationsTable = config.migrationsTable ?? "__drizzle_migrations";
|
|
const migrationTableCreate = import_sql.sql`
|
|
CREATE TABLE IF NOT EXISTS ${import_sql.sql.identifier(migrationsTable)} (
|
|
id SERIAL PRIMARY KEY,
|
|
hash text NOT NULL,
|
|
created_at numeric
|
|
)
|
|
`;
|
|
await db.session.run(migrationTableCreate);
|
|
const dbMigrations = await db.values(
|
|
import_sql.sql`SELECT id, hash, created_at FROM ${import_sql.sql.identifier(migrationsTable)} ORDER BY created_at DESC LIMIT 1`
|
|
);
|
|
const lastDbMigration = dbMigrations[0] ?? void 0;
|
|
const statementToBatch = [];
|
|
for (const migration of migrations) {
|
|
if (!lastDbMigration || Number(lastDbMigration[2]) < migration.folderMillis) {
|
|
for (const stmt of migration.sql) {
|
|
statementToBatch.push(db.run(import_sql.sql.raw(stmt)));
|
|
}
|
|
statementToBatch.push(
|
|
db.run(
|
|
import_sql.sql`INSERT INTO ${import_sql.sql.identifier(migrationsTable)} ("hash", "created_at") VALUES(${migration.hash}, ${migration.folderMillis})`
|
|
)
|
|
);
|
|
}
|
|
}
|
|
await db.session.migrate(statementToBatch);
|
|
}
|
|
// Annotate the CommonJS export names for ESM import in node:
|
|
0 && (module.exports = {
|
|
migrate
|
|
});
|
|
//# sourceMappingURL=migrator.cjs.map
|