public static function getAllArgumentOptions()
{
$dbutil = new SQLUtil();
$sql = "SELECT A.name AS argument_name, A.id AS argument_id, O.name AS argument_option_name, O.id AS argument_option_id, O.short_name AS argument_option_short_name FROM argument A, argument_option O WHERE O.argument_id = A.id";
$res = $dbutil->executeSql($sql);
$retArr = $dbutil::interpretQueryResponse($res);
return $retArr;
}
public static function getAllArguments()
{
$dbUtil = new SQLUtil();
$sql = "SELECT C.name AS command_name, C.id AS command_id, A.name AS argument_name, A.id AS argument_id, A.requires_option,\n A.requires_argument_child, A.argument_tier, A.argument_parent, A.user_defined\n FROM command C, argument A\n WHERE A.command_id = C.id";
$res = $dbUtil->executeSql($sql);
$retArr = $dbUtil->interpretQueryResponse($res);
return $retArr;
}
public static function getAllCommandOptions()
{
$dbutil = new SQLUtil();
$sql = "SELECT C.name AS command_name, C.id AS command_id, O.name AS command_option_name, O.id AS command_option_id, O.short_name AS command_option_short_name FROM command C, command_option O WHERE O.command_id = C.id";
$res = $dbutil->executeSql($sql);
$retArr = $dbutil::interpretQueryResponse($res);
return $retArr;
}
public static function getCommandStructure()
{
$dbutil = new SQLUtil();
$sql = "SELECT C.name AS command_name, C.id AS command_id, A.name AS argument_name, A.id AS argument_id FROM command C LEFT JOIN argument A ON C.id = A.command_id";
$res = $dbutil->executeSql($sql);
$retArr = $dbutil::interpretQueryResponse($res);
return $retArr;
}
