Exactly Karen the model is confusing. Here is the exactly model.
class Resource_Track(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'
Sorry for confusing you.
Regards
Denis.
On Sat, Nov 14, 2009 at 7:43 AM, Karen Tracey <kmtra...@gmail.com> wrote:
> On Sat, Nov 14, 2009 at 10:25 AM, Denis Bahati <djma...@gmail.com> wrote:
>
>> 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 .
>>
>>
> I find your model and description confusing -- I am not sure the model you
> have defined is correct for what you want to achieve -- so I am not going to
> attempt to craft a solution exactly. Instead I'll point you to the two
> building blocks I think you need to achieve what you are looking for.
> First, get_or_create:
>
>
> http://docs.djangoproject.com/en/dev/ref/models/querysets/#get-or-create-kwargs
>
> which you can use to either get the model containing a specific set of
> fields or create it if it does not exist.
>
> Second, update() with an F() expression can be used to atomically increment
> a counter:
>
>
> http://docs.djangoproject.com/en/dev/ref/models/instances/#updating-attributes-based-on-existing-fields
>
> Karen
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@googlegroups.com>
> .
> 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 django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=.
