@kelp404/sequelize-auto-migrations - npm Package Compare versions

Comparing version 1.3.0 to 1.3.1

bin/runmigration.js

@@ -6,2 +6,3 @@ #!/usr/bin/env node
 const fs = require("fs");
+const Sequelize = require('sequelize');
 
@@ -84,16 +85,19 @@ const migrate = require("../lib/migrate");
 
-async function executeSql(queryInterface, sql, {type = queryInterface.sequelize.QueryTypes.SELECT} = {}) {
-  return queryInterface.sequelize.query(
-    sql, {type},
-  );
-}
-
 (async () => {
-  let createIfNot = await executeSql(
-    queryInterface,
-    'CREATE TABLE IF NOT EXISTS `SequelizeMeta` (name varchar(255) UNIQUE)',
-    {type: queryInterface.sequelize.QueryTypes.RAW},
+  await queryInterface.createTable('SequelizeMeta', {
+    name: {
+      type: Sequelize.STRING,
+      allowNull: false,
+      unique: true,
+    },
+  });
+  const results = await queryInterface.rawSelect(
+    'SequelizeMeta',
+    {
+      where: {},
+      plain: false,
+    },
+    ['name'],
   );
-  let res = await executeSql(queryInterface, 'select * from `SequelizeMeta`');
-  let ranMigrations = res.map(r => r.name);
+  let ranMigrations = results.map(r => r.name);
   migrationFiles = migrationFiles.filter(mf => {
@@ -108,7 +112,5 @@ return (!ranMigrations.includes(mf));
     await migrate.executeMigration(queryInterface, path.join(migrationsDir, file), fromPos);
-    await executeSql(
-      queryInterface,
-      `INSERT INTO \`SequelizeMeta\` (name) VALUES ('${file}')`,
-      {type: queryInterface.sequelize.QueryTypes.INSERT},
-    );
+    await queryInterface.bulkInsert('SequelizeMeta', [{
+      name: file,
+    }]);
     fromPos = 0;
@@ -115,0 +117,0 @@ }

package.json

 {
   "name": "@kelp404/sequelize-auto-migrations",
-  "version": "1.3.0",
+  "version": "1.3.1",
   "description": "Sequelize migrations generator && runner",
@@ -5,0 +5,0 @@ "main": "index.js",

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Lines of code

894

increased by0.34%

Worsened metrics

Total package byte prevSize

35571

decreased by-0.56%

No dependency changes