public function testCreateSuccess() { $db = new Mysql(self::$db); $db->query(Database::dropTable(self::TABLE_NAME)); $db->createTable(self::TABLE_NAME); $db->createColumn(self::TABLE_NAME, 'col1', AbstractMigration::TYPE_INT); $db->createColumn(self::TABLE_NAME, 'col2', AbstractMigration::TYPE_TEXT); $db->query(Database::dropTable('test_black_table1')); $db->createTable('test_black_table1'); $db->query(Database::dropTable('test_black_table2')); $db->createTable('test_black_table2'); $testData = array('id' => '1', 'col1' => '11', 'col2' => '<p>ZFCTool - Zend Framework 2 command line Tool</p>'); $db->insert(self::TABLE_NAME, $testData); $dumpName = self::$manager->create(self::FIXTURE_MODULE, self::DUMP_FILE_NAME, self::TABLE_NAME, 'test_black_table1,test_black_table2'); $compareTo = Database::getDisableChecksNotation() . Database::dropTable(self::TABLE_NAME) . ';' . PHP_EOL . Database::createTable(self::TABLE_NAME) . ';' . PHP_EOL . Database::insert(self::TABLE_NAME, $testData) . ';' . PHP_EOL; $this->assertEquals(self::DUMP_FILE_NAME, $dumpName); $dumpFullPath = self::$manager->getDumpsDirectoryPath(self::FIXTURE_MODULE) . DIRECTORY_SEPARATOR . $dumpName; if (file_exists($dumpFullPath)) { $dump = file_get_contents($dumpFullPath); $this->assertEquals($compareTo, $dump); } else { $this->fail('Dump file not exist!'); } //Test generate name and creating file $dumpName = self::$manager->create(null, null, self::TABLE_NAME, 'test_black_table1,test_black_table2'); $dumpFullPath = self::$manager->getDumpsDirectoryPath() . DIRECTORY_SEPARATOR . $dumpName; if (file_exists($dumpFullPath)) { $dump = file_get_contents($dumpFullPath); $this->assertEquals($compareTo, $dump); unlink($dumpFullPath); } else { $this->fail('Dump file not exist!'); } $db->dropTable(self::TABLE_NAME); $db->dropTable('test_black_table1'); $db->dropTable('test_black_table2'); }