## ===================================## SQL queries for services DAO class.## ===================================select_script = SELECT SCRIPT_ID, SCRIPT_NAME, SCRIPT_CLASS_NAME, SCRIPT_DESCRIPTION FROM QX_SCRIPT WHERE SCRIPT_ID = ?select_script_by_name = SELECT SCRIPT_ID, SCRIPT_NAME, SCRIPT_CLASS_NAME, SCRIPT_DESCRIPTION FROM QX_SCRIPT WHERE SCRIPT_NAME = ?select_all_script = SELECT SCRIPT_ID, SCRIPT_NAME, SCRIPT_CLASS_NAME, SCRIPT_DESCRIPTION FROM QX_SCRIPTselect_script_parameters = SELECT SCRIPT_PARAM_NAME, DEF_VALUE, REQUIRED, SCRIPT_PARAM_TYPE_ID FROM QX_SCRIPT_PARAM WHERE SCRIPT_ID = ?delete_task = DELETE FROM QX_TASK WHERE TASK_ID = ?update_task = UPDATE QX_TASK SET TASK_STATUS_ID = ?, NEXT_START = ? WHERE TASK_ID = ?select_task = SELECT TASK_ID, SCRIPT_ID, TASK_NAME, TASK_STATUS_ID, DELAY, TASK_DELAYUNIT_ID, REPEAT_SIGN, AUTO_START, FIRST_START, NEXT_START FROM QX_TASK WHERE TASK_ID = ?select_all_task = SELECT TASK_ID, SCRIPT_ID, TASK_NAME, TASK_STATUS_ID, DELAY, TASK_DELAYUNIT_ID, REPEAT_SIGN, AUTO_START, FIRST_START, NEXT_START FROM QX_TASKselect_task_parameters = SELECT SP.SCRIPT_PARAM_NAME, TP.VALUE, SP.REQUIRED, SP.SCRIPT_PARAM_TYPE_ID FROM QX_SCRIPT_PARAM SP, QX_TASK_PARAM TP WHERE TP.TASK_ID = ? AND TP.SCRIPT_PARAM_ID = SP.SCRIPT_PARAM_ID