# CERTIFICATION CLASSIFICATIONS

# The certification of this pilot is unknown

PILOT$\_$INVALID $=-1$

# A pilot that has joined the school, but has not soloed

PILOT$\_$NOVICE $=0$

# A pilot that has soloed but does not have a license

PILOT$\_$STUDENT $=1$

# A pilot that has a license, but has under $50$ hours post license

PILOT$\_$CERTIFIED $=2$

# A pilot that $50$ hours post license

PILOT$\_50\_$HOURS $=3$

def get$\_$certification$($takeoff$,$student$)$:

pass

def get$\_$best$\_$value$($data$,$ index, maximum$=$True$)$:

pass

def get$\_$minimums$($cert$,$ area, instructed, vfr$,$ daytime, minimums$)$:

pass

def read$\_$csv$($filename$)$:

pass

def write$\_$csv$($data$,$filename$)$:

pass

def read$\_$json$($filename$)$:

pass

def str$\_$to$\_$time$($timestamp$,$tzsource$=$None$)$:

pass

def daytime$($time$,$daycycle$)$:

pass

def get$\_$for$\_$id$($id$,$table$)$:

pass

def bad$\_$visibility$($visibility$,$minimum$)$:

pass

def bad$\_$winds$($winds$,$maxwind,maxcross$)$:

pass

def bad$\_$ceiling$($ceiling$,$minimum$)$:

pass

def get$\_$weather$\_$report$($takeoff$,$weather$)$:

pass

def get$\_$weather$\_$violation$($weather$,$minimums$)$:

pass

# FILES TO AUDIT

# Sunrise and sunset

DAYCYCLE $=$ 'daycycle.json'

# Hourly weather observations

WEATHER $=$ 'weather.json'

# The list of insurance$-$mandated minimums

MINIMUMS $=$ 'minimums.csv$\text{'}$

# The list of all registered students in the flight school

STUDENTS $=$ 'students.csv$\text{'}$

# The list of all take$-$offs $($and landings$)$

LESSONS $=$ 'lessons.csv$\text{'}$

def list$\_$weather$\_$violations$($directory$)$:

$"""$

Returns the $($annotated$)$ list of flight reservations that violate weather minimums.

This function reads the data files in the given directory $($the data files are all

identified by the constants defined above in this module$).$ It loops through the

list of flight lessons $($in lessons.csv$),$ identifying those takeoffs for which

get$\_$weather$\_$violation$()$ is not the empty string.

This function returns a list that contains a copy of each violating lesson, together

with the violation appended to the lesson.

Example: Suppose that the lessons

S$00687548$QR I$0612017-01-08$T$14$:$00$:$00-05$:$002017-01-08$T$16$:$00$:$00-05$:$00$ VFR Pattern

S$00758548$QR I$0722017-01-08$T$09$:$00$:$00-05$:$002017-01-08$T$11$:$00$:$00-05$:$00$ VFR Pattern

S$00971426$JQ I$0722017-01-12$T$13$:$00$:$00-05$:$002017-01-12$T$15$:$00$:$00-05$:$00$ VFR Pattern

violate for reasons of 'Winds', 'Visibility', and 'Ceiling', respectively $($and are the

only violations$).$ Then this function will return the $2$d list

$[[$S$00687,548$QR$,$ I$061,2017-01-08$T$14$:$00$:$00-05$:$00,2017-01-08$T$16$:$00$:$00-05$:$00,$ VFR$,$ Pattern, Winds$],$

$[$S$00758,548$QR$,$ I$072,2017-01-08$T$09$:$00$:$00-05$:$00,2017-01-08$T$11$:$00$:$00-05$:$00,$ VFR$,$ Pattern, Visibility$],$

$[$S$00971,426$JQ$,$ I$072,2017-01-12$T$13$:$00$:$00-05$:$00,2017-01-12$T$15$:$00$:$00-05$:$00,$ VFR$,$ Pattern, Ceiling$]]$

REMEMBER: VFR flights are subject to minimums with VMC in the row while IFR flights

are subject to minimums with IMC in the row. The examples above are all VFR flights.

If we changed the second lesson to

S$00758,548$QR$,$ I$072,2017-01-08$T$09$:$00$:$00-05$:$00,2017-01-08$T$11$:$00$:$00-05$:$00,$ IFR, Pattern

then it is possible it is no longer a visibility violation because it is subject to

a different set of minimums.

Parameter directory: The directory of files to audit

Precondition: directory is the name of a directory containing the files 'daycycle.json',

'weather.json', 'minimums.csv$\text{'},$ 'students.csv$\text{'},$ and 'lessons.csv$\text{'}$

$"""$