On Wed, Nov 26, 2014 at 7:51 PM, Andreas Kupries <andre...@activestate.com>
wrote:
> repository eval {
> SELECT filename.name AS thepath,
> CASE WHEN nullif(mlink.pid,0) is null THEN 'added'
> WHEN nullif(mlink.fid,0) is null THEN 'deleted'
> ELSE 'edited'
> END AS theaction
> FROM mlink, filename, blob
> WHERE mlink.mid = blob.rid
> AND blob.uuid = :uuid
> AND mlink.fnid = filename.fnid
> ORDER BY filename.name
> } {
>
The Holy Grail (or an excellent starting point)!
Thank you!
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
fossil-dev mailing list
fossil-dev@lists.fossil-scm.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/fossil-dev
