Hi,
Here is my model am using to update items status.
class User(models.Model)
users = models.ForeignKey(User)
resources = models.ForeignKey(Resource)
date_tracked = models.DateTimeField('Date Tracked')
description = models.TextField()
status_count_per_week = models.IntegerField()
status = models.ForeignKey(Status)
class Meta:
verbose_name_plural = 'Track Resources'
What i want to achieve is that:
When i update the status the item first i should get the date last tracked
and compare with tje current date, if the date tracked and the current date
are not in the same week it should insert into a new row of
status_count_per_week. If the date tracked and the current date are in the
same week it should increment the value of status_count_per_week .
Regards.
Denis.
On Thu, Nov 12, 2009 at 11:58 AM, [email protected] <
[email protected]> wrote:
>
> On Nov 12, 7:51 am, Denis Bahati <[email protected]> wrote:
> > Hi All,
> >
> > I have a field with an integer value which needs to be incremented
> > every time any user updates its status within a week. If that week has
> > passed it should insert a new row. Now i was trying to figure out but
> > didn't get any concept on how to go through. Please any idea?
>
> You don't mention how you're tracking dates or weeks (is that a
> related model, or... ?) but this would be the general idea:
>
> - get the timestamp of the last update to that field and compare it to
> the current timestamp
>
> if ... : # interval is less than a week:
> foo = MyModel.objects.get(...)
> foo.counter = foo.counter + 1
> else : interval is more than a week
> foo = MyModel()
> foo.counter = 1
>
> foo.save()
>
> --
>
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<django-users%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=.
