Re: [google-appengine] Datastore admin not working and effective ways to delete / manage bulk data
Hey Robert.. it would be pretty much like this : delete * from kind or even using a dummy clause like delete * from kind where __key__ 5 Does that make sense? Thanks! Diego Piccolo. 2012/1/31 Robert Kluin robert.kl...@gmail.com Hi Diego, Could you clarify what you're trying to do? Perhaps including an example (of what you think the query would look like)? Robert On Mon, Jan 30, 2012 at 11:09, Diego Piccolo dara...@ciandt.com wrote: Hello Everyone, lately i've been facing a lot of problems with Datastore admin, it does'nt seem to work, i keep getting: Error: Forbidden Your client does not have permission to get URL /_ah/datastore_admin/?app_id= Plus i must be pretty dumb because it's been too damn complicated to run a query that could delete help me to purge some of my kinds. Do you guys have any advice on how could i could do it easily? Thanks in advance, Diego Piccolo. -- 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. -- 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. -- 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.
Re: [google-appengine] Datastore admin not working and effective ways to delete / manage bulk data
Hi Diego, There are some quirks to using the datastore admin. You need to be sure you're signed in with an account that is an app admin. If you're using Google Accounts, Google Apps for your Domain accounts, and / or federated login this can be a real mess to get right. You might try using a different browser with cleared cookies, then do some experiments to figure out which account works. Especially if you don't have a ton (millions and millions of entities) of data, you could also just put together a simple script to do the delete. If you've only got a few tens of thousands of entities, just doing a keys only query for that kind and feeding the resulting list of keys into db.delete will probably run in a few minutes. Robert On Tue, Jan 31, 2012 at 11:00, Diego Piccolo dara...@ciandt.com wrote: Hey Robert.. it would be pretty much like this : delete * from kind or even using a dummy clause like delete * from kind where __key__ 5 Does that make sense? Thanks! Diego Piccolo. 2012/1/31 Robert Kluin robert.kl...@gmail.com Hi Diego, Could you clarify what you're trying to do? Perhaps including an example (of what you think the query would look like)? Robert On Mon, Jan 30, 2012 at 11:09, Diego Piccolo dara...@ciandt.com wrote: Hello Everyone, lately i've been facing a lot of problems with Datastore admin, it does'nt seem to work, i keep getting: Error: Forbidden Your client does not have permission to get URL /_ah/datastore_admin/?app_id= Plus i must be pretty dumb because it's been too damn complicated to run a query that could delete help me to purge some of my kinds. Do you guys have any advice on how could i could do it easily? Thanks in advance, Diego Piccolo. -- 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. -- 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. -- 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. -- 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] Datastore admin not working and effective ways to delete / manage bulk data
Hello Everyone, lately i've been facing a lot of problems with Datastore admin, it does'nt seem to work, i keep getting: Error: Forbidden Your client does not have permission to get URL /_ah/datastore_admin/?app_id= Plus i must be pretty dumb because it's been too damn complicated to run a query that could delete help me to purge some of my kinds. Do you guys have any advice on how could i could do it easily? Thanks in advance, Diego Piccolo. -- 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.
Re: [google-appengine] Datastore admin not working and effective ways to delete / manage bulk data
Hi Diego, Could you clarify what you're trying to do? Perhaps including an example (of what you think the query would look like)? Robert On Mon, Jan 30, 2012 at 11:09, Diego Piccolo dara...@ciandt.com wrote: Hello Everyone, lately i've been facing a lot of problems with Datastore admin, it does'nt seem to work, i keep getting: Error: Forbidden Your client does not have permission to get URL /_ah/datastore_admin/?app_id= Plus i must be pretty dumb because it's been too damn complicated to run a query that could delete help me to purge some of my kinds. Do you guys have any advice on how could i could do it easily? Thanks in advance, Diego Piccolo. -- 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. -- 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.
