[google-appengine] Re: Can not delete entity using Data Viewer and a GQL query.
http://volvooceanracegamehelp.appspot.com/ is the URL. I know I can delete programatically, but would rather use the tool you provide for one-off deletes. Thanks for the help. Robin PS I just tried again using gql: SELECT * FROM UserUpdates WHERE windAngle=328 And it is still not working. On Jan 12, 9:39 pm, Marzia Niccolai ma...@google.com wrote: Hi, If you reply with your app id I can look in to it directly. If you can find the data in the dataviewer, however, you can get the key string (from the data's URL) and call db.delete() directly on that key in your application (if, for instance, you included something like shell with your application so you could run interactive commands). -Marzia On Sun, Jan 11, 2009 at 1:33 PM, murexconsult...@googlemail.com robin_ow...@hedge-row.co.uk wrote: There was a bug in my app and some bad data got into the Datastore. So I want to delete some data. The models have a number of items so rather than paging through them all 20 at a time to find it I ran the GQL query: SELECT * FROM UserUpdates WHERE windAngle=328 This returns one row as expected. I then click on the tickbox beside it and click on Delete. I then get a dialog box asking if I am sure to which I say yes. I then get the error displayed in a red box at the top saying The URL to forward to once the request is fulfilled - Yes the error is a partial sentence and makes no sense. The item is NOT deleted. This is happening to all 4 of my models. However 2 of them only have a few hundred entries, so I was able to page through, find the item and delete it. When I paged through, the deleting was successful. I think that there must be a bug in the data viewer when removing data found using a gql query. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Google App Engine group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~--~~~~--~~--~--~---
[google-appengine] Can not delete entity using Data Viewer and a GQL query.
There was a bug in my app and some bad data got into the Datastore. So I want to delete some data. The models have a number of items so rather than paging through them all 20 at a time to find it I ran the GQL query: SELECT * FROM UserUpdates WHERE windAngle=328 This returns one row as expected. I then click on the tickbox beside it and click on Delete. I then get a dialog box asking if I am sure to which I say yes. I then get the error displayed in a red box at the top saying The URL to forward to once the request is fulfilled - Yes the error is a partial sentence and makes no sense. The item is NOT deleted. This is happening to all 4 of my models. However 2 of them only have a few hundred entries, so I was able to page through, find the item and delete it. When I paged through, the deleting was successful. I think that there must be a bug in the data viewer when removing data found using a gql query. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Google App Engine group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~--~~~~--~~--~--~---
[google-appengine] Re: Adding property to a Model
Thanks, adding the default fixed it. Although the development datastore viewer still does not work correctly. I can not edit the new field for the old or NEW records. When I uploaded to production all worked fine. The production dataviewer displayed Missing for the field in the old rows, and the correct value for new ones. The development dataserver behaves slightly differently in this use case than the production one. But the production one works better! Thanks Robin On Jan 3, 7:41 am, Alexander Kojevnikov alexan...@kojevnikov.com wrote: I can insert new rows fine, and see them in the Development server datastore viewer. But when I try to access the new property contains NoneType: None. You can assign a default value to the property, it will be used when an entity has no value for the property: boat = db.StringProperty(default='my default value') How can I force the Datastore to add this new property without having to delete all the old data and re-add? You don't have to re-create your entities, if you want you can iterate through them and update the property value: entity.boat = 'my default value' entity.put() If you have many entities, you will have to do the update in multiple requests, probably using the __key__ index to properly iterate over all of them. But before doing this, consider using the 'default' parameter first, it's much easier. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Google App Engine group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~--~~~~--~~--~--~---
[google-appengine] Adding property to a Model
I have an existing application that is in production (volvooceanracegamehelp.appspot.com). I would like to add to one of my entities an additional property. I have done this in the python by just adding the line: boat=db.StringProperty() to my class that inherits from db.Model. I can insert new rows fine, and see them in the Development server datastore viewer. But when I try to access the new property contains NoneType: None. How can I force the Datastore to add this new property without having to delete all the old data and re-add? Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Google App Engine group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~--~~~~--~~--~--~---