Adding SQLMap unit tests. Allow sqlmap to use Prado's caching module to cache records.

4 files changed, 6 insertions, 2 deletions

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
--- a/demos/sqlmap-sample/protected/runtime/application.xml/config.cache
+++ /dev/null
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
--- a/demos/sqlmap-sample/protected/runtime/application.xml/sqlite.cache
+++ /dev/null