sqlite3 와 연결하여 flask 웹사이트를 간단히 만드는 연습을 하고 있는데
-------------------app.py-----------------------
from flask import Flask
from flask import render_template
from models import *
app = Flask(__name__)
@app.route('/')
def index():
user = db.session.query(User).filter(User.user_name == 'kimjaemin').first()
user_id = user.user_id
user_pw = user.user_pw
print user_id, user_pw
return render_template('test1.html')
if __name__ == '__main__':
app.run(debug=True)
-------------------models.py-----------------------
from config import *
from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy(app)
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
user_name = db.Column(db.String(50))
user_id = db.Column(db.String(100))
user_pw = db.Column(db.String(255))
class Chart(db.Model):
__tablename__ = 'chart'
id = db.Column(db.Integer, primary_key = True)
rank = db.Column(db.Integer)
song_name = db.Column(db.String(100))
db.create_all()
-------------------config.py-----------------------
from app import app
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////Users/kimjawmin/Desktop/jm_study.db'
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
이런식으로 세 파일을 import?해서 연결해두었고 실행시킨 결과
첨부한 사진처럼 에러가 납니다 app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
라고 해놨는데 왜 key error가 여기서 나올까요?