} else {
echo "Update failed. Make sure your parameters are correct and you have needed foreign keys available.\n";
}
break;
case 'delete':
$query = $database->buildDeleteQuery($commandLine->getTable(), $commandLine->parseWithEquals(0));
if ($database->thisConnection()->query($query)) {
echo "Delete Succeeded.\n";
} else {
echo "Delete failed. Make sure your parameters are correct and you have needed foreign keys available.\n";
}
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]) {
