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);