public function testGenerate()
{
// 테스트 하기 전에 csv 파일, table을 지우고 시작한다.
if (file_exists(self::AIRPORTS_INFO_CSV_PATH)) {
unlink(self::AIRPORTS_INFO_CSV_PATH);
}
if (file_exists(self::AIRPORTS_CODE_CSV_PATH)) {
unlink(self::AIRPORTS_CODE_CSV_PATH);
}
$pdo = airportsDataGenerator::getPdoInstance();
$pdo->exec("DROP TABLE airports");
$pdo->exec("DROP TABLE airports_info");
$pdo->exec("DROP TABLE airports_code");
// table[airports, airports_info, airports_table]에 데이터를 넣는다.
airportsDataGenerator::generate();
// table을 확인한다.
$stmt = $pdo->query("SELECT * FROM airports");
$this->assertEquals(1125, $stmt->rowCount());
$stmt = $pdo->query("SELECT * FROM airports_code");
$this->assertEquals(7316, $stmt->rowCount());
$stmt = $pdo->query("SELECT * FROM airports_info");
$this->assertEquals(1128, $stmt->rowCount());
}
