Flash and SQLAlchemy test

main.py

from flask import Flask, request
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey
import time


app = Flask(__name__)

Session = sessionmaker(bind=create_engine("mysql://root:[email protected]/test"))
session = Session()
Base = declarative_base()

class Person(Base):
    __tablename__ = 'person'

    id = Column(Integer, primary_key=True)
    name = Column(String)    


@app.route("/request1")
def request1():
    result = session.query(Person).all()
    result[0].name = "HOGE HOGE :))"
    time.sleep(20) # delays for 20 seconds like a heavy task
    session.commit()
    return "Request 1 is done"

@app.route("/request2")
def request2():
    session.commit()
    return "Request 2 is done"

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

requirements.txt

click==6.7
Flask==0.12.2
gunicorn==19.7.1
itsdangerous==0.24
Jinja2==2.9.6
MarkupSafe==1.0
MySQL-python==1.2.5
pkg-resources==0.0.0
SQLAlchemy==1.1.10
Werkzeug==0.12.2

HOGEHOGE