def register(): user = User(request.form['username'], request.form['password'], request.form['email']) db.session.add(user) db.session.commit() flash('User successfully registered') # TODO add an email confirmation return redirect(url_for('login'))
def populate(): init_db() # populate all tables result = vol_reader("../data/vols.csv") #print(result) for line in result: vol = Vol(line['date'], line['heure'], line['noVol'], line['noVol'][:2], line['aeronef'], line['od'], line['secteur'], line['status']) db.session.add(vol) db.session.commit() result = airport_reader("../data/airports.csv") for line in result: airport = Airport(line['city'], line['airportCode'], line['level2'], line['level3']) db.session.add(airport) db.session.commit() result = fc_reader("../data/fc.csv") for line in result: fc = FlightCompany(line['fc']) db.session.add(fc) db.session.commit() result = cap_pool_reader("../data/cap_pool.csv") for line in result: cap_pool = CapPool(line['cap_pool_name']) db.session.add(cap_pool) db.session.commit() result = cap_horaire_reader("../data/cap_horaire.csv") for line in result: cap_horaire = CapHoraire(line['cap_value'], line['cap_timestamp'], line['user_id']) db.session.add(cap_horaire) db.session.commit() result = group_reader("../data/group.csv") for line in result: priority_group = Group(line['fc_code'], line['group_name'], line['group_type'], line['group_class']) db.session.add(priority_group) db.session.commit() result = regle_aff_reader("../data/tbl_algo_regles_affaire.csv") for line in result: regle_aff = RegleAff(line['drag_capacity_from'], line['drag_capacity_to'], line['drag_type'], line['drag_value'], line['propagation'], line['condition_type'], line['condition_value']) db.session.add(regle_aff) db.session.commit() result = populateUser("../data/users.csv") for line in result: user = User(line['username'], line['password'], line['email']) #print(line['isAdmin']) db.session.add(user) if (line['isAdmin'].lower() == 'true'): db.session.commit() user = User.query.filter_by(username=line['username']).first() admin = Admin(user.id) db.session.add(admin) if (line['isNav'].lower() == 'true'): db.session.commit() user = User.query.filter_by(username=line['username']).first() nav = Nav(user.id) db.session.add(nav) if (line['fc'] != ''): db.session.commit() user = User.query.filter_by(username=line['username']).first() nav = User_Fc(user.id, line['fc']) db.session.add(nav) db.session.commit() result = priorite_reader("../data/priorite.csv") for line in result: #print(line) priorite = Priorite(line['fc_code'], line['group_id'], line['rank']) db.session.add(priorite) #print(priorite) db.session.commit() return redirect(url_for('index'))
app.secret_key = 'super secret key' app.config['SQLALCHEMY_DATABASE_URI'] = postUrl db.init_app(app) login_manager = LoginManager() login_manager.init_app(app) login_manager.login_view = 'login' CORS(app) # TODO with postgresql h = md5() h.update(b'user123') h.hexdigest() u = User("default", h.hexdigest(), "*****@*****.**") userlist = [u] print(u in userlist) @login_manager.user_loader def load_user(id): return User.query.get(ord(id)) @app.route('/') def index(): return "Hello, World!" @app.route('/assets', methods=['GET'])