On 7/26/16, David Mason <dma...@ryerson.ca> wrote:
> Is there any way to find all the artifacts that correspond to a given
> pathname?  Then I could shun those.

SELECT DISTINCT uuid
  FROM blob, mlink, filename
 WHERE blob.rid=mlink.fid
   AND mlink.fnid=filename.fnid
   AND filename.name=$NAME;

Fill in $NAME appropriately, of course.

-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

Reply via email to