Bugzilla – Attachment 6775 Details for
Bug 7249
Report webservices
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[SIGNED-OFF] Bug 7249: added saved_sql fields to kohastructure
SIGNED-OFF-Bug-7249-added-savedsql-fields-to-kohas.patch (text/plain), 1.96 KB, created by
Katrin Fischer
on 2011-12-14 07:46:16 UTC
(
hide
)
Description:
[SIGNED-OFF] Bug 7249: added saved_sql fields to kohastructure
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2011-12-14 07:46:16 UTC
Size:
1.96 KB
patch
obsolete
>From f1f4a05a6eea6cbeaf8fafc051afb2d6183e6083 Mon Sep 17 00:00:00 2001 >From: Chris Hall <chrish@catalyst.net.nz> >Date: Tue, 29 Nov 2011 10:21:44 +1300 >Subject: [PATCH] [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@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. >--- > installer/data/mysql/kohastructure.sql | 2 ++ > 1 files changed, 2 insertions(+), 0 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index a03bd23..cecc364 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1626,6 +1626,8 @@ CREATE TABLE saved_sql ( > `report_name` varchar(255) default NULL, > `type` varchar(255) default NULL, > `notes` text, >+ `cache_expiry` int NOT NULL default 300, >+ `public` boolean NOT NULL default FALSE, > PRIMARY KEY (`id`), > KEY boridx (`borrowernumber`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >-- >1.7.5.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 7249
:
6355
|
6358
|
6360
|
6449
|
6773
|
6774
|
6775
|
6801
|
6803
|
9350
|
9351
|
9354
|
9355