Re: Update database field
Hi, This is what i ended up doing in a project of mine.But this involved two DB calls One to retrieve and another to save, but with just SQL can be accomplished in a single UPDATE statement. Django docs menthion that if you explicitly specify an id (primary key ) it should update the db. So I did something like this i = Item.(id=4, name='New Name') i.save() The Item model has a created_at column, which is sent NULL if I do this. Hence the query fails. There shoud be a better way of doing it. -- Manu On 11/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Yea, that will work. > > Get the "thing" > change the value > store it. > > > tinti wrote: > > Got it: > > > > update = Queue.objects.get(message=message_id) > > update.read = 1 > > update.save() > > > > I thinks this is the correct way, if not somebody can advise me another > > ;) > > > > On Nov 14, 11:37 am, "tinti" <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > I need some help updating a database field. Can someone post me an > > > example on updating a database field using the views.py and a static > > > value to update. For example each time an item is requested set the > > > field read to 1. I have to build something similar. > > > > > > Thanks for any reply > > > > > > tinti > > > > > --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: Want to see your favorite branch merged? Here's how you can help!
1. Row level permissions 2. Schema Evolution -- Manu --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: How to find out the id of the last record in a table?
On 11/16/06, Don Arbow <[EMAIL PROTECTED]> wrote: > > On Nov 15, 2006, at 9:58 PM, simonbun wrote: > > > > The problem with getting the last record's id and using it, is that > > someone might have inserted yet another record while you're still > > working on the previous one. > > > > For single user scenario's it's ok, or if you're using table level > > write locking. Yet afaik, its generally a bad idea. > > > > Not sure how it works in MySQL, but in Postgres, getting the last > inserted id is unique to the current user's (database) session. So if > a user inserts a record into the table, then queries the sequence for > that id, the value will always be the same, regardless if other table > insertions have been done by other users since the first insertion. > So the last inserted id should be thought of as the id inserted by > this user, not the maximum id inserted by any user. Yes, this is the functionality that i'm seeking. The id of the object most recently saved on a per user(connection) basis. In case of MySQL (5.0) the id is unique to connection. Here is the relevant portion frrom the docs "For LAST_INSERT_ID(), the most recently generated ID is maintained in the server on a per-connection basis. It is not changed by another client." Don't know about pre-5.0 versions, but i guess it is the same. > > The easiest way to get the last inserted id is to create an object, > save it, then read its id directly. If you need the maximum inserted > id, use select max(id) from table. To do this you should be using the create method and not the save method since the save does not return the object saved. p = Person.objects.create(first_name="Bruce", last_name="Springsteen") p.id will give you the id of the object saved. (example from the docs ) -- Manu --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: How to find out the id of the last record in a table?
There is a get_last_insert_id() function defined in the backend models. Can that be used somehow ? -- Manu On 11/15/06, Pythoni <[EMAIL PROTECTED]> wrote: > > Thank you very much for help > L. > > > > > --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---