On Wed, Nov 26, 2014 at 7:58 PM, Stephan Beal <[email protected]> wrote:
> The Holy Grail (or an excellent starting point)!
>
Sorry, i spoke too soon: that gets me the changed files, but i want the
whole list. Maybe i can use yours as a starting point for a CTE, but i've
not a clue what the termination point for such a CTE would need to be for
such a use. Sounds like writing a vtable would be simpler.
> Thank you!
>
But nonetheless, this is also useful :)
[stephan@host:~/cvs/fossil/cwal]$ cat ak.sql
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.rid = fsl_sym2rid('trunk')
AND mlink.fnid = filename.fnid
ORDER BY filename.name
;
[stephan@host:~/cvs/fossil/cwal]$ f-query -e ak.sql
thepath theaction
s2/s2_eval.c edited
--
----- 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/fossil-dev
