def populate_database():
if not (Student.select().exists()):
flightTimeZero = timedelta(days=0,
seconds=0,
microseconds=0,
milliseconds=0,
minutes=0,
hours=0,
weeks=0)
stud1 = Student(name='Fábio',
address='Av. Angélica, 728',
birth_date='1998-10-28',
flightTime=flightTimeZero)
stud2 = Student(name='Gabriel',
address='Rua Timbiras, 879',
birth_date='1997-06-15',
flightTime=flightTimeZero)
stud3 = Student(name='Douglas',
address='Alameda Santos, 134',
birth_date='1996-12-01',
flightTime=flightTimeZero)
stud4 = Student(name='Enrique',
address='Rua Cactos, 867',
birth_date='1997-1-25',
flightTime=flightTimeZero)
stud5 = Student(name='Gabriel',
address='Rua Incas, 1378',
birth_date='1996-2-28',
flightTime=flightTimeZero)
if not (Instructor.select().exists()):
instr1 = Instructor(name='Jerônimo',
license_number=9853294,
address='Rua dos camelos, 1386',
birth_date='1985-4-23',
course_name='Pilotagem de helicópteros',
graduation_date='2014-01-20',
institution='Escola XX de Julho')
instr2 = Instructor(
name='Luciana',
license_number=7548125,
address='Av. Kennedy, 12',
birth_date='1974-2-21',
course_name='Mecânica e pilotagem de aeronaves de pequeno porte',
graduation_date='2002-1-31',
institution='Escola de vôo de Cotia')
instr3 = Instructor(
name='Alberto',
license_number=1324578,
address='Estrada do jaguar, km 72',
birth_date='1990-7-18',
course_name='Especialização em aviões de grande porte',
graduation_date='2016-12-14',
institution='Centro de aviação CVT')
instr4 = Instructor(name='Juvenal',
license_number=8987456,
address='Av. Osnir Santos, 445',
birth_date='1973-5-11',
course_name='Instruções de vôo gerais',
graduation_date='2008-10-28',
institution='Escola de pilotagem de Rio Branco')
instr5 = Instructor(name='Acácio',
license_number=7894561,
address='Rua das nações, 404',
birth_date='1987-9-9',
course_name='Pilotagem comercial',
graduation_date='2017-8-16',
institution='Escola holandesa de aviação civil')
commit()
def get_students_list():
'''Retorna uma lista de dicts com informções de cada aluno'''
students = Student.select()
schema = StudentSchema(many=True)
return schema.dump(list(students)).data
