How to search documents on Fossil CLI?
(1.1) By Sean Ma (maxiangjiang) on 2019-03-27 21:32:56 edited from 1.0 [link] [source]
I found fossil search can only work on timeline entries, while /search is more powerful, which can "Search for check-in comments, documents, tickets, or wiki".
Is it possible to make CLI "fossil search" as powerful as Online "/search"?
(2) By Martijn Coppoolse (vor0nwe) on 2019-03-31 14:36:46 in reply to 1.1 [link] [source]
If search is setup properly (see page /srchsetup), you should be able to run a search command like this one:
fossil sql -list "SELECT name, label, snippet(ftsidx, '*', '*') AS hit FROM ftsidx INNER JOIN ftsdocs ON ftsidx.rowid = ftsdocs.rowid WHERE ftsidx MATCH 'test';"
where you should replace the test at the end by your query.
Seeing as this is quite a long command, it might be a good idea to write a shell script for it, if you want to use it more often.
<style>code{background-color: rgba(222,222,222,0.5);white-space:pre-line}</style>
(3) By Stephan Beal (stephan) on 2019-03-31 14:48:18 in reply to 2 [source]
Just FYI, apparently you need to check the "Use Porter Stemmer" option at the bottom of /srcsetup or the query dies with no such table: ftsidx.
When running that query (after enabling the port stemmer), it ends with:
Error: sqlite3_close() returns 5: unable to close due to unfinalized statements or unfinished backups
here's the full session (and a great example of how triple-backtick code blocks would be really useful ;))...
[stephan@lapdog:~/www/wh]$ fossil sql -list "SELECT name, label, snippet(ftsidx, '*', '*') AS hit FROM ftsidx INNER JOIN ftsdocs ON ftsidx.rowid = ftsdocs.rowid WHERE ftsidx MATCH 'painting' limit 1;"
|Check-in [49e19cb249d6511c] on 2019-03-11 09:58:26|Added /gaming/*painting*/, various touchups in/for the site CSS and index.html template. (user<b>...</b>
Error: sqlite3_close() returns 5: unable to close due to unfinalized statements or unfinished backups