migrator.cjs 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. "use strict";
  2. var __defProp = Object.defineProperty;
  3. var __getOwnPropDesc = Object.getOwnPropertyDescriptor;
  4. var __getOwnPropNames = Object.getOwnPropertyNames;
  5. var __hasOwnProp = Object.prototype.hasOwnProperty;
  6. var __export = (target, all) => {
  7. for (var name in all)
  8. __defProp(target, name, { get: all[name], enumerable: true });
  9. };
  10. var __copyProps = (to, from, except, desc) => {
  11. if (from && typeof from === "object" || typeof from === "function") {
  12. for (let key of __getOwnPropNames(from))
  13. if (!__hasOwnProp.call(to, key) && key !== except)
  14. __defProp(to, key, { get: () => from[key], enumerable: !(desc = __getOwnPropDesc(from, key)) || desc.enumerable });
  15. }
  16. return to;
  17. };
  18. var __toCommonJS = (mod) => __copyProps(__defProp({}, "__esModule", { value: true }), mod);
  19. var migrator_exports = {};
  20. __export(migrator_exports, {
  21. migrate: () => migrate
  22. });
  23. module.exports = __toCommonJS(migrator_exports);
  24. var import_migrator = require("../migrator.cjs");
  25. var import_sql = require("../sql/sql.cjs");
  26. async function migrate(db, config) {
  27. const migrations = (0, import_migrator.readMigrationFiles)(config);
  28. const migrationsTable = config.migrationsTable ?? "__drizzle_migrations";
  29. const migrationTableCreate = import_sql.sql`
  30. CREATE TABLE IF NOT EXISTS ${import_sql.sql.identifier(migrationsTable)} (
  31. id SERIAL PRIMARY KEY,
  32. hash text NOT NULL,
  33. created_at bigint
  34. )
  35. `;
  36. await db.session.execute(migrationTableCreate);
  37. const dbMigrations = await db.session.all(
  38. import_sql.sql`select id, hash, created_at from ${import_sql.sql.identifier(migrationsTable)} order by created_at desc limit 1`
  39. );
  40. const lastDbMigration = dbMigrations[0];
  41. for await (const migration of migrations) {
  42. if (!lastDbMigration || Number(lastDbMigration.created_at) < migration.folderMillis) {
  43. for (const stmt of migration.sql) {
  44. await db.session.execute(import_sql.sql.raw(stmt));
  45. }
  46. await db.session.execute(
  47. import_sql.sql`insert into ${import_sql.sql.identifier(migrationsTable)} ("hash", "created_at") values(${migration.hash}, ${migration.folderMillis})`
  48. );
  49. }
  50. }
  51. }
  52. // Annotate the CommonJS export names for ESM import in node:
  53. 0 && (module.exports = {
  54. migrate
  55. });
  56. //# sourceMappingURL=migrator.cjs.map