def all_niveles(self):
try:
conn = Connection('nivel')
records = conn.select([])
for record in records:
print(f'ID: {record[0]}')
print(f'Nivel: {record[1]}')
print('=====================')
except Exception as e:
print(e)
def all_secciones(self):
try:
conn = Connection('seccion')
records = conn.select([])
for record in records:
print(f'ID: {record[0]}')
print(f'Seccion: {record[1]}')
print('=====================')
except Exception as e:
print(e)
def all_categorias(self):
try:
conn = Connection('categoria')
records = conn.select([])
for record in records:
print(f'ID: {record[0]}')
print(f'Descipcion: {record[1]}')
print(f'Estado: {record[2]}')
print('=====================')
except Exception as e:
print(e)
def all_periodos(self):
try:
conn = Connection('periodo')
records = conn.select([])
for record in records:
print(f'ID: {record[0]}')
print(f'Mes: {record[1]}')
print(f'Año: {record[2]}')
print(f'Estado: {record[3]}')
print('=====================')
except Exception as e:
print(e)
def all_cursos(self):
try:
conn = Connection('curso')
records = conn.select([])
for record in records:
print(f'ID: {record[0]}')
print(f'Curso: {record[1]}')
print(f'Categoria: {record[2]}')
print(f'Estado: {record[3]}')
print('=====================')
except Exception as e:
print(e)
def all_alumnos(self):
try:
conn = Connection('alumno')
records = conn.select([])
for record in records:
print(f'ID: {record[0]}')
print(f'Nombres: {record[1]}')
print(f'Apellido_Paterno: {record[2]}')
print(f'Apellido_Materno: {record[3]}')
print(f'Fecha_Nacimiento: {record[4]}')
print(f'DNI: {record[5]}')
print(f'Correo: {record[6]}')
print(f'Telefono: {record[7]}')
print(f'Estado: {record[8]}')
print('=====================')
except Exception as e:
print(e)
def all_docentes(self):
try:
conn = Connection('docente')
records = conn.select([])
#items = records
""" for item in items:
print(item) """
for record in records:
print(f'ID: {record[0]}')
print(f'Nombres: {record[1]}')
print(f'Apellido_Paterno: {record[2]}')
print(f'Apellido_Materno: {record[3]}')
print(f'Fecha_Nacimiento: {record[4]}')
print(f'DNI: {record[5]}')
print(f'Correo: {record[6]}')
print(f'Telefono: {record[7]}')
print(f'Estado: {record[8]}')
print('=====================')
except Exception as e:
print(e)
