sqlalchemy.exc.InvalidRequestError Hatası HK.

from flask import Flask, flash, render_template, request, redirect, url_for, session
from flask_sqlalchemy import SQLAlchemy
import os
from datetime import datetime

DB_NAME = 'dreamlist.db'

app = Flask(__name__)
app.config['SECRET_KEY'] = "asdfkkkkkkkallalall"
app.config['SQLALCHEMY_DATABASE_URI'] = f"sqlite:///{DB_NAME}"
db = SQLAlchemy(app)

class Users(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(85), nullable=False)
    surname = db.Column(db.String(85), nullable=False)
    email = db.Column(db.String(85), nullable=False)
    password = db.Column(db.String(155), nullable=False)
    job = db.relationship('job', backref='jobber')

    
class Jobs(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    job = db.Column(db.String(85), nullable=False)
    telephone = db.Column(db.Integer, nullable=False)
    adres = db.Column(db.String(350), nullable=False)
    detay = db.Column(db.String(255), nullable=False)
    password = db.Column(db.String(155), nullable=False)
    date_added = db.Column(db.DateTime(155), default=datetime.utcnow)
    jobber_id = db.Column(db.Integer, db.ForeignKey('users.id'))


@app.route("/")
def home():
  #  if 'email' in session:
     #   email = session['email']
      #  me = Users.query.filter_by(email='email').first()
      # return render_template('home.html', me=me)
 #   return redirect(url_for('login'))
 return render_template('home.html')


@app.route("/register", methods=["GET", "POST"])
def register():
     if request.method == "POST":
        name = request.form.get('name')
        surname = request.form.get('surname')
        email = request.form.get('email')
        password = request.form.get('password')
        return redirect(url_for('login'))
     return render_template('register.html')

@app.route("/login", methods=["GET", "POST"])
def login():
    if 'email' in session:
        return redirect(url_for('home'))
    if request.method == "POST":
        email = request.form.get('email')
        password = request.form.get('password')
        return redirect(url_for('login'))
    
    search = Users.query.filter_by(email='email').first()
    
    if search is None:
        flash("Yanlış Giriş Yaptın")
        return render_template("login.html")
    
   # if password == search.password:
     #   session['email'] = email
     #   return redirect(url_for('home'))
  #  return render_template('login.html') 

@app.route("/create")
def create():
    return render_template('create.html')

@app.route("/detail")
def detail():
    return render_template('detail.html')

@app.route("/logout")
def logout():
    session.pop("email", None)
    return redirect(url_for('home'))

@app.errorhandler(404)
def error(e):
    return render_template('404.html')
    

if __name__ == "__main__":
    if not os.path.exists(DB_NAME):
        db.create_all(app=app)
        print("DATABASE OLUŞTURULDU!")
    
    app.debug = True
    app.run(debug = True)

search = Users.query.filter_by(email=email).first()

def login():
    if 'email' in session:
        return redirect(url_for('home'))
    if request.method == "POST":
        email = request.form.get('email')
        password = request.form.get('password')
     
        search = Users.query.filter_by(email=email,password=password).first()
         
        if search is None:
            flash("Yanlış Giriş Yaptın")v
            return render_template("login.html")
        elif:
            return redirect(url_for('home'))