routes.php

<?php

include_once dirname(__FILE__) . '/config.php';

/**
 * ID missing entirely
 */
class RouteMapNoIDTest extends WebTestCase {
    public function test() {
        global $webroot, $route;

        $map = $this->post($webroot . "php/routes.php");
        $this->assertText('Error');
    }
}

/**
 * Fetch the route map for core airport
 */
class RouteMapCoreAirportTest extends WebTestCase {
    public function test() {
        global $webroot, $route;

        // First figure out the correct results
        $dbh = db_connect();
        $sth = $dbh->prepare("SELECT DISTINCT src_apid, dst_apid FROM routes WHERE src_ap = ?");
        $sth->execute([$route["core_ap_iata"]]);
        $rows = $sth->rowCount();
        $this->assertTrue($rows >= 1, "No routes found");
        $route["routes"] = $rows;
        $row = $sth->fetch();
        if ($row) {
            $route["core_apid"] = $row["src_apid"];
        }

        // Then test
        $params = array("apid" => $route["core_apid"]);
        $map = $this->post($webroot . "php/routes.php", $params);
        $rows = explode("\n", $map);

        // N;Airport name...
        $this->assertPattern("/" . $route["routes"] . ';/', $rows[0]);

        // Routes (N)
        $rts = explode("\t", $rows[1]);
        $this->assertTrue(sizeof($rts) == $route["routes"], "Route count" . sizeof($rts) . " vs " . $route["routes"]);
    }
}

/**
 * Fetch the route map for core airport with airline filter
 */
class RouteMapCoreAirportFilteredTest extends WebTestCase {
    public function test() {
        global $webroot, $route;

        // First figure out the correct results
        $dbh = db_connect();
        $sth = $dbh->prepare("SELECT DISTINCT src_apid, dst_apid, alid FROM routes WHERE src_ap = ? AND airline = ?");
        $sth->execute([$route["core_ap_iata"], $route["core_ap_filter_iata"]]);
        $rows = $sth->rowCount();
        $this->assertTrue($rows >= 1, "No routes found");
        $route["routes"] = $rows;
        $row = $sth->fetch();
        if ($row) {
            $route["core_apid"] = $row["src_apid"];
            $route["filter_alid"] = $row["alid"];
        }

        // Then test
        $params = array(
            "apid" => $route["core_apid"],
            "alid" => $route["filter_alid"]
        );
        $map = $this->post($webroot . "php/routes.php", $params);
        $rows = explode("\n", $map);

        // N;Airport name...
        $this->assertPattern("/" . $route["routes"] . ';/', $rows[0]);

        // Routes (N)
        $rts = explode("\t", $rows[1]);
        $this->assertTrue(sizeof($rts) == $route["routes"], "Route count" . sizeof($rts) . " vs " . $route["routes"]);
    }
}

/**
 * Airport with no routes -- should still display itself!
 */
class RouteMapNoRouteAirportTest extends WebTestCase {
    public function test() {
        global $webroot, $route;

        // First figure out the correct apid
        $dbh = db_connect();
        $sth = $dbh->prepare("SELECT * FROM airports WHERE iata = ?");
        $sth->execute([$route["noroute_ap_iata"]]);
        $this->assertTrue($row = $sth->fetch(), "No-route airport not found");
        $route["noroute_apid"] = $row["apid"];

        // Then test
        $params = array("apid" => $route["noroute_apid"]);
        $map = $this->post($webroot . "php/routes.php", $params);
        $rows = explode("\n", $map);

        // N;Airport name...
        $this->assertPattern("/0;/", $rows[0]);

        // No routes
        $this->assertTrue($rows[1] == "", "Route count");

        // One airport, with details
        $aps = explode("\t", $rows[2]);
        $this->assertTrue(sizeof($aps) == 1, "Airport count");
        $this->assertText(":" . $row["apid"] . ":" . $row["x"] . ":" . $row["y"]);
    }
}

/**
 * Invalid airport ID
 */
class RouteMapInvalidAirportTest extends WebTestCase {
    public function test() {
        global $webroot, $route;

        $params = array("apid" => $route["invalid_apid"]);
        $map = $this->post($webroot . "php/routes.php", $params);
        $this->assertText('Error');
    }
}

/**
 * Fetch the route map for core airline
 */
class RouteMapCoreAirlineTest extends WebTestCase {
    public function test() {
        global $webroot, $route;

        // First figure out the correct results
        $dbh = db_connect();
        $sth = $dbh->prepare("SELECT DISTINCT src_apid,dst_apid,alid FROM routes WHERE airline = ? AND codeshare=''");
        $sth->execute([$route["core_al_iata"]]);
        $rows = $sth->rowCount();
        $this->assertTrue($rows >= 1, "No routes found");
        $route["routes"] = $rows;
        $row = $sth->fetch();
        if ($row) {
            $route["core_alid"] = $row["alid"];
        }

        // Then test
        $params = array("apid" => "L" . $route["core_alid"]);
        $map = $this->post($webroot . "php/routes.php", $params);
        $rows = explode("\n", $map);

        // N;Airline name...
        $this->assertPattern("/" . $route["routes"] . ';/', $rows[0]);

        // Routes (N)
        $rts = explode("\t", $rows[1]);
        $this->assertTrue(sizeof($rts) == $route["routes"], "Route count");
    }
}

/**
 * Fetch route map for core airline
 */
class RouteMapCoreAirlineWithCodesharesTest extends WebTestCase {
    public function test() {
        global $webroot, $route;

        // First figure out the correct results
        $dbh = db_connect();
        $sth = $dbh->prepare("SELECT DISTINCT src_apid, dst_apid, alid FROM routes WHERE airline = ?");
        $sth->execute([$route["core_al_iata"]]);
        $rows = $sth->rowCount();
        $this->assertTrue($rows >= 1, "No routes found");
        $route["routes"] = $rows;
        $row = $sth->fetch();
        if ($row) {
            $route["core_alid"] = $row["alid"];
        }

        // Then test
        $params = array(
            "apid" => "L" . $route["core_alid"],
            "alid" => "1"
        ); // any non-zero alid triggers codeshares
        $map = $this->post($webroot . "php/routes.php", $params);
        $rows = explode("\n", $map);

        // N;Airline name...
        $this->assertPattern("/" . $route["routes"] . ';/', $rows[0]);

        // Routes (N)
        $rts = explode("\t", $rows[1]);
        $this->assertTrue(sizeof($rts) == $route["routes"], "Route count");
    }
}

/**
 * Airline with no routes
 */
class RouteMapNoRouteAirlineTest extends WebTestCase {
    public function test() {
        global $webroot, $route;

        // First figure out the correct airport id
        $dbh = db_connect();
        $sth = $dbh->prepare("SELECT * FROM airlines WHERE iata = ?");
        $sth->execute([$route["noroute_al_iata"]]);
        $this->assertTrue($row = $sth->fetch(), "No-route airline not found");
        $route["noroute_alid"] = $row["alid"];

        // Then test
        $params = array("apid" => "L" . $route["noroute_apid"]);
        $map = $this->post($webroot . "php/routes.php", $params);
        $rows = explode("\n", $map);

        // N;Airport name...
        $this->assertPattern("/0;/", $rows[0]);

        // Routes (N)
        $this->assertTrue($rows[1] == "", "Route count");

        // Airports (N+1)
        $aps = explode("\t", $rows[2]);
        $this->assertTrue(sizeof($aps) == 1, "Airport count");
    }
}

/**
 * Invalid airline ID
 */
class RouteMapInvalidAirlineTest extends WebTestCase {
    public function test() {
        global $webroot, $route;

        $params = array("apid" => "L" . $route["invalid_alid"]);
        $map = $this->post($webroot . "php/routes.php", $params);
        $this->assertText('Error');
    }
}