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