def get_all_dispenser_locations(): db = get_db() db.execute('SELECT addresses FROM machine') addresses = db.fetchAll() return jsonify(addresses)
def register(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] db = get_db() error = None if not username: error = 'Username is required.' elif not password: error = 'Password is required.' elif db.execute( 'SELECT id FROM user WHERE username = ?', (username,) ).fetchone() is not None: error = 'User {} is already registered.'.format(username) if error is None: db.execute( 'INSERT INTO user (username, password) VALUES (?, ?)', (username, generate_password_hash(password)) ) db.commit() return redirect(url_for('auth.login')) flash(error) return render_template('auth/register.html')
def missing(id, status): error = None # initial parameter checking if id is None or id < 0: error = 'id must be greater or equal to zero' elif status is None or status is not 0 or status is not 1: error = 'status must be either 0 or 1' # verify a machine exists db = get_db() machine_count = db.execute('SELECT COUNT(*) FROM machine WHERE id = ?', (id)).fetchall() if machine_count is None: error = 'machine with {0} number does not exist'.format(id) # display error if exists, else update if error is not None: flash(error) else: db.execute('UPDATE machine set missing = ? WHERE id = ?', (status, id)) # TODO: update user's points db.commit() return 200
def load_logged_in_user(): user_id = session.get('user_id') if user_id is None: g.user = None else: g.user = get_db().execute( 'SELECT * FROM user WHERE id = ?', (user_id,) ).fetchone()
def login(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] db = get_db() error = None user = db.execute( 'SELECT * FROM user WHERE username = ?', (username,) ).fetchone() if user is None: error = 'Incorrect username.' elif not check_password_hash(user['password'], password): error = 'Incorrect password.' if error is None: session.clear() session['user_id'] = user['id'] return redirect(url_for('index')) flash(error) return render_template('auth/login.html')