コード例 #1
0
 public function test_dump_table()
 {
     $file = new File(PATH_TO_ROOT . '/cache/test.php');
     self::$dbms_utils->dump_table(new BufferedFileWriter($file), self::$test_table1, DBMSUtils::DUMP_STRUCTURE_AND_DATA);
     $file->close();
     $content = $file->read();
     $file->delete();
     self::assertEquals("DROP TABLE IF EXISTS `phpboost_test_table_1`;\nCREATE TABLE `phpboost_test_table_1` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `ip` varchar(50) NOT NULL DEFAULT '',\n  `time` date NOT NULL DEFAULT '0000-00-00',\n  `total` int(11) NOT NULL DEFAULT '0',\n  PRIMARY KEY (`id`),\n  KEY `ip` (`ip`)\n) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;\nINSERT INTO `phpboost_test_table_1` (`id`, `ip`, `time`, `total`) VALUES (1,'','',42);\nINSERT INTO `phpboost_test_table_1` (`id`, `ip`, `time`, `total`) VALUES (2,'','',37);\nINSERT INTO `phpboost_test_table_1` (`id`, `ip`, `time`, `total`) VALUES (3,'','',1764);\n", $content);
 }