Web Apps × FlaskでDBを使うときのベストプラクティス？を調べる（Azureもくもく会@新宿 No.20 2018/06/12）Blog: http://nikkie-ftnext.hatenablog.com/entry/2018/06/12/234254

__init__.py

# app/__init__.py
from flask import Flask
from config import Config
from flask_sqlalchemy import SQLAlchemy

myapp = Flask(__name__) # appだとフォルダ名と競合すると懸念した
myapp.config.from_object(Config)
db = SQLAlchemy(myapp)

from app import views

config.py

# config.py
class Config(object):
    SQLALCHEMY_DATABASE_URI = 'sqlite:///app.db'
    SQLALCHEMY_TRACK_MODIFICATIONS = False

manage.py

# manage.py
from app import myapp
myapp.run()

models.py

# app/models.py
from app import db


class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(64), index=True, unique=True)
    email = db.Column(db.String(120), index=True, unique=True)
    password_hash = db.Column(db.String(128))

    def __repr__(self):
        return '<User {}>'.format(self.username)

def init():
    db.create_all()

def retrieve_users():
    users = User.query.all()
    return [create_user_info(u) for u in users]

def create_user_info(user):
    return {
        'id': user.id,
        'username': user.username,
        'email': user.email
    }

views.py

# app/views.py
from flask import jsonify
from app import myapp, db
from app.models import retrieve_users


@myapp.route('/')
def show_users():
    return jsonify(retrieve_users())

フォルダ構成

• ├ config.py
• ├ manage.py
• └ app/
  • ├ __init__.py
  • ├ models.py
  • └ views.py

参考

• https://blog.miguelgrinberg.com/post/the-flask-mega-tutorial-part-iv-database
• http://study-flask.readthedocs.io/ja/latest/02.html