app.py

from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy
from flask_marshmallow import Marshmallow
import os

# after code written, in a repl -> from app import db -> db.create_all() initializes the db

app = Flask(__name__)

# @app.route('/')
# def hello():
#     return 'Hello World'

basedir = os.path.abspath(os.path.dirname(__file__))
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' + os.path.join(basedir, 'app.sqlite')
db = SQLAlchemy(app)
ma = Marshmallow(app)

class Guide(db.Model):
    id = db.Column(db.Integer, primary_key=True) # primary key makes it automatically incrememnting
    title = db.Column(db.String(100), unique=False)
    content = db.Column(db.String(144), unique=False)

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

class GuideSchema(ma.Schema):
    class Meta:
        fields = ('title', 'content', 'id')


guide_schema = GuideSchema()
guides_schema = GuideSchema(many=True)

# endpoint to create new guide
@app.route('/guide', methods=['POST'])
def add_guide():
    title = request.json['title'] 
    content = request.json['content']

    new_guide = Guide(title, content)

    db.session.add(new_guide)
    db.session.commit()

    guide = Guide.query.get(new_guide.id)
    return guide_schema.jsonify(guide)


# endpoint to query all guides
@app.route('/guides', methods=["GET"])
def get_guides():
    all_guides = Guide.query.all()
    result = guides_schema.dump(all_guides)
    return jsonify(result)


# endpoint to query a guide
@app.route('/guide/<id>', methods=["GET"])
def get_guide(id):
    guide = Guide.query.get(id)
    return guide_schema.jsonify(guide)


# Endpoint for updating a guide
@app.route('/guide/<id>', methods=["PUT"])
def guid_update(id):
    guide = Guide.query.get(id)
    title = request.json['title']
    content = request.json['content']

    guide.title = title
    guide.content = content

    db.session.commit()
    return guide_schema.jsonify(guide)


# Endpoint for deleting a guide
@app.route('/guide/<id>', methods=["DELETE"])
def guide_delete(id):
    guide = Guide.query.get(id)
    db.session.delete(guide)
    db.session.commit()

    return f'You deleted guide with id {id}'


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