Mixing
Adding auto incrementing integer with a starting value in Sequelize
After some research I don't seem to be able to find a great approach doing following:
I wan't to add a new column, to an existing table, that should be an auto incrementing integer, starting with the value of 1000.
My migration file is for now simple and obvious:
'use strict';
module.exports = {
up: (queryInterface, Sequelize) => {
return Promise.all([
queryInterface.addColumn(
'Orders',
'orderRef',
{
autoIncrement: true,
type: Sequelize.INTEGER
}
)
])
},
down: {...
}
};
So this adds the column to the table unproblematic. But I don't seem to be able to find a great approach to set the value to start at 1000 and increment from there.
I know I could run a query like ALTER TABLE Orders AUTO_INCREMENT = 1000; but I would very much appreciate to keep it in Sequelize.
I'm using a PostgreSQL database and Sequelize version 4.38.1.
Does anyone know a nice way around this issue?
node.js postgresql sequelize.js
asked Jan 2 at 11:58
crelleecrellee
460414
add a comment |
After some research I don't seem to be able to find a great approach doing following:
I wan't to add a new column, to an existing table, that should be an auto incrementing integer, starting with the value of 1000.
My migration file is for now simple and obvious:
'use strict';
module.exports = {
up: (queryInterface, Sequelize) => {
return Promise.all([
queryInterface.addColumn(
'Orders',
'orderRef',
{
autoIncrement: true,
type: Sequelize.INTEGER
}
)
])
},
down: {...
}
};
So this adds the column to the table unproblematic. But I don't seem to be able to find a great approach to set the value to start at 1000 and increment from there.
I know I could run a query like ALTER TABLE Orders AUTO_INCREMENT = 1000; but I would very much appreciate to keep it in Sequelize.
I'm using a PostgreSQL database and Sequelize version 4.38.1.
Does anyone know a nice way around this issue?
node.js postgresql sequelize.js
asked Jan 2 at 11:58
crelleecrellee
460414
Yeah been there buddy, Sequelize seems to not have an implementation to abstract this action yet, sadly you have to run that query.
– Mohdule
Jan 3 at 16:39
Thanks for your response. Well, that just seems weird. Yeah, either run that query or create 1000 failing insert attempts ;)
– crellee
Jan 4 at 10:09
add a comment |
After some research I don't seem to be able to find a great approach doing following:
I wan't to add a new column, to an existing table, that should be an auto incrementing integer, starting with the value of 1000.
My migration file is for now simple and obvious:
'use strict';
module.exports = {
up: (queryInterface, Sequelize) => {
return Promise.all([
queryInterface.addColumn(
'Orders',
'orderRef',
{
autoIncrement: true,
type: Sequelize.INTEGER
}
)
])
},
down: {...
}
};
So this adds the column to the table unproblematic. But I don't seem to be able to find a great approach to set the value to start at 1000 and increment from there.
I know I could run a query like ALTER TABLE Orders AUTO_INCREMENT = 1000; but I would very much appreciate to keep it in Sequelize.
I'm using a PostgreSQL database and Sequelize version 4.38.1.
Does anyone know a nice way around this issue?
node.js postgresql sequelize.js
asked Jan 2 at 11:58
crelleecrellee
460414
After some research I don't seem to be able to find a great approach doing following:
I wan't to add a new column, to an existing table, that should be an auto incrementing integer, starting with the value of 1000.
My migration file is for now simple and obvious:
'use strict';
module.exports = {
up: (queryInterface, Sequelize) => {
return Promise.all([
queryInterface.addColumn(
'Orders',
'orderRef',
{
autoIncrement: true,
type: Sequelize.INTEGER
}
)
])
},
down: {...
}
};
So this adds the column to the table unproblematic. But I don't seem to be able to find a great approach to set the value to start at 1000 and increment from there.
I know I could run a query like ALTER TABLE Orders AUTO_INCREMENT = 1000; but I would very much appreciate to keep it in Sequelize.
I'm using a PostgreSQL database and Sequelize version 4.38.1.
Does anyone know a nice way around this issue?
node.js postgresql sequelize.js
node.js postgresql sequelize.js
asked Jan 2 at 11:58
crelleecrellee
460414
asked Jan 2 at 11:58
crelleecrellee
460414
asked Jan 2 at 11:58
crelleecrellee
460414
asked Jan 2 at 11:58
crelleecrellee
460414
asked Jan 2 at 11:58
crelleecrellee
460414
460414
Yeah been there buddy, Sequelize seems to not have an implementation to abstract this action yet, sadly you have to run that query.
– Mohdule
Jan 3 at 16:39
Thanks for your response. Well, that just seems weird. Yeah, either run that query or create 1000 failing insert attempts ;)
– crellee
Jan 4 at 10:09
add a comment |
Yeah been there buddy, Sequelize seems to not have an implementation to abstract this action yet, sadly you have to run that query.
– Mohdule
Jan 3 at 16:39
Thanks for your response. Well, that just seems weird. Yeah, either run that query or create 1000 failing insert attempts ;)
– crellee
Jan 4 at 10:09
Yeah been there buddy, Sequelize seems to not have an implementation to abstract this action yet, sadly you have to run that query.
– Mohdule
Jan 3 at 16:39
Yeah been there buddy, Sequelize seems to not have an implementation to abstract this action yet, sadly you have to run that query.
– Mohdule
Jan 3 at 16:39
Thanks for your response. Well, that just seems weird. Yeah, either run that query or create 1000 failing insert attempts ;)
– crellee
Jan 4 at 10:09
Thanks for your response. Well, that just seems weird. Yeah, either run that query or create 1000 failing insert attempts ;)
– crellee
Jan 4 at 10:09
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54005949%2fadding-auto-incrementing-integer-with-a-starting-value-in-sequelize%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54005949%2fadding-auto-incrementing-integer-with-a-starting-value-in-sequelize%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Yeah been there buddy, Sequelize seems to not have an implementation to abstract this action yet, sadly you have to run that query.
– Mohdule
Jan 3 at 16:39
Thanks for your response. Well, that just seems weird. Yeah, either run that query or create 1000 failing insert attempts ;)
– crellee
Jan 4 at 10:09