On Wed, Oct 23, 2013 at 9:58 AM, Jeff Rogers <dv...@diphi.com> wrote: > Hi all, > > I put together a quick external script to do full-text searches on tickets.
Nice, and thanks for sharing. > It's not anything complicated, just creates a sqlite fts table and dumps all > the ticket info into it, which means that it doesn't update automatically > when tickets are updated. Still, I've found it useful, so I'm sharing it in > case anyone else does. Looking at the code I see that it already works incrementally, at least in terms of new (= unknown) tickets. It might be possible to extend that to ticket changes by taking the "tkt_mtime" column of table TICKET into account. I believe that a ticket change will update this field. At that point the script should be cron-able, updating the search daily, or some such. Another area for extension is the TICKETCHNG table of fossil. This adjunct to TICKET contains the history of user comments for a ticket (field "icomment"). Putting this into the fts extends the reach of the search from the initial description to the whole set of comments on a ticket. > > The nice thing is that fossil doesn't care if there are other tables in the > database, so nothing changes from fossil's perspective. Yes. > > -J > > PS: I've included the script as an attachment, if the mailing list strips > that I'll resend or share it somewhere else. The attachment came through just fine. -- Andreas Kupries Senior Tcl Developer Code to Cloud: Smarter, Safer, Fasterâ„¢ F: 778.786.1133 andre...@activestate.com http://www.activestate.com Learn about Stackato for Private PaaS: http://www.activestate.com/stackato _______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users