knex migrate in docker compose
simple command for handling migration using knex orm database
// my package.json add this
"knexrollmig": "npx migrate rollback && npx knex migrate:latest",
"start": "npm run knexrollmig && node dist/server.js"
// my docker-compose add this
command: sh -c "sleep 3 && npm start"knex migrate in docker compose
"use strict";
const config = require("./knexfile");
const Knex = require("knex");
const knex = Knex(config);
async function runMigrations(retries, delay) {
for (let i = 1; i !== retries; i++) {
try {
return await knex.migrate.latest();
} catch (err) {
await setTimeoutAsync(delay * i);
}
}
throw new Error(`Unable to run migrations after ${retries} attempts.`);
}
function setTimeoutAsync(ms) {
return new Promise(resolve => {
setTimeout(resolve, ms);
});
}
runMigrations(10, 500)
.catch(err => {
console.log(err);
process.exit(1);
})
.then(res => {
console.log(`Batch ${res[0]} run: ${res[1].length} migrations`);
console.log(res[1].join("\n"));
process.exit();
});Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
