scripts/libs/SQL/sqlQueries.ctl - master - Puzzman/setPointMap

scripts/libs/SQL/sqlQueries.ctl
28 строк2 KB
Sergey
refactor
13 май 2025, 16:44
13 май 2025, 16:44e49876e


const string getNameTabs          = "SELECT * FROM tabs ORDER BY id ASC";
const string getNameTabsAnalog    = "SELECT * FROM tabs_analog ORDER BY id ASC";
const string getObjects           = "SELECT * FROM $1 ORDER BY id ASC";

const string getDataFromSQL = "select obj_name, obj_tag, "
                              "array_to_string(ARRAY(select ust_name FROM ust_name_$2 order by id), ';'), "
                              "array_to_string(ARRAY(select tag FROM ust_name_$2 order by id), ';'), "
                              "array_to_string(ARRAY(select unit FROM ust_name_$2 order by id), ';'), "
                              "replace(array_to_string(ARRAY(select paths FROM ust_name_$2 order by id), ';'), '$1', obj_tag), "
                              "array_to_string(values, ';'), "
                              "array_to_string(ARRAY(select format FROM ust_name_$2 order by id), ';') "
                              "from $2 order by id;";


const string getDataFromSQLanalog = "select obj_name, obj_tag, unit, "
                                    "array_to_string(ARRAY(select ust_name FROM ust_name_$2 order by id), ';'), "
                                    "array_to_string(ARRAY(select tag FROM ust_name_$2 order by id), ';'), "
                                    "array_to_string(ARRAY(select unit FROM ust_name_$2 order by id), ';'), "
                                    "replace(array_to_string(ARRAY(select paths FROM ust_name_$2 order by id), ';'), '$1', obj_tag), "
                                    "array_to_string(values, ';'), "
                                    "array_to_string(activity_settings, ';'), "
                                    "format, "
                                    "array_to_string(ARRAY(select format FROM ust_name_$2 order by id), ';') "
                                    "from $2 order by id;";


const string writeToDb = "UPDATE $1 SET values =  ARRAY[$2] WHERE obj_tag = '$3';";
const string writeToDbSettings = "UPDATE $1 SET activity_settings =  ARRAY[$2] WHERE obj_tag = '$3';";