<?php use yellotravel\asl\airportsDataGenerator; use PhpSchool\CliMenu\CliMenu; use PhpSchool\CliMenu\CliMenuBuilder; require 'vendor/autoload.php'; $art = <<<ART /\\ |{}| _______/^^\\______ / | | \\ `====----. .----====` |||| || ,--||--, '--<>--' Yello Travel GENERATING DATA FOR API SERVER! ART; $menu = (new CliMenuBuilder())->addAsciiArt($art)->addLineBreak('-')->setTitle('Data Generator')->addItem('Airports data generate!', function () { airportsDataGenerator::generate(); })->addLineBreak('-')->setForegroundColour('yellow')->setBackgroundColour('black')->build(); $menu->open();
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()); }