On Thu, May 31, 2012 at 5:50 AM, Chen, Zon <[email protected]>wrote:
> Would it be possible to please make the SQL of the reports used by the
> fossil project viewable by anonymous users? Or alternatively, if they
> could be cut-pasted into the wiki.
>
IIRC[1], the current implementation requires write access to the
reports (the "t" permission) in order to be able to read the raw SQL. IMO
that is the correct behaviour because the SQL is an implementation detail.
(That's how i implemented it in the JSON API, in any case.)
There is nothing stopping a fossil admin from dumping the report SQL into a
wiki page. That could be done with a little scripting...
stephan@tiny:~/cvs/fossil/fossil$ f json report list
{
"fossil":"bdc29eb897210da6ccb535046e525e44c8a3b10c",
"timestamp":1338481168,
"command":"report/list",
"procTimeMs":12,
"payload":[
{
"report":1,
"title":"All Tickets",
"owner":"drh"
},
{
"report":2,
"title":"All open tickets.",
"owner":"drh"
},
...
stephan@tiny:~/cvs/fossil/fossil$ f json report get 1
{
"fossil":"bdc29eb897210da6ccb535046e525e44c8a3b10c",
"timestamp":1338481194,
"command":"report/get",
"procTimeMs":12,
"payload":{
"report":1,
"owner":"drh",
"title":"All Tickets",
"timestamp":1326377920,
<snip>
it would be easy to write such a beast using a perl/php/ruby/java/etc (and,
if it absolutely must be so, even python).
The "wiki commit" command (or "json wiki save") could be used to import the
SQL into a wiki page.
[1] == i'm too tired to go dig around to get the definitive answer :/
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
