deferring commits in SQLAlchemy
Context: I am given code in which individual models do their own db.commit() after being updated. (You could argue whether or not that's bad coding practice, but that's not the point of this question...) Because my code updates a bunch of models, I'd like to do a single commit() after finishing all the updates rather than pay the overhead for the individual commits.
Question: Is there a construct that overrides all calls to commit(), perhaps in the form of a context manager, that performs a single commit() at the end?
with deferred_commits(db):
... update a bunch of models that might themselves call commit ...
... or something that's functionally equivalent? I can see how I'd implement that, but I'd rather use tested code before rolling my own.
python sqlalchemy flask-sqlalchemy
edited Nov 26 '18 at 5:44
Ilja Everilä
25k33765
asked Nov 26 '18 at 0:50
fearless_foolfearless_fool
21k1695160
add a comment |
Context: I am given code in which individual models do their own db.commit() after being updated. (You could argue whether or not that's bad coding practice, but that's not the point of this question...) Because my code updates a bunch of models, I'd like to do a single commit() after finishing all the updates rather than pay the overhead for the individual commits.
Question: Is there a construct that overrides all calls to commit(), perhaps in the form of a context manager, that performs a single commit() at the end?
with deferred_commits(db):
... update a bunch of models that might themselves call commit ...
... or something that's functionally equivalent? I can see how I'd implement that, but I'd rather use tested code before rolling my own.
python sqlalchemy flask-sqlalchemy
edited Nov 26 '18 at 5:44
Ilja Everilä
25k33765
asked Nov 26 '18 at 0:50
fearless_foolfearless_fool
21k1695160
add a comment |
Context: I am given code in which individual models do their own db.commit() after being updated. (You could argue whether or not that's bad coding practice, but that's not the point of this question...) Because my code updates a bunch of models, I'd like to do a single commit() after finishing all the updates rather than pay the overhead for the individual commits.
Question: Is there a construct that overrides all calls to commit(), perhaps in the form of a context manager, that performs a single commit() at the end?
with deferred_commits(db):
... update a bunch of models that might themselves call commit ...
... or something that's functionally equivalent? I can see how I'd implement that, but I'd rather use tested code before rolling my own.
python sqlalchemy flask-sqlalchemy
edited Nov 26 '18 at 5:44
Ilja Everilä
25k33765
asked Nov 26 '18 at 0:50
fearless_foolfearless_fool
21k1695160
Context: I am given code in which individual models do their own db.commit() after being updated. (You could argue whether or not that's bad coding practice, but that's not the point of this question...) Because my code updates a bunch of models, I'd like to do a single commit() after finishing all the updates rather than pay the overhead for the individual commits.
Question: Is there a construct that overrides all calls to commit(), perhaps in the form of a context manager, that performs a single commit() at the end?
with deferred_commits(db):
... update a bunch of models that might themselves call commit ...
... or something that's functionally equivalent? I can see how I'd implement that, but I'd rather use tested code before rolling my own.
python sqlalchemy flask-sqlalchemy
python sqlalchemy flask-sqlalchemy
edited Nov 26 '18 at 5:44
Ilja Everilä
25k33765
asked Nov 26 '18 at 0:50
fearless_foolfearless_fool
21k1695160
edited Nov 26 '18 at 5:44
Ilja Everilä
25k33765
asked Nov 26 '18 at 0:50
fearless_foolfearless_fool
21k1695160
edited Nov 26 '18 at 5:44
Ilja Everilä
25k33765
edited Nov 26 '18 at 5:44
Ilja Everilä
25k33765
edited Nov 26 '18 at 5:44
Ilja Everilä
25k33765
25k33765
asked Nov 26 '18 at 0:50
fearless_foolfearless_fool
21k1695160
asked Nov 26 '18 at 0:50
fearless_foolfearless_fool
21k1695160
asked Nov 26 '18 at 0:50
fearless_foolfearless_fool
21k1695160
21k1695160
add a comment |
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%2f53473513%2fdeferring-commits-in-sqlalchemy%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%2f53473513%2fdeferring-commits-in-sqlalchemy%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
