error = 'Invalid credentials. Please try again'
if request.method == 'POST':
    username = User.query.filter(db.or_(User.username == request.form['username'])).first()
    password = User.query.filter(db.or_(User.password == request.form['password'])).first()
    if username:
        if password:
            session['logged_in'] = True
            #session['username'] = username
            return redirect(url_for('dashboard',user=request.form['username'], username=username))
        else:
            return render_template('login.html',error=error)
    else:
        return render_template('login.html',error=error)
return render_template('login.html')