app.py

from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy
from flask_cors import CORS
from flask_marshmallow import Marshmallow
from flask_heroku import Heroku

app = Flask(__name__)
heroku = Heroku(app)

app.config["SQLALCHEMY_DATABASE_URI"] = "postgres://ywafmohjrmjmfs:1dbc0b9901a9ce608f01096de6166b927593ab8d1ab904f79ce7d4701ac2b2d2@ec2-54-235-163-246.compute-1.amazonaws.com:5432/dek6gs8onan1i4"

CORS(app)

db = SQLAlchemy(app)
ma = Marshmallow(app)


class Todo(db.Model):
    __tablename__ = "todos"
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100))
    done = db.Column(db.Boolean)

    def __init__(self, title, done):
        self.title = title
        self.done = done


class TodoSchema(ma.Schema):
    class Meta:
        fields = ("id", "title", "done")


todo_schema = TodoSchema()
todos_schema = TodoSchema(many=True)


@app.route("/todos", methods=["GET"])
def get_todos():
    all_todos = Todo.query.all()
    result = todos_schema.dump(all_todos)
    return jsonify(result)


@app.route("/todos", methods=["POST"])
def add_todos():
    title = request.json["title"]
    done = request.json["done"]

    new_todo = Todo(title, done)
    db.session.add(new_todo)
    db.session.commit()

    created_todo = Todo.query.get(new_todo.id)
    return todo_schema.jsonify(created_todo)


@app.route("/todo/<id>", methods=["PUT"])
def update_todo(id):
    todo = Todo.query.get(id)

    todo.title = request.json["title"]
    todo.done = request.json["done"]

    db.session.commit()
    return todo_schema.jsonify(todo)


@app.route("/todo/<id>", methods=["DELETE"])
def delete_todo(id):
    todo = Todo.query.get(id)
    db.session.delete(todo)
    db.session.commit()

    return "RECORD DELETED"


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