public function setUp() { $this->test_table = PREFIX . 'test_table'; $connection = DBFactory::get_db_connection(); $sql_querier = DBFactory::new_sql_querier($connection); $this->dbms_utils = new MySQLDBMSUtils($sql_querier); $this->querier = new DBQuerier($sql_querier); $this->drop_test_table(); $this->create_test_table(); $this->populate_test_table(); }
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;"); }
/** * Returns the sql querier * @return SQLQuerier */ private static function get_sql_querier() { if (self::$sql_querier === null) { self::$sql_querier = DBFactory::new_sql_querier(DBFactory::get_db_connection()); } return self::$sql_querier; }