if ($database->thisConnection()->query($query)) { echo "Update Succeeded.\n"; } 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':