Django: Retrieve a model Queryset that created today but has no entries before
Lets take a situation,
class A(models.Model):
customer = models.FK(User)
created = models.DateTimeField()
...
I need to fetch all the rows created today but only the rows that is created for the first time against each customer.
Suppose a customer made an entry yesterday and today, we do not want to include it. But if the customer is making an entry for the first time today in the table it has to be included.
This can be achieved using two different querying steps , one to fetch all entries today then check if the customer is made that entry for the first time in this table using next step of query.
What I am searching for is a better optimized way to achieve this. Is there a better solution, a better way to use Django ORM?
django django-models django-queryset django-orm
asked Nov 24 '18 at 12:51
Vipul Vishnu avVipul Vishnu av
365314
add a comment |
Lets take a situation,
class A(models.Model):
customer = models.FK(User)
created = models.DateTimeField()
...
I need to fetch all the rows created today but only the rows that is created for the first time against each customer.
Suppose a customer made an entry yesterday and today, we do not want to include it. But if the customer is making an entry for the first time today in the table it has to be included.
This can be achieved using two different querying steps , one to fetch all entries today then check if the customer is made that entry for the first time in this table using next step of query.
What I am searching for is a better optimized way to achieve this. Is there a better solution, a better way to use Django ORM?
django django-models django-queryset django-orm
asked Nov 24 '18 at 12:51
Vipul Vishnu avVipul Vishnu av
365314
How do you know when a record was created? Do you have a DateTimeField column that tracks that? Databases typically don't give you that information for free...
– Jonah Bishop
Nov 24 '18 at 13:08
Yes I have a created column. Which is a datetimefield. Sorry I will edit the model definition.
– Vipul Vishnu av
Nov 24 '18 at 14:05
add a comment |
Lets take a situation,
class A(models.Model):
customer = models.FK(User)
created = models.DateTimeField()
...
I need to fetch all the rows created today but only the rows that is created for the first time against each customer.
Suppose a customer made an entry yesterday and today, we do not want to include it. But if the customer is making an entry for the first time today in the table it has to be included.
This can be achieved using two different querying steps , one to fetch all entries today then check if the customer is made that entry for the first time in this table using next step of query.
What I am searching for is a better optimized way to achieve this. Is there a better solution, a better way to use Django ORM?
django django-models django-queryset django-orm
asked Nov 24 '18 at 12:51
Vipul Vishnu avVipul Vishnu av
365314
Lets take a situation,
class A(models.Model):
customer = models.FK(User)
created = models.DateTimeField()
...
I need to fetch all the rows created today but only the rows that is created for the first time against each customer.
Suppose a customer made an entry yesterday and today, we do not want to include it. But if the customer is making an entry for the first time today in the table it has to be included.
This can be achieved using two different querying steps , one to fetch all entries today then check if the customer is made that entry for the first time in this table using next step of query.
What I am searching for is a better optimized way to achieve this. Is there a better solution, a better way to use Django ORM?
django django-models django-queryset django-orm
django django-models django-queryset django-orm
asked Nov 24 '18 at 12:51
Vipul Vishnu avVipul Vishnu av
365314
asked Nov 24 '18 at 12:51
Vipul Vishnu avVipul Vishnu av
365314
edited Nov 24 '18 at 14:06
Vipul Vishnu av
asked Nov 24 '18 at 12:51
Vipul Vishnu avVipul Vishnu av
365314
asked Nov 24 '18 at 12:51
Vipul Vishnu avVipul Vishnu av
365314
asked Nov 24 '18 at 12:51
Vipul Vishnu avVipul Vishnu av
365314
365314
How do you know when a record was created? Do you have a DateTimeField column that tracks that? Databases typically don't give you that information for free...
– Jonah Bishop
Nov 24 '18 at 13:08
Yes I have a created column. Which is a datetimefield. Sorry I will edit the model definition.
– Vipul Vishnu av
Nov 24 '18 at 14:05
add a comment |
How do you know when a record was created? Do you have a DateTimeField column that tracks that? Databases typically don't give you that information for free...
– Jonah Bishop
Nov 24 '18 at 13:08
Yes I have a created column. Which is a datetimefield. Sorry I will edit the model definition.
– Vipul Vishnu av
Nov 24 '18 at 14:05
How do you know when a record was created? Do you have a DateTimeField column that tracks that? Databases typically don't give you that information for free...
– Jonah Bishop
Nov 24 '18 at 13:08
How do you know when a record was created? Do you have a DateTimeField column that tracks that? Databases typically don't give you that information for free...
– Jonah Bishop
Nov 24 '18 at 13:08
Yes I have a created column. Which is a datetimefield. Sorry I will edit the model definition.
– Vipul Vishnu av
Nov 24 '18 at 14:05
Yes I have a created column. Which is a datetimefield. Sorry I will edit the model definition.
– Vipul Vishnu av
Nov 24 '18 at 14:05
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%2f53458337%2fdjango-retrieve-a-model-queryset-that-created-today-but-has-no-entries-before%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%2f53458337%2fdjango-retrieve-a-model-queryset-that-created-today-but-has-no-entries-before%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
How do you know when a record was created? Do you have a DateTimeField column that tracks that? Databases typically don't give you that information for free...
– Jonah Bishop
Nov 24 '18 at 13:08
Yes I have a created column. Which is a datetimefield. Sorry I will edit the model definition.
– Vipul Vishnu av
Nov 24 '18 at 14:05