def define_call(where_colum, where_colum_snd='', where_colum_trd=''): db = CRUD() datas = db.readDB(schema='public', table='tbl_code_define', colum='code, code_name', condition=f"WHERE code_class = '{where_colum}' OR code_class = '{where_colum_snd}' OR code_class = '{where_colum_trd}'") data_list = [] for data in datas: data_list.append({'code': data[0], 'code_name': data[1]}) return data_list
def get_ans_list_value_call(self): db = CRUD() datas = db.readDB( schema='public', table='tbl_diag_ans_list_group', colum= 'diag_ans_list_group_code, diag_ans_list_val_code, display_order', condition="") data_list = [] for data in datas: data_list.append({ 'diag_ans_list_group_code': data[0], 'diag_ans_list_val_code': data[1], 'display_order': data[2] }) return data_list
def qa_data_call(self): db = CRUD() datas = db.readDB( schema='public', table='tbl_diagnostics_qa', colum= 'device_type_code, op_mechanism_code, abnormal_status_code, diag_qa_pattern_code' ) data_list = [] for data in datas: data_list.append({ 'device_type_code': data[0], 'op_mechanism_code': data[1], 'abnormal_status_code': data[2], 'diag_qa_pattern_code': data[3] }) return data_list
def model_call(self): db = CRUD() datas = db.readDB( schema='public', table='tbl_model_info', colum= 'model_no, device_type_code, op_mechanism_code, voltage_class_code, gas_pressure_lock_value' ) data_list = [] for data in datas: data_list.append({ 'model_no': data[0], 'device_type_code': data[1], 'op_mechanism_code': data[2], 'voltage_class_code': data[3], 'gas_pressure_lock_value': float(data[4]) }) return data_list
def qa_list_data_call(self): db = CRUD() datas = db.readDB( schema='public', table='tbl_diag_qa_pattern', colum= 'device_type_code, diag_qa_pattern_code, diag_question_code, diag_question_no, diag_ans_reg_method_code, diag_ans_list_group_code' ) data_list = [] for data in datas: data_list.append({ 'device_type_code': data[0], 'diag_qa_pattern_code': data[1], 'diag_question_code': data[2], 'diag_question_no': data[3], 'diag_ans_reg_method_code': data[4], 'diag_ans_list_group_code': data[5] }) return data_list