<h1>SQL Snippets</h1>

A collection of SQL snippets which have proven useful when tinkering file fossil:

<h2>List of files changed by a given commit UUID:</h2>

<nowiki><pre>
SELECT
        bf.uuid,
        filename.name fname,
        bf.size
FROM mlink, filename, event,
     blob bf, -- FILE blob
     blob bm -- MANIFEST/checkin blob
WHERE 
bm.uuid glob '6b581c89f90c*'
AND filename.fnid=mlink.fnid
AND event.objid=mlink.mid
AND bf.rid=mlink.fid
AND bm.rid=mlink.mid
;
</pre></nowiki>

Hmmm. i think that "should" be possible without going through the event table, but i currently don't see how.