def eliminar_alumno_id(self, id): try: conn = Connection() query = f''' DELETE FROM alumno WHERE id = {id}; ''' conn.execute_query(query) conn.commit() print(f'Se elimino el alumno con ID {id}') except Exception as e: print(f'{str(e)}')
def delete_anio_escolar(self, id): try: conn = Connection() query = f''' DELETE FROM anio_escolar WHERE id = {id}; ''' conn.execute_query(query) conn.commit() print(f'Se elimino el año con ID {id}') except Exception as e: print(f'{str(e)}')
def update_curso(self, id): try: conn = Connection() query = f''' UPDATE curso SET nombre = '{self.nombre}' WHERE id = {id}; ''' conn.execute_query(query) conn.commit() print(f'Se actualizo el curso con el ID {id} por -> {self.nombre}') except Exception as e: print(f'{str(e)}')
def update_neduc(self, id): try: conn = Connection() query = f''' UPDATE mobile SET model = '{self.descrip_ned}' WHERE id = {id}; ''' conn.execute_query(query) conn.commit() print(f'Se actualizo el nievel educativo con el ID {id} por -> {self.descrip_ned}') except Exception as e: print(f'{str(e)}')
def update_alumno(self, id): try: conn = Connection() query = f''' UPDATE alumno SET nombres = '{self.nombres}', apellido_pat='{self.apellido_pat}', apellido_mat='{self.apellido_mat}' WHERE id = {id}; ''' conn.execute_query(query) conn.commit() print( f'Se actualizo el alumno con el ID {id} por -> {self.nombres}') except Exception as e: print(f'{str(e)}')
def guardar_anio_escolar(self): try: #[model, price] => model,price conn = Connection() query = f''' INSERT INTO anio_escolar (anio,descripcion) VALUES('{self.anio}','{self.descripcion}'); ''' conn.execute_query(query) conn.commit() print(f'Se agrego un año escolcar -> {self.anio}') except Exception as e: print(f'{str(e)}')
def insert_curso(self): try: #[model, price] => model,price conn = Connection() query = f''' INSERT INTO curso (nombre) VALUES('{self.nombre}') ''' conn.execute_query(query) conn.commit() print(f'Se agrego un curso -> {self.nombre}') except Exception as e: print(f'{str(e)}')
def create_table(self): try: conn = Connection() query = ''' CREATE TABLE IF NOT EXISTS nivel_educativo( id_ned SERIAL PRIMARY KEY NOT NULL, descrip_ned varchar(50) NOT NULL ); ''' conn.execute_query(query) conn.commit() except Exception as e: raise print(e)
def insert_neduc(self): try: #[model, price] => model,price conn = Connection() query = f''' INSERT INTO nivel_educativo (descrip_ned) VALUES('{self.descrip_ned}') ''' conn.execute_query(query) conn.commit() print(f'Se agrego un nivel educativo -> {self.descrip_ned}') except Exception as e: print(f'{str(e)}')
def create_table(self): try: conn = Connection() query = ''' CREATE TABLE IF NOT EXISTS alumno( id_alumno SERIAL PRIMARY KEY NOT NULL, nombre_alumno varchar(50) NOT NULL ); ''' conn.execute_query(query) conn.commit() except Exception as e: raise print(e)
def guardar_alumno(self): try: #[model, price] => model,price conn = Connection() query = f''' INSERT INTO alumno (nombres,apellido_pat,apellido_mat) VALUES('{self.nombres}','{self.apellido_pat}','{self.apellido_mat}'); ''' conn.execute_query(query) conn.commit() print(f'Se agrego un alumno -> {self.nombres}') except Exception as e: print(f'{str(e)}')
def update_anio_escolar(self, id): try: conn = Connection() query = f''' UPDATE anio_escolcar SET anio = '{self.anio}', descripcion='{self.descripcion}' WHERE id = {id}; ''' conn.execute_query(query) conn.commit() print( f'Se actualizo el año escolar con el ID {id} por -> {self.anio}' ) except Exception as e: print(f'{str(e)}')