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)}')
