Ok, my bad, the sequence works well, i just confused the field name... But the problem is still there if the update is done by another actor than Django itself.
My standalone script is daemon which poll my DB with a XX.objects.all(). If i updated myself a row from XX, the daemon doesn't see the modification until i relaunch it. Even a Tag.objects.get(id = 1) for example ignore the update. Is there a way to force the query again ? On Thu, Oct 8, 2009 at 2:05 AM, Karen Tracey <kmtra...@gmail.com> wrote: > On Wed, Oct 7, 2009 at 7:39 PM, laligatz <lalig...@gmail.com> wrote: > >> >> Hi everybody. >> >> I'm stuck on a problem with the Django ORM. >> After a basic query like select * from table where id = 1, the result >> is still the same although i've update the row in the DB. >> >> Example: >> >> >>> Tag.objects.all() >> [<Tag: tag1>] >> >> >>> tag = Tag.objects.all().get() >> >>> tag >> <Tag: tag1> >> >> >>> tag.name = 'tag11' >> >>> tag.save() >> >> >>> Tag.objects.all() >> [<Tag: tag1>] >> >> How to say to Django to make the query again ? >> >> > I cannot recreate this. With this model: > > class Tag(models.Model): > name = models.CharField(max_length=22) > def __unicode__(self): > return self.name > > your sequence of commands produces: > > >>> from ttt.models import Tag > >>> Tag.objects.all() > [] > >>> Tag.objects.create(name='tag1') > <Tag: tag1> > >>> Tag.objects.all() > [<Tag: tag1>] > >>> tag = Tag.objects.get() > >>> tag > <Tag: tag1> > >>> tag.name = 'tag11' > >>> tag.save() > >>> Tag.objects.all() > [<Tag: tag11>] > > Is there something you've left out of your account that might be a clue? > What's this standalone script mentioned in the subject? Despite looking > like your sequence is from a singe python shell session, is the update being > done by a different shell/script than the query? If so, and if you are > using MySQL/InnoDB I suspect the problem is to do its default transaction > isolation level. But at this point point I'm leaping pretty high to a > conclusion based on guesses about what you might be doing, not what you've > actually said you are doing. > > 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-users@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=en -~----------~----~----~----~------~----~------~--~---
