Use {@link SqlMapGateway getSqlMapGateway()} property to obtain the gateway
instance used for querying statements defined in the SqlMap configuration files.
$conn = new TDbConnection($dsn,$dbuser,$dbpass);
$manager = new TSqlMapManager($conn);
$manager->configureXml('mydb-sqlmap.xml');
$sqlmap = $manager->getSqlMapGateway();
$result = $sqlmap->queryForObject('Products');
/** * Create and configure the data mapper using sqlmap configuration file. * Or if cache is enabled and manager already cached load from cache. * If cache is enabled, the data mapper instance is cached. * * @return TSqlMapManager SqlMap manager instance * @since 3.1.7 */ public function getSqlMapManager() { if (($manager = $this->loadCachedSqlMapManager()) === null) { $manager = new TSqlMapManager($this->getDbConnection()); if (strlen($file = $this->getConfigFile()) > 0) { $manager->configureXml($file); $this->cacheSqlMapManager($manager); } } elseif ($this->getConnectionID() !== '') { $manager->setDbConnection($this->getDbConnection()); } return $manager; }
protected function getMysqlSqlMapManager() { static $conn; static $sqlMapManager; if (Prado::getApplication() === null) { Prado::setApplication(new TApplication(dirname(__FILE__) . '/app')); } if ($conn === null) { $conn = new TDbConnection('mysql:host=localhost;dbname=prado_unitest', 'prado_unitest', 'prado_unitest'); } $conn->setActive(true); if ($sqlMapManager === null) { $sqlMapManager = new TSqlMapManager($conn); $sqlMapManager->configureXml(dirname(__FILE__) . '/DynamicParameterTestMap.xml'); } return $sqlMapManager; }