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