CODEWITHSUNDEEP
pythongoogle-app-engineblobstore
Gareth Simpson
Gareth Simpson

Reputation: 37671

Is it possible to find and delete orphaned blobs in the app engine blobstore?

I'm using the python api and have created a few orphaned blobs during testing.

Because of a bug in the dashboard, I can't currently delete these, and in any case going forward I would like to be able to do this programmatically since it will be unfeasible to do it manually once the number of entities goes up.

Upvotes: 5

Views: 2029

Answers (2)

Kester Allen
Kester Allen

Reputation: 58

Slight improvement: using run instead of fetch will return an iterable instead of a list, so you don't need to limit the number of entries in the query:

blobs = BlobInfo.all().run()

instead of 

blobs = BlobInfo.all().fetch(500)

Upvotes: 1

Nick Johnson
Nick Johnson

Reputation: 101149

If your BlobReferenceProperty field is indexed, then yes, it's quite possible.

The BlobInfo class provides the same set of fields as a regular model, so you can do it something like this:

blobs = BlobInfo.all().fetch(500)
for blob in blobs:
  if not MyModel.all().filter("blob_ref =", blob.key()).count(1):
    blob.delete()

If you have more than a few blobs, you probably want to reimplement this using the recently reduced mapreduce API.

Upvotes: 13

Related Questions