break;
case 'view':
$condition = $commandLine->getLine()[0];
if ($condition == 'all') {
$query = $database->buildViewQuery($commandLine->getTable(), $condition);
} else {
$query = $database->buildViewQuery($commandLine->getTable(), $commandLine->parseWithEquals(0));
}
if ($result = $database->thisConnection()->query($query)) {
$commandLine->printResult($result);
} else {
echo "Could not retrieve data. Make sure your parameters are correct and you have needed foreign keys available.\n";
}
break;
case 'roundtrip':
$database->findRoundTrip($commandLine->getSource(), $commandLine->getDestination(), $commandLine->getDepartDate(), $commandLine->getReturnDate());
break;
case 'flight-res':
if (isset($argv[2])) {
switch ($argv[2]) {
case 'view':
$seatNum = $argv[4];
$flightNum = $argv[3];
$query = "select * from `SeatReservation` `SR` inner join `ScheduledLeg` `SL` on `SR`.`LegNumber` = `SL`.`LegNumber`\n where `SR`.`SeatNumber` = {$seatNum} and `SL`.`FlightNumber` = '{$flightNum}';";
if ($result = $database->thisConnection()->query($query)) {
$commandLine->printResult($result);
} else {
echo "Could not retrieve data. Make sure your parameters are correct and you have needed foreign keys available.\n";
}
break;
case 'cancel':