def get_usuario(idUsuario):
query = "SELECT * FROM Usuario WHERE idUsuario ='" + str(idUsuario) + "';"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
for (idUsuario, PSS) in result:
usuario = Usuario()
usuario.new_usuario(idUsuario, PSS)
return usuario
def get_ICD10(Codigo):
query = "SELECT * FROM ICD_10 WHERE Codigo ='" + str(Codigo) + "';"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
for (Codigo, Nombre) in result:
icd10 = ICD10()
icd10.new_ICD10(Codigo, Nombre, None)
return icd10
def get_informes(Codigo):
query = "SELECT IdInforme FROM INFORME_ICD_10 WHERE Codigo ='" + str(
Codigo) + "';"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
informes = list()
for (idInforme) in result:
informes.append(str(idInforme[0]))
return informes
def get_historial(idPaciente):
query = "SELECT idHistorial FROM Historial WHERE idPaciente =" + str(
idPaciente) + ";"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
hist = None
for (idHistorial) in result:
hist = idHistorial[0]
return hist
def get_Licencia(idPaciente):
query = "SELECT Licencia FROM es_atendido WHERE idPaciente =" + str(
idPaciente) + ";"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
licencias = list()
for (Licencia) in result:
licencias.append(str(Licencia[0]))
return licencias
def get_medico(Licencia):
query = "SELECT * FROM Medico WHERE Licencia ='" + str(Licencia) + "';"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
for (Licencia, Nombre, Apellidos, Sexo, Especialidad) in result:
medico = Medico()
medico.new_medico(Licencia, Nombre, Apellidos, Sexo, Especialidad,
None, None)
return medico
def lista_ICD10():
query = "SELECT * FROM ICD_10;"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
codigos = list()
conn.close_connection(connection)
for (Codigo, Nombre) in result:
icd10 = ICD10()
icd10.new_ICD10(Codigo, Nombre, None)
codigos.append(icd10)
return codigos
def get_prueba(idPrueba):
query = "SELECT * FROM Prueba WHERE idPrueba ='" + str(idPrueba) + "';"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
for (idPrueba, Observaciones, idPrueba_Externo, Tipo, idInforme,
Nombre) in result:
prueba = Prueba()
prueba.new_prueba(idPrueba, Observaciones, idPrueba_Externo, Tipo,
idInforme, Nombre)
return prueba
def get_prueba(idInforme):
query = "SELECT idPrueba FROM Prueba WHERE idInforme ='" + str(
idInforme) + "';"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
pruebas = list()
if result:
for (idPrueba) in result:
pruebas.append(str(idPrueba[0]))
return pruebas
def get_historial(idHistorial):
query = "SELECT * FROM Historial WHERE idHistorial ='" + str(
idHistorial) + "';"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
for (idHistorial, Fecha_primera_consulta, idPaciente, Vacunas) in result:
historial = Historial()
historial.new_historial(idHistorial, Fecha_primera_consulta,
idPaciente, Vacunas, None, None)
return historial
def get_informes(idHistorial):
query = "SELECT idInforme FROM Informe WHERE idHistorial ='" + str(
idHistorial) + "';"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
informes = list()
if result:
for (idInforme) in result:
informes.append(str(idInforme[0]))
return informes
def lista_usuarios():
query = "SELECT * FROM Usuario;"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
usuarios = list()
conn.close_connection(connection)
for (idUsuario, PSS) in result:
usuario = Usuario()
usuario.new_usuario(idUsuario, PSS)
usuarios.append(usuario)
return usuarios
def get_ICD10(idInforme):
query = "SELECT Codigo FROM INFORME_ICD_10 WHERE idInforme ='" + str(
idInforme) + "';"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
ICD10s = list()
if result:
for (Codigo) in result:
ICD10s.append(str(Codigo[0]))
return ICD10s
def lista_historial():
query = "SELECT * FROM Historial;"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
historiales = list()
conn.close_connection(connection)
for (idHistorial, Fecha_primera_consulta, idPaciente, Vacunas) in result:
historial = Historial()
historial.new_historial(idHistorial, Fecha_primera_consulta,
idPaciente, Vacunas, None, None)
historiales.append(historial)
return historiales
def lista_medicos():
query = "SELECT * FROM Medico;"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
medicos = list()
conn.close_connection(connection)
for (Licencia, Nombre, Apellidos, Sexo, Especialidad) in result:
medico = Medico()
medico.new_medico(Licencia, Nombre, Apellidos, Sexo, Especialidad,
None, None)
medicos.append(medico)
return medicos
def get_informe(idInforme):
query = "SELECT * FROM Informe WHERE idInforme = '" + str(idInforme) + "';"
print(query)
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
for (idInforme, Estado_paciente, Diagnostico, idHistorial, idConsulta,
Fecha_consulta, Licencia_medico) in result:
informe = Informe()
informe.new_informe(idInforme, Estado_paciente, Diagnostico,
idHistorial, idConsulta, Fecha_consulta,
Licencia_medico, None, None)
return informe
def lista_pruebas():
query = "SELECT * FROM Prueba;"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
pruebas = list()
conn.close_connection(connection)
for (idPrueba, Observaciones, idPrueba_Externo, Tipo, idInforme,
Nombre) in result:
prueba = Prueba()
prueba.new_prueba(idPrueba, Observaciones, idPrueba_Externo, Tipo,
idInforme, Nombre)
pruebas.append(prueba)
return pruebas
def get_pacientes(Licencia):
query = "SELECT idPaciente FROM es_atendido WHERE Licencia ='" + str(
Licencia) + "';"
print(query)
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
pacientes = list()
if result:
for (idPaciente) in result:
pacientes.append(str(idPaciente[0]))
print(idPaciente)
return pacientes
def get_paciente(idPaciente):
query = "SELECT * FROM Paciente WHERE idPaciente =" + str(idPaciente) + ";"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
for (idPaciente, Nombre, NUSS, Sexo, Fecha_nacimiento, Localidad,
Domicilio, Apellidos, Telefono, Correo_electronico, Embarazada,
FPP) in result:
paciente = Paciente()
paciente.new_paciente(idPaciente, Nombre, NUSS, Sexo, Fecha_nacimiento,
Localidad, Domicilio,
Apellidos, Telefono, Correo_electronico,
str(Embarazada), FPP, None, None)
return paciente
def lista_informes():
query = "SELECT * FROM Informe;"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
informes = list()
conn.close_connection(connection)
for (idInforme, Estado_paciente, Diagnostico, idHistorial, Fecha_consulta,
idConsulta, Licencia_medico) in result:
informe = Informe()
informe.new_informe(idInforme, Estado_paciente, Diagnostico,
idHistorial, Fecha_consulta, idConsulta,
Licencia_medico, None, None)
informes.append(informe)
return informes
def parse_sim_report(lines, database='sim_test'):
select_auto_inc = 'SELECT AUTO_INCREMENT FROM information_schema.TABLES'\
' WHERE TABLE_SCHEMA = \"{}\" AND TABLE_NAME = \"sim_id_refs\";'.format(database)
sim_count = sql.execute_query(select_auto_inc)
print(sim_count)
sim_count = sql.execute_query('SELECT COUNT(*) FROM sim_id_refs;')
print(sim_count)
sim_count += 1
print(sim_count)
# parse lines now
sim_data = []
for line in lines:
turn_info = []
line = line[1:].split(",")
line = line[0:len(line) - 1]
if (len(line) > 5):
for idx, step in enumerate(line):
step = step[1:len(step) - 1].split(" ")
step_count = step[0]
populationCount = step[1][1:len(step[1]) - 1]
avg_population = step[2][1:len(step[2]) - 1]
variant_counts = step[3][1:len(step[3]) - 1]
details = {
'turn_number': idx,
'step_number': int(step_count),
'population_size': int(populationCount),
'avg_population': float(avg_population),
'variant_counts': variant_counts
}
turn_info.append(details)
#print(step_info)
# now send the turn_info to a query call
sim_report_query(sim_count, turn_info)
sim_count += 1
time.sleep(2.5) # give it a rest
def lista_pacientes_embarazadas():
query = "SELECT * FROM Paciente;"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
pacientes = list()
conn.close_connection(connection)
for (idPaciente, Nombre, NUSS, Sexo, Fecha_nacimiento, Localidad,
Domicilio, Apellidos, Telefono, Correo_electronico, Embarazada,
FPP) in result:
paciente = Paciente()
print(Embarazada)
if Embarazada == 1:
paciente.new_paciente(idPaciente, Nombre, NUSS, Sexo,
Fecha_nacimiento, Localidad, Domicilio,
Apellidos, Telefono, Correo_electronico,
str(Embarazada), FPP)
pacientes.append(paciente)
return pacientes
def get_FRR(idHistorial):
query = "SELECT * FROM FACTOR_DE_RIESGO_PRENATAL WHERE idHistorial ='" + str(
idHistorial) + "';"
connection = conn.get_connection()
result = conn.execute_query(query, connection)
conn.close_connection(connection)
FRR = dict()
for (Antecedentes_familiares, Factores_psicosociales,
Antecedentes_obstetricos, Antecedentes_personales, Patologia_materna,
Riesgos_especificos, Exposicion_a_teratogenos, idHistorial) in result:
FRR['Antecedentes_familiares'] = Antecedentes_familiares
FRR['Factores_psicosociales'] = Factores_psicosociales
FRR['Antecedentes_obstetricos'] = Antecedentes_obstetricos
FRR['Antecedentes_personales'] = Antecedentes_personales
FRR['Patologia_materna'] = Patologia_materna
FRR['Riesgos_especificos'] = Riesgos_especificos
FRR['Exposicion_a_teratogenos'] = Exposicion_a_teratogenos
return FRR
