* facades for sql maps

4 files changed, 62 insertions, 0 deletions

diff --git a/app/php/application.xml b/app/php/application.xml
index 409f957..3c378bd 100644
--- a/app/php/application.xml
+++ b/app/php/application.xml
@@ -3,6 +3,7 @@
 
   <include file="Application.db.config" />
   <include file="Application.model.config" />
+  <include file="Application.facades.config" />
   <include file="Application.user.config" />
   <include file="Application.url.config" />
   <include file="Application.components.config" />
diff --git a/app/php/facades/Facade.php b/app/php/facades/Facade.php
new file mode 100644
index 0000000..5d71a89
--- /dev/null
+++ b/app/php/facades/Facade.php
@@ -0,0 +1,43 @@
+<?php
+
+class Facade {
+
+    protected static $_instances = array();
+
+    protected $_sqlMap;
+
+    protected function __construct() {
+        $this->_sqlMap = Prado::getApplication()->getModule('sqlmap')->Client;
+    }
+
+    public static function getInstance() {
+        $className = get_called_class();
+        if (!isset(static::$_instances[$className])) {
+            static::$_instances[$className] = new static();
+        }
+        return static::$_instances[$className];
+    }
+
+    protected function getClient() {
+        return $this->_sqlMap;
+    }
+
+    protected function quoteString($string) {
+        return $this->getClient()->DbConnection->quoteString($string);
+    }
+
+    protected function fetch($sqlMap, $params) {
+        return $this->getClient()->queryForObject($sqlMap, $params);
+    }
+
+    protected function fetchList($sqlMap, $params) {
+        return $this->getClient()->queryForList($sqlMap, $params);
+    }
+
+    protected function fetchMap($sqlMap, $params, $key, $value=NULL) {
+        return $this->getClient()->queryForMap($sqlMap, $params, $key, $value);
+    }
+
+}
+
+?>
diff --git a/app/php/facades/config.xml b/app/php/facades/config.xml
new file mode 100644
index 0000000..8d5a298
--- /dev/null
+++ b/app/php/facades/config.xml
@@ -0,0 +1,10 @@
+<?xml version="1.0" encoding="utf-8"?>
+<configuration>
+  <modules>
+    <module id="sqlmap"
+            class="System.Data.SqlMap.TSqlMapConfig"
+            ConnectionID="db"
+            ConfigFile="Application.sqlmap.config"
+            EnableCache="true" />
+  </modules>
+</configuration>
diff --git a/app/php/sqlmap/config.xml b/app/php/sqlmap/config.xml
new file mode 100644
index 0000000..7c213a3
--- /dev/null
+++ b/app/php/sqlmap/config.xml
@@ -0,0 +1,8 @@
+<?xml version="1.0" encoding="utf-8"?>
+<sqlMapConfig>
+  <provider class="TAdodbProvider">
+    <datasource ConnectionID="db" />
+  </provider>
+  <sqlMaps>
+  </sqlMaps>
+</sqlMapConfig>