2 files changed, 53 insertions, 0 deletions
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>