From f6a5e7589396854e10e023c25237b47e512ff047 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Fri, 14 Apr 2006 11:23:56 +0000
Subject: Adding SQLMap unit tests. Allow sqlmap to use Prado's caching module
 to cache records.

---
 demos/sqlmap-sample/protected/petshop-db/products.xml   |   7 ++++++-
 .../protected/runtime/application.xml/config.cache      | Bin 2101 -> 0 bytes
 .../protected/runtime/application.xml/global.cache      |   1 -
 .../protected/runtime/application.xml/sqlite.cache      | Bin 19456 -> 0 bytes
 4 files changed, 6 insertions(+), 2 deletions(-)
 delete mode 100644 demos/sqlmap-sample/protected/runtime/application.xml/config.cache
 delete mode 100644 demos/sqlmap-sample/protected/runtime/application.xml/global.cache
 delete mode 100644 demos/sqlmap-sample/protected/runtime/application.xml/sqlite.cache

(limited to 'demos/sqlmap-sample')

diff --git a/demos/sqlmap-sample/protected/petshop-db/products.xml b/demos/sqlmap-sample/protected/petshop-db/products.xml
index bf1453b2..3c2899a7 100644
--- a/demos/sqlmap-sample/protected/petshop-db/products.xml
+++ b/demos/sqlmap-sample/protected/petshop-db/products.xml
@@ -1,7 +1,12 @@
 <?xml version="1.0" encoding="utf-8" ?>
 <sqlmap>
 
-	<select id="SelectAllProducts">
+	<cacheModel id="product-cache" implementation="basic">
+		<!-- cache data for 60 seconds -->
+		<property name="expiry" value="60" /> 
+	</cacheModel>
+
+	<select id="SelectAllProducts" cacheModel="product-cache" >
 		SELECT * 
 		FROM 
 			product
diff --git a/demos/sqlmap-sample/protected/runtime/application.xml/config.cache b/demos/sqlmap-sample/protected/runtime/application.xml/config.cache
deleted file mode 100644
index ce7bd76a..00000000
Binary files a/demos/sqlmap-sample/protected/runtime/application.xml/config.cache and /dev/null differ
diff --git a/demos/sqlmap-sample/protected/runtime/application.xml/global.cache b/demos/sqlmap-sample/protected/runtime/application.xml/global.cache
deleted file mode 100644
index b35e9768..00000000
--- a/demos/sqlmap-sample/protected/runtime/application.xml/global.cache
+++ /dev/null
@@ -1 +0,0 @@
-a:1:{s:35:"prado:securitymanager:validationkey";s:32:"e632288aebf1e51c0447ab4b701f1aa7";}
\ No newline at end of file
diff --git a/demos/sqlmap-sample/protected/runtime/application.xml/sqlite.cache b/demos/sqlmap-sample/protected/runtime/application.xml/sqlite.cache
deleted file mode 100644
index be9b9cc0..00000000
Binary files a/demos/sqlmap-sample/protected/runtime/application.xml/sqlite.cache and /dev/null differ
-- 
cgit v1.2.3