Fossil

  sqlite3_exec_readonly(g.db, zSql, output_separated_file, &count, &zErr2);
  report_unrestrict_sql();
  if( zFilter ){
    free(zSql);
  }
}


void rptshowJson( 
    const char *zRep,
    char const * zLimit,
    const char *zFilter,
    char indention
){
  Stmt q;
  char *zSql;
  char const *zTitle;
  char const *zOwner;
  char *zClrKey;
  char *zErr1 = 0;
  int count = 0;
  int rn;
  int rc;
  cson_value * zJVal = NULL;

  if (!zRep || !strcmp(zRep,zFullTicketRptRn) || !strcmp(zRep,zFullTicketRptTitle) ){
    zTitle = zFullTicketRptTitle;
    zSql = mprintf("SELECT * FROM ticket");
    zOwner = g.zLogin;
    zClrKey = "";
  }else{
    rn = atoi(zRep);
    if( rn ){
      db_prepare(&q,
       "SELECT title, sqlcode, owner, cols FROM reportfmt WHERE rn=%d", rn);
    }else{
      db_prepare(&q,
       "SELECT title, sqlcode, owner, cols FROM reportfmt WHERE title=%Q", zRep);
    }
    if( db_step(&q)!=SQLITE_ROW ){
      db_finalize(&q);
      rpt_list_reports();
      fossil_fatal("unkown report format(%s)!",zRep);
    }
    zTitle = db_column_malloc(&q, 0)/*leak!*/;
    zSql = db_column_malloc(&q, 1);
    zOwner = db_column_malloc(&q, 2)/*leak!*/;
    zClrKey = db_column_malloc(&q, 3);
    db_finalize(&q);
  }
  if( zFilter ){
    char * old = zSql;
    zSql = mprintf("SELECT * FROM (%s) WHERE %s%s%s",old,zFilter,
             (zLimit?" LIMIT ":""), (zLimit?zLimit:""));
    free(old);
  }else if( zLimit ){
    char * old = zSql;
    zSql = mprintf("%s LIMIT %s",old, zLimit);
    free(old);
  }
  count = 0;
  /*fprintf(stderr,"SQL=[%s]\n",zSql);*/
  sqlite3_set_authorizer(g.db, report_query_authorizer, (void*)&zErr1);
  rc = cson_sqlite3_sql_to_json(g.db, &zJVal, zSql, 1);
  if( 0 == rc ){
      cson_output_opt outOpt = cson_output_opt_empty;
      outOpt.addNewline = 1;
      outOpt.indentation = indention;
      rc = cson_output_FILE( zJVal, stdout, &outOpt );
  } else{
    fossil_fatal("sql-to-json failed with code %d (%s)!", rc,
                 cson_rc_string(rc));
  }
  sqlite3_set_authorizer(g.db, 0, 0);
  cson_value_free(zJVal);
  free(zSql);
  free(zClrKey);
}