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