app.py

import os
from flask import Flask, render_template, request, redirect
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)


project_dir = os.path.dirname(os.path.abspath(__file__))
database_file = "sqlite:///{}".format(
    os.path.join(project_dir, "moviedatabase.db"))

app = Flask(__name__)
app.config["SQLALCHEMY_DATABASE_URI"] = database_file

db = SQLAlchemy(app)


class Movie(db.Model):
    title = db.Column(db.String(80), unique=True,
                      nullable=False, primary_key=True)

    def __repr__(self):
        return "<Title: {}>".format(self.title)


@app.route("/", methods=["GET", "POST"])
def home():
    if request.form:
        try:
            movie = Movie(title=request.form.get("title"))
            db.session.add(movie)
            db.session.commit()
        except Exception as e:
            print("Failed to add movie")
            print(e)
    movies = Movie.query.all()
    return render_template("home.html", movies=movies)


@app.route("/update", methods=["POST"])
def update():
    try:
        newtitle = request.form.get("newtitle")
        oldtitle = request.form.get("oldtitle")
        movie = Movie.query.filter_by(title=oldtitle).first()
        movie.title = newtitle
        db.session.commit()
    except Exception as e:
        print("Couldn't update movie title")
        print(e)
    return redirect("/")


@app.route("/delete", methods=["POST"])
def delete():
    try:
        title = request.form.get("title")
        movie = Movie.query.filter_by(title=title).first()
        db.session.delete(movie)
        db.session.commit()
    except Exception as e:
        print("Couldn't delete movie title")
        print(e)
    return redirect("/")


if __name__ == "__main__":
    app.run(debug=True)