def creat():
DataAccess.execute(
'insert into medical(class,serial,dr,limit) values (?,?,?,?)', [
request.form['class'], request.form['serial'], request.form['dr'],
request.form['limit']
])
return jsonify({'status': 'done'})
def create():
DataAccess.execute(
'insert into route(Permission_no,Dep,Dest) values (?,?,?)', [
request.form['Permission_no'], request.form['Dep'],
request.form['Dest']
])
return jsonify({'status': 'done'})
def update():
DataAccess.execute(
'update medical set class=?,serial=?,dr=?,limit=? where id=?', [
request.form['class'], request.form['serial'], request.form['dr'],
request.form['limit'], request.form['id']
])
return jsonify({'status': 'done'})
def create():
DataAccess.execute(
'insert into pilot_brefing(wether,chart,pilot_id,dispather_id) values (?,?,?,?)',
[
request.form[''], request.form[''], request.form[''],
request.form['']
])
return jsonify({'status': 'done'})
def create():
DataAccess.execute(
'insert into flight_attendent(fname,lname,adr,nid,birthday,phone_number,type,post,medical_id) values (?,?,?,?,?,?,?,?,?)',
[
request.form['fname'], request.form['lname'], request.form['adr'],
request.form['nid'], request.form['birthday'],
request.form['phone_number'], request.form['type'],
request.form['post'], request.form['medical_id']
])
return jsonify({'status': 'done'})
def create():
DataAccess.execute(
'insert into dispatcher(fname,lname,adr,nid,birthday,phone_number,lic_no,ex_date) values (?,?,?,?,?,?,?,?)',
[
request.form['fname'], request.form['lname'], request.form['adr'],
request.form['nid'], request.form['birthday'],
request.form['phone_number'], request.form['lic_no'],
request.form['ex_date']
])
return jsonify({'status': 'done'})
def update():
DataAccess.execute(
'update flight_attendent set fname=?,lname=?,adr=?,nid=?,birthday=?,phone_number=?,type=?,post=?,medical_id=? where id=?',
[
request.form['fname'], request.form['lname'], request.form['adr'],
request.form['nid'], request.form['birthday'],
request.form['phone_number'], request.form['type'],
request.form['post'], request.form['medical_id'],
request.form['id']
])
return jsonify({'status': 'done'})
def create():
DataAccess.execute(
'insert into airplane(total_flight_time,eng,name,reg_code,total_block_time,first_chair_no,sec_chair_no,eco_chair_no,eq) values (?,?,?,?,?,?,?,?,?)',
[
request.form['total_flight_time'], request.form['eng'],
request.form['name'], request.form['reg_code'],
request.form['total_block_time'], request.form['first_chair_no'],
request.form['sec_chair_no'], request.form['eco_chair_no'],
request.form['eq']
])
return jsonify({'status': 'done'})
def create():
DataAccess.execute('insert into flight(flight_no,date,block_in,block_out,pax_no,take_off,landing,captian,fo,so) values (?,?,?,?,?,?,?,?,?,?)',
[request.form['flight_no'],[request.form['date'],[request.form['block_in'],[request.form['block_out'],[request.form['pax_no'],[request.form['take_off'],[request.form['landing'],[request.form['captian'],[request.form['fo'],[request.form['so']])
return jsonify({'status':'done'})
@app.route('/flight/delete',methods=['POST','GET'])
def delete():
DataAccess.execute('delete from flight where id=?',[request.form['id']])
return jsonify({'status':'done'})
@app.route('/flight/update',methods=['POST','GET'])
def update():
DataAccess.execute('update flightset flight_no=?,date,block_in=?,block_out=?,pax_no=?,take_off=?,landing=?,captian=?,fo=?,so=?) where id=?',
[request.form['flight_no'],[request.form['date'],[request.form['block_in'],[request.form['block_out'],[request.form['pax_no'],[request.form['take_off'],[request.form['landing'],[request.form['captian'],[request.form['fo'],[request.form['so'],[request.form['id']])
return jsonify({'status':'done'})
def delete():
DataAccess.execute('delete from flight_attendent where id=?',
[request.form['id']])
return jsonify({'status': 'done'})
def delete():
DataAccess.execute('delete from pilot_brefing where id=?',
[request.form['id']])
return jsonify({'status': 'done'})
def delete():
DataAccess.execute('delete from dispatcher where id=?',
[request.form['id']])
return jsonify({'status': 'done'})
def update():
DataAccess.execute('update pilot setfname=?,lname=?,adr=?,nid=?,birthday=?,phone_number=?,type=?,type_ex_date=?,flight_time=?,lice_no=?,ex_date=?,medical_id=?) where id=?',
[request.form['fname'],request.form['lname'],request.form['adr'],request.form['nid'],request.form['birthday'],request.form['phone_number'],request.form['type'],request.form['type_ex_date'],request.form['flight_time'],request.form['lice_no'],request.form['ex_date'],request.form['medical_id'],request.form['id']])
def create():
DataAccess.execute('insert into pilot(fname,lname,adr,nid,birthday,phone_number,type,type_ex_date,flight_time,lice_no,ex_date,medical_id) values (?,?,?,?,?,?,?,?,?,?,?,?)',
[request.form['fname'],request.form['lname'],request.form['adr'],request.form['nid'],request.form['birthday'],request.form['phone_number'],request.form['type'],request.form['type_ex_date'],request.form['flight_time'],request.form['lice_no'],request.form['ex_date'],request.form['medical_id']])
return jsonify({'status':'done'})
def create():
DataAccess.execute(
'insert into report(Type,text,pilot_id) values (?,?,?)',
[request.form['Type'], request.form['text'], request.form['pilot_id']])
return jsonify({'status': 'done'})
def create():
DataAccess.execute('insert into fa_flight(flight_id,fa_id) values (?,?)',
[request.form['flight_id'], request.form['fa_id']])
return jsonify({'status': 'done'})
