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 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 route(Permission_no,Dep,Dest) values (?,?,?)', [
request.form['Permission_no'], request.form['Dep'],
request.form['Dest']
])
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 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 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 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'})
class FlaskApp:
def __init__(self):
# Config
self.config = Config()
# Create Flask Application
self.app = flask.Flask(__name__)
self.app.config[
'SQLALCHEMY_DATABASE_URI'] = self.config.get_db_connection_string(
)
self.app.debug = True
# Create Database with Alchemy, Session and our DataAccess
self.db = SQLAlchemy(self.app)
self.dataAccess = DataAccess(self.db)
# Create Url routing (Html)
self.app.add_url_rule('/', 'get_all_polls_as_html',
self.get_all_polls_as_html)
# Create Url routing (Service)
self.app.add_url_rule('/polls', 'get_all_polls_as_jason',
self.get_all_polls_as_jason)
self.app.add_url_rule('/test', 'get_test', self.get_test)
# Html
def get_all_polls_as_html(self):
return flask.render_template('index.html',
polls=self.dataAccess.get_all_polls())
# Service
def get_test(self):
try:
self.dataAccess.insert_user_vote(1, 2)
except:
self.db.session.rollback()
finally:
return flask.jsonify(
{"count": self.dataAccess.get_user_votes_for_vote(2)})
def get_all_polls_as_jason(self):
return flask.jsonify({"polls": self.dataAccess.get_all_polls()})
# Run
def run(self):
self.app.run(host=self.config.get_flask_host(),
port=self.config.get_flask_port())
class FlaskApp:
def __init__(self):
# Config
self.config = Config()
# Create Flask Application
self.app = flask.Flask(__name__)
self.app.config['SQLALCHEMY_DATABASE_URI'] = self.config.get_db_connection_string()
self.app.debug = True
# Create Database with Alchemy, Session and our DataAccess
self.db = SQLAlchemy(self.app)
self.dataAccess = DataAccess(self.db)
# Create Url routing (Html)
self.app.add_url_rule('/', 'get_all_polls_as_html', self.get_all_polls_as_html)
# Create Url routing (Service)
self.app.add_url_rule('/polls', 'get_all_polls_as_jason', self.get_all_polls_as_jason)
self.app.add_url_rule('/test', 'get_test', self.get_test)
# Html
def get_all_polls_as_html(self):
return flask.render_template('index.html', polls=self.dataAccess.get_all_polls())
# Service
def get_test(self):
try:
self.dataAccess.insert_user_vote(1, 2);
except:
self.db.session.rollback()
finally:
return flask.jsonify({"count" : self.dataAccess.get_user_votes_for_vote(2)})
def get_all_polls_as_jason(self):
return flask.jsonify({"polls" : self.dataAccess.get_all_polls()})
# Run
def run(self):
self.app.run(host=self.config.get_flask_host(), port=self.config.get_flask_port())
def __init__(self):
# Config
self.config = Config()
# Create Flask Application
self.app = flask.Flask(__name__)
self.app.config[
'SQLALCHEMY_DATABASE_URI'] = self.config.get_db_connection_string(
)
self.app.debug = True
# Create Database with Alchemy, Session and our DataAccess
self.db = SQLAlchemy(self.app)
self.dataAccess = DataAccess(self.db)
# Create Url routing (Html)
self.app.add_url_rule('/', 'get_all_polls_as_html',
self.get_all_polls_as_html)
# Create Url routing (Service)
self.app.add_url_rule('/polls', 'get_all_polls_as_jason',
self.get_all_polls_as_jason)
self.app.add_url_rule('/test', 'get_test', self.get_test)
def __init__(self):
# Config
self.config = Config()
# Create Flask Application
self.app = flask.Flask(__name__)
self.app.config['SQLALCHEMY_DATABASE_URI'] = self.config.get_db_connection_string()
self.app.debug = True
# Create Database with Alchemy, Session and our DataAccess
self.db = SQLAlchemy(self.app)
self.dataAccess = DataAccess(self.db)
# Create Url routing (Html)
self.app.add_url_rule('/', 'get_all_polls_as_html', self.get_all_polls_as_html)
# Create Url routing (Service)
self.app.add_url_rule('/polls', 'get_all_polls_as_jason', self.get_all_polls_as_jason)
self.app.add_url_rule('/test', 'get_test', self.get_test)
def read():
data = DataAccess.fetch_all('select * from report', [])
return jsonify([Report(*a) for a in data])
def delete():
DataAccess.execute('delete from flight_attendent where id=?',
[request.form['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 read():
data = DataAccess.fetch_all('select * from flight_attendent', [])
return jsonify([flight_attendent(*a) for a in data])
def delete():
DataAccess.execute('delete from pilot_brefing where id=?',
[request.form['id']])
return jsonify({'status': 'done'})
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 read():
data = DataAccess.fetch_all('select * from medical', [])
return jsonify([medical(*a) for a in data])
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 read():
data = DataAccess.fetch_all('select * from route', [])
return jsonify([Route(*a) for a in data])
def delete():
DataAccess.execute('delete from dispatcher where id=?',
[request.form['id']])
return jsonify({'status': 'done'})
def read():
data=DataAccess.fetch_all('select * from pilot',[])
return jsonify([pilot(*a) for a in data])
def read():
data = DataAccess.fetch_all('select * from dispatcher', [])
return jsonify([dispather(*a) for a in data])
def read():
data = DataAccess.fetch_all('select * from fa_flight', [])
return jsonify([fa_flight(*a).serialize() for a in data])
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'})
def read():
data = DataAccess.fetch_all('select * from filght_brefing', [])
return jsonify([pilot_brefing(*a) for a in data])
def read():
data = DataAccess.fetch_all('select * from airplane', [])
return jsonify([airplane(*a).serialize() for a in data])
