Fossil SCM
Provide database access from TH scripts.
7772cc876e640d1…
· opened 17 years, 8 months ago
- Type
- Feature_Request
- Priority
- Immediate
- Severity
- Important
- Resolution
- Open
- Subsystem
- one
- Created
- July 31, 2008 8:48 p.m.
I want to populate a ticket version selector with tag values from the tag table. It appears to be possilbe to put a 'proc' command in the common definitions for tickets and use it to reture values for a combobox but I don't know how to do a database select on the tag table. Is it possible to do a SELECT inside proc?
Tom K.
The (undocumented) TH scripting language is well-suited for doing this kind of thing. But doing so will require a bit of C code for linking TH with SQLite. Such code does not currently exist in fossil.
This seems like a reasonable enhancement request. I'll look into adding it. You might want to write a ticket to so that I don't forget.
D. Richard Hipp
anonymous added on 2011-04-08 23:05:34 UTC: What is the status of this ticket? I would really see this feature added.
anonymous claiming to be anonymous (claiming to be a Feral) added on 2011-04-10 22:17:51 UTC:
You might want to write a ticket to so that I don't forget.
I am going with the assumption that this ticket(7772cc876e) is the aforementioned. As such I offer my "+1" vote to include this and echo Anonymous' comment directly above.
Thank you for Fossil!
anonymous claiming to be RonW added on 2011-04-14 02:29:39 UTC: It looks to me like the dateCmd function in th_main.c could be cloned and modified to create a new function to evaluate a string parameter as an SQL query.
Of course, it might be desirable to add checking to this new queryCmd function before giving the string to sqlite.