def update_nota(self, id, bimestre, matematica, comunicacion, ingles): self.id = id self.bimestre = bimestre self.matematica = matematica self.comunicacion = comunicacion self.ingles = ingles try: conn = Connection() query = f''' UPDATE nota SET matematica = {matematica}, comunicacion = {comunicacion}, ingles = {ingles}, bimestre = {bimestre} WHERE id = {id}; ''' cursor = conn.execute_query(query) conn.commit() print( f'''Se ha actualizado las notas del alumno registrado con el DNI {id}: Matematica: {matematica} Comunicacion: {comunicacion} Ingles: {ingles} ''') except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def update_alumno(self, id, nombre, edad, correo, salon): self.id = id self.nombre = nombre self.edad = edad self.correo = correo self.salon = salon try: conn = Connection() query = f''' UPDATE alumno SET nombre_alumno = '{nombre}', edad = {edad}, correo = '{correo}', salon = '{salon}' WHERE id = {id}; ''' cursor = conn.execute_query(query) conn.commit() print(f'''Se ha actualizado al alumno registrado con el id {id}: Nombre: {nombre} Edad: {edad} Correo: {correo} Salón: {salon} ''') except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def update_docente(self, id, nombre, edad, correo, curso): self.id = id self.nombre = nombre self.edad = edad self.correo = correo self.curso = curso try: conn = Connection() query = f''' UPDATE profesor SET nombre_profesor = '{nombre}', edad = {edad}, correo = '{correo}', curso = '{curso}' WHERE id = {id}; ''' cursor = conn.execute_query(query) conn.commit() print(f'''Se ha actualizado al profesor registrado con el id {id}: Nombre: {nombre} Edad: {edad} Correo: {correo} Curso: {curso} ''') except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def insert_alumno(self, ident, nombre, edad, correo, salon): self.ident = ident self.nombre = nombre self.edad = edad self.correo = correo self.salon = salon try: conn = Connection() query = f''' INSERT INTO alumno (id, nombre_alumno, edad, correo, salon) VALUES ('{ident}','{nombre}', {edad} , '{correo}' ,'{salon}') ''' cursor = conn.execute_query(query) conn.commit() print( f"Se ha registrado correctamente el alumno con nombre {nombre}" ) except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def insert_docente(self, ident, nombre, edad, correo, curso): self.ident = ident self.nombre = nombre self.edad = edad self.correo = correo self.curso = curso try: conn = Connection() query = f''' INSERT INTO profesor (id, nombre_profesor, edad, correo, curso) VALUES ('{ident}','{nombre}', {edad} , '{correo}' ,'{curso}') ''' cursor = conn.execute_query(query) conn.commit() print( f"Se ha registrado correctamente el profesor con nombre {nombre}" ) except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def create_table_notas(self): try: conn = Connection() query = ''' CREATE TABLE IF NOT EXISTS notas( id SERIAL PRIMARY KEY NOT NULL, nota REAL ); ''' conn.execute_query(query) conn.commit() except Exception as e: raise print(e)
def insert_notas(self): try: conn = Connection() query = f''' INSERT INTO notas (nota) VALUES('{self.notas}') ''' cursor = conn.execute_query(query) conn.commit() print(f'Se agrego nota -> {self.notas}') except Exception as e: print(f'{str(e)}')
def update_alumno(self, id): try: conn = Connection() query = f''' UPDATE alumno SET nombre = '{self.nombre_alumno}', edad = {self.edad_alumno} WHERE id = {id}; ''' cursor = conn.execute_query(query) conn.commit() print(f'Se actualizo informacion de alumno {id} por -> {self.nombre_alumno} - {self.edad_alumno}') except Exception as e: print(f'{str(e)}')
def delete_alumno(self, id): try: conn = Connection() query = f''' DELETE FROM alumno esor WHERE id = {id}; ''' cursor = conn.execute_query(query) conn.commit() print(f'Se elimino registro con ID {id}') except Exception as e: print(f'{str(e)}')
def create_table_profesor(self): try: conn = Connection() query = ''' CREATE TABLE IF NOT EXISTS profesor( Id SERIAL PRIMARY KEY NOT NULL, nombre varchar(50) NOT NULL, edad REAL ); ''' conn.execute_query(query) conn.commit() except Exception as e: raise print(e)
def insert_alumno(self): try: #[model, price] => model,price conn = Connection() query = f''' INSERT INTO alumno (nombre, edad) VALUES('{self.nombre_alumno}', {self.edad_alumno}) ''' cursor = conn.execute_query(query) conn.commit() print(f'Se agrego alumno -> {self.nombre_alumno}') except Exception as e: print(f'{str(e)}')
def insert_profesor(self): try: conn = Connection() query = f''' INSERT INTO profesor (nombre, edad) VALUES('{self.nombre_profesor}', {self.edad_profesor}) ''' cursor = conn.execute_query(query) conn.commit() print(f'Se agrego profesor -> {self.nombre_profesor}') except Exception as e: print(f'{str(e)}')
def create_table_salones(self): try: conn = Connection() query = ''' CREATE TABLE IF NOT EXISTS salones( id SERIAL PRIMARY KEY NOT NULL, Seccion varchar(50) NOT NULL ); ''' conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}')
def delete_nota(self, id): try: conn = Connection() query = f''' DELETE FROM nota WHERE id ={id}; ''' cursor = conn.execute_query(query) conn.commit() print(f'Se elimino el alumno registrado con el ID {id}') except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def create_table_nota(self): try: conn = Connection() query = ''' CREATE TABLE IF NOT EXISTS nota( id SERIAL PRIMARY KEY NOT NULL, matematica REAL, comunicacion REAL, ingles REAL, bimestre integer ); ''' conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def create_table_docente(self): try: conn = Connection() query = ''' CREATE TABLE IF NOT EXISTS profesor( id SERIAL PRIMARY KEY NOT NULL, nombre_profesor varchar(50) NOT NULL, edad REAL, correo varchar(75) NOT NULL, curso varchar(50) NOT NULL ); ''' conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def insert_nota(self, ident, matematica, comunicacion, ingles, bimestre): self.ident = ident self.matematica = matematica self.comunicacion = comunicacion self.ingles = ingles self.bimestre = bimestre try: conn = Connection() query = f''' INSERT INTO nota (id, matematica, comunicacion, ingles, bimestre) VALUES ({ident}, {matematica} ,{comunicacion}, {ingles}, {bimestre}) ''' cursor = conn.execute_query(query) conn.commit() print( f"Se ha registrado correctamente las notas del alumno con el id {ident}" ) except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def inner_alumno_nota(self): try: conn = Connection() query = ''' DROP TABLE IF EXISTS alumno_nota; ''' conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') try: conn = Connection() query = ''' CREATE TABLE IF NOT EXISTS alumno_nota( id SERIAL PRIMARY KEY NOT NULL, nombre_alumno varchar(50) NOT NULL, edad REAL, correo varchar(75) NOT NULL, salon varchar(50) NOT NULL, matematica REAL, comunicacion REAL, ingles REAL, bimestre integer ); ''' conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') try: conn = Connection() query = f''' INSERT INTO alumno_nota(nombre_alumno, edad, correo, salon, matematica, comunicacion, ingles, bimestre) SELECT nombre_alumno, edad, correo, salon, matematica, comunicacion, ingles, bimestre FROM alumno INNER JOIN nota on alumno.id = nota.id ''' cursor = conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def inner_alumno_nota_salon(self): try: conn = Connection() query = ''' DROP TABLE IF EXISTS alumno_nota_salon; ''' conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') try: conn = Connection() query = ''' CREATE TABLE IF NOT EXISTS alumno_nota_salon( id SERIAL PRIMARY KEY NOT NULL, nombre_alumno varchar(50) NOT NULL, salon varchar(50) NOT NULL, matematica REAL, comunicacion REAL, ingles REAL, bimestre integer, nombre_profesor varchar(50) NOT NULL ); ''' conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') try: conn = Connection() query = f''' INSERT INTO alumno_nota_salon(nombre_alumno, salon, matematica, comunicacion, ingles, bimestre, nombre_profesor) SELECT nombre_alumno, salon, matematica, comunicacion, ingles, bimestre, nombre_profesor FROM alumno_nota INNER JOIN profesor_salon_completo on alumno_nota.salon = profesor_salon_completo.id_salon ''' cursor = conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') finally: conn.close_connection()
def inner_profesor_salon(self): try: conn = Connection() query = ''' DROP TABLE IF EXISTS profesor_salon_completo; ''' conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') try: conn = Connection() query = ''' CREATE TABLE IF NOT EXISTS profesor_salon_completo( id SERIAL PRIMARY KEY NOT NULL, nombre_profesor varchar(50) NOT NULL, edad REAL, correo varchar(75) NOT NULL, curso varchar(50) NOT NULL, id_salon varchar(50) NOT NULL ); ''' conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') try: conn = Connection() query = f''' INSERT INTO profesor_salon_completo(nombre_profesor, edad, correo, curso, id_salon) SELECT nombre_profesor, edad, correo, curso, id_salon FROM profesor INNER JOIN salon_profe on profesor.id = salon_profe.id_profesor ''' cursor = conn.execute_query(query) conn.commit() except Exception as e: print(f'{str(e)}') finally: conn.close_connection()