[daisy] Recovering one document

[Bruno Dumon]

On Thu, 2006-10-19 at 12:11 -0400, Thomas, Mark - BLS CTR wrote:
> Marc Portier wrote:
> > $ find -type f | xargs grep -l
> > "xmlns:d='http://outerx.org/daisy/1.0#navigationspec'"
> > 
> > all on one line,
> > the result will be a list of documents in the blobstore that 
> > are navigation-trees (normally not that much)
> 
> Thanks. In my case there were hundreds, but a few additional greps and
> some diffs later, I was able to find what I needed.

It won't help you anymore this time, but alternatively one could query
the 'parts' table of the SQL database:

select blob_id, version_id from parts where doc_id = <the nav doc id>
order by version_id desc

and then use the returned blob_id(s) to search for the file in the
blobstore (of the backup).

The database schema can be found at:
http://cocoondev.org/daisydocs-1_5/10/version/default/part/ImageData/data/storage_model.png

(note that one shouldn't ever directly modify the Daisy database, but
querying is of course not harmful)

-- 
Bruno Dumon                             http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno at outerthought.org                          bruno at apache.org