def update_output_flow(output_flow, model, conn): params = [] query_set = """ ModelId =?, Name =?, WaterFlowId =?, MassFlowId =?, DistributionFlowId =?, PositionX =?, PositionY =? WHERE Id=? """ query = query_update + query_set params = [ model.id, output_flow.name, output_flow.waterFlowId, output_flow.massFlowId, output_flow.distributionId, output_flow.positionX, output_flow.positionY ] for p in params: if (p == None): p = 'NULL' sqlite_wrapper.run_query(conn, query, params) return output_flow.id
def delete_parameters_not_saved(parameters_saved, model, conn): params = [] query = """ DELETE FROM TB_PARAMETER WHERE Id NOT IN ( {id} ) AND ModelId =? """ query = query.replace( '{id}', sqlite_wrapper.get_params_by_size(len(parameters_saved))) for p in parameters_saved: params.append(p) params.append(model.id) sqlite_wrapper.run_query(conn, query, params)
def delete_output_flows_not_saved(output_flows_saved, model, conn): params = [] query = """ DELETE FROM TB_OUTPUT_FLOW WHERE Id NOT IN ( {id} ) AND ModelId =? """ query = query.replace( '{id}', sqlite_wrapper.get_params_by_size(len(output_flows_saved))) for p in output_flows_saved: params.append(p) params.append(model.id) sqlite_wrapper.run_query(conn, query, params)
def get_processes_by_type(type_id, conn): processes = [] query_where = """ WHERE ProcessType =? """ query = query_select + query_where param = [type_id] rows = sqlite_wrapper.run_query(conn, query, param) for row in rows: processes.append(Process(row)) return processes
def get_process_type_by_id(id, conn): types = [] query_where = """ WHERE Id =? """ query = query_select + query_where param = [id] rows = sqlite_wrapper.run_query(conn, query, param) for row in rows: types.append(ProcessType(row)) return types
def update_model(model, conn): params = [] query_set = """ Name =?, ScriptHead =?, ScriptBody =?, ScriptTail =? WHERE Id=? """ query = query_update + query_set params = [ model.name, model.scriptHead, model.scriptBody, model.scriptTail, model.id ] for p in params: if (p == None): p = 'NULL' sqlite_wrapper.run_query(conn, query, params) return model.id
def get_results_from_model(model_id, conn): results = [] query_where = """ WHERE ModelId =? """ query = query_select + query_where param = [model_id] rows = sqlite_wrapper.run_query(conn, query, param) for row in rows: results.append(Result(row)) return results
def get_models_by_process_id(id, conn): models = [] query_where = """ WHERE ProcessId =? """ query = query_select + query_where param = [id] rows = sqlite_wrapper.run_query(conn, query, param) for row in rows: models.append(Model(row)) return models
def get_parameters_from_model(model_id, conn): parameters = [] query_where = """ WHERE ModelId =? """ query = query_select + query_where param = [model_id] rows = sqlite_wrapper.run_query(conn, query, param) for row in rows: parameters.append(Parameter(row)) return parameters
def update_result(result, model, conn): params = [] query_set = """ Key =?, Name =?, Unit =?, Type =?, ModelId =? WHERE Id=? """ query = query_update + query_set params = [ result.key, result.name, result.unit, result.type, model.id, result.id ] for p in params: if (p == None): p = 'NULL' sqlite_wrapper.run_query(conn, query, params) return result.id
def get_process_by_id(id, conn): query_where = """ WHERE Id =? """ query = query_select + query_where param = [id] rows = sqlite_wrapper.run_query(conn, query, param) if(len(rows) == 0): return '-1' for row in rows: pass ret_process = Process(row) return ret_process
def update_parameter(parameter, model, conn): params = [] query_set = """ Key =?, Name =?, Unit =?, Type =?, ModelId =? WHERE Id=? """ query = query_update + query_set params = [ parameter.key, parameter.name, parameter.unit, parameter.type, model.id, parameter.id ] for p in params: if (p == None): p = 'NULL' sqlite_wrapper.run_query(conn, query, params) return parameter.id
def insert_result(result, model, conn): params = [] query_values = """ VALUES ( ?, ?, ?, ?, ? ) """ query = query_insert + query_values params = [result.key, result.name, result.unit, result.type, model.id] inserted_id = 0 result = sqlite_wrapper.run_query(conn, query, params, True) inserted_id = result[1].lastrowid return inserted_id
def insert_model(model, processId, conn): params = [] query_values = """ VALUES ( ?, ?, ?, ?, ? ) """ query = query_insert + query_values params = [ model.name, processId, model.scriptHead, model.scriptBody, model.scriptTail ] result = sqlite_wrapper.run_query(conn, query, params, True) inserted_id = result[1].lastrowid return inserted_id
def insert_output_flow(output_flow, model, conn): params = [] query_values = """ VALUES ( ?, ?, ?, ?, ?, ?, ? ) """ query = query_insert + query_values params = [ model.id, output_flow.name, output_flow.waterFlowId, output_flow.massFlowId, output_flow.distributionId, output_flow.positionX, output_flow.positionY ] inserted_id = 0 result = sqlite_wrapper.run_query(conn, query, params, True) inserted_id = result[1].lastrowid return inserted_id
def get_processes(conn): processes = [] rows = sqlite_wrapper.run_query(conn, query_select) for row in rows: processes.append(Process(row)) return processes
def get_process_types(conn): types = [] rows = sqlite_wrapper.run_query(conn, query_select) for row in rows: types.append(ProcessType(row)) return types