private function inject($query, $parameters = array())
{
$this->querier->disable_query_translator();
$result = $this->querier->inject($query, $parameters);
$this->querier->enable_query_translator();
return $result;
}
public function setUp()
{
self::$test_table1 = PREFIX . 'test_table_1';
self::$test_table2 = PREFIX . 'test_table_2';
$connection = DBFactory::get_db_connection();
self::$querier = DBFactory::new_sql_querier($connection);
self::$querier->disable_query_translator();
self::$dbms_utils = new MySQLDBMSUtils(self::$querier);
self::$querier->inject("DROP TABLE IF EXISTS `" . self::$test_table1 . "`");
self::$querier->inject("CREATE TABLE `" . self::$test_table1 . "` (\n\t\t\t `id` int(11) NOT NULL auto_increment,\n\t\t\t `ip` varchar(50) NOT NULL default '',\n\t\t\t `time` date NOT NULL default '0000-00-00',\n\t\t\t `total` int(11) NOT NULL default '0',\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `ip` (`ip`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
self::$querier->inject("INSERT INTO `" . self::$test_table1 . "` (`ip`, `time`, `total`) VALUES (:ip, NOW(), :total)", array('ip' => '127.0.0.1', 'total' => 42));
self::$querier->inject("INSERT INTO `" . self::$test_table1 . "` (`ip`, `time`, `total`) VALUES (:ip, DATE(:time), :total)", array('ip' => '127.0.0.2', 'time' => '2003-12-31 01:02:03', 'total' => 37));
self::$querier->inject("INSERT INTO `" . self::$test_table1 . "` (`ip`, `time`, `total`) VALUES (:ip, CURDATE(), :total)", array('ip' => '127.0.0.3', 'total' => 1764));
self::$querier->inject("DROP TABLE IF EXISTS `" . self::$test_table2 . "`");
self::$querier->inject("CREATE TABLE `" . self::$test_table2 . "` (\n\t\t\t `pk` int(11) NOT NULL auto_increment,\n\t\t\t `name` varchar(50) NOT NULL default '',\n\t\t\t PRIMARY KEY (`pk`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
}
/**
* {@inheritDoc}
*/
public function disable_query_translator()
{
$this->querier->disable_query_translator();
}
