from flask import Flask, redirect, render_template, request, url_for, SQLAlchemy

app = Flask(__name__)
app.config["DEBUG"] = True

class Lyrics(db.Model):
    __tablename__ = "comments"

    id = db.Column(db.Integer, primary_key=True)
    song = db.Column(db.String(4096))
    artist = db.Column(db.String(4096))
    stripper = db.Column(db.String(4096))

SQLALCHEMY_DATABASE_URI = "mysql+mysqlconnector://{username}:{password}@{hostname}/{databasename}".format(
    username="T1duS",
    password="swaglyrics99",
    hostname="T1duS.mysql.pythonanywhere-services.com",
    databasename="lyrics",
)

db = SQLAlchemy(app)
db.create_all()

app.config["SQLALCHEMY_DATABASE_URI"] = SQLALCHEMY_DATABASE_URI
app.config["SQLALCHEMY_POOL_RECYCLE"] = 299
app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = False

@app.route("/stripper", methods=["GET", "POST"])
def index():
    if request.method == 'POST':
        song = request.form['song']
        artist = request.form['artist']
        lyrics = Lyrics.query.filter(Lyrics.song==song, Lyrics.artist==artist).first()
        if lyrics:
            return lyrics.stripper
        else:
            return "Not available"