This is a fantastic little utility, thanks for putting it together! One of my projects (a statically generated site with over 100k files) has a "audit" requirement which I was wondering whether fselect might fulfill.
Specifically we need to see if each *.md file in the source directory (e.g. content) has generated one or more files in the destination directory (e.g. public). Would fselect be able to "diff" the entries in the public directory and indicate whether something in the content directory appears in the same path in the public directory?
Something like below would be ideal but since the documentation says fselect is not real SQL I wanted to see if it was possible anyway :-).
SELECT path
FROM public
WHERE NOT EXISTS (
SELECT * FROM content
WHERE content.path_parent = public.path_parent AND content.path = CONCAT(public.path_without_extn, '.md'))
AND name = '*.html'
This is a fantastic little utility, thanks for putting it together! One of my projects (a statically generated site with over 100k files) has a "audit" requirement which I was wondering whether
fselectmight fulfill.Specifically we need to see if each
*.mdfile in the source directory (e.g.content) has generated one or more files in the destination directory (e.g.public). Wouldfselectbe able to "diff" the entries in thepublicdirectory and indicate whether something in thecontentdirectory appears in the same path in thepublicdirectory?Something like below would be ideal but since the documentation says fselect is not real SQL I wanted to see if it was possible anyway :-).