[Koha-bugs] [Bug 7249] Report webservices

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7249

--- Comment #14 from Katrin Fischer <katrin.fischer at bsz-bw.de> 2011-12-14 07:46:16 UTC ---
Created attachment 6775
  --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6775
[SIGNED-OFF] Bug 7249: added saved_sql fields to kohastructure

http://bugs.koha-community.org/show_bug.cgi?id=7249
Signed-off-by: Katrin Fischer <Katrin.Fischer.83 at web.de>
Patches applied on top of patches for bug 7248.
Patch includes another database adding 2 new fields to the saved_sql table.

1) Checked that adding/deleting/editing of sql reports still works and new
fields are correctly saved to the database.

2) The saved reports page now lists the new fields correctly.

3) Checking URLs with JSON output
- if report is not public http://localhost/cgi-bin/koha/svc/report?id=2 fails,
but http://localhost:8080/cgi-bin/koha/svc/report?id=2 works
- if report is public, both links work

4) Checking results are cached
Created a report listing my borrowers, setting caching to 60 seconds and
added new borrowers before doing following tests.
- URL doesn't show new borrower immediately - correct
- Turning off the usecache system preference updates data - correct
- Restarting memcached updates data '/etc/init.d/memcached restart' - correct
- Waiting until cache time runs out updates data - correct

Small enhancement request: Use yes/no instead of true/false.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.