V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
推荐学习书目
› Learn Python the Hard Way
Python Sites
› PyPI - Python Package Index
› http://diveintopython.org/toc/index.html
› Pocoo
值得关注的项目
› PyPy
› Celery
› Jinja2
› Read the Docs
› gevent
› pyenv
› virtualenv
› Stackless Python
› Beautiful Soup
› 结巴中文分词
› Green Unicorn
› Sentry
› Shovel
› Pyflakes
› pytest
Python 编程
› pep8 Checker
Styles
› PEP 8
› Google Python Style Guide
› Code Style from The Hitchhiker's Guide
This topic created in 4286 days ago, the information mentioned may be changed or developed.
http://dormousehole.readthedocs.org/en/latest/tutorial/dbinit.html#tutorial-dbinit
照着这个弄的。
初始化数据库出错，初学者不明白问题出在哪，请帮忙指点一下
代码如下：
>>> from flaskr import init_db
>>> init_db()
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "flaskr.py", line 22, in init_db
with closing(connect_db()) as db:
File "flaskr.py", line 19, in connect_db
return sqlite3.connect(app.config['DATABASE'])
KeyError: 'DATABASE'
>>>
# flaskr.py：
import sqlite3
from flask import Flask, request, session, g, redirect, url_for, \
abort, render_template, flash
from contextlib import closing
# configuration
DATABASE = '/tmp/flaskr.db'
DEBUG = True
SECRET_KEY = 'development key'
USERNAME = 'admin'
PASSWORD = 'default'
#create out little application :)
app = Flask(__name__)
app.config.from_envvar('FLASKR_SETTINGS', silent=True)
def connect_db():
return sqlite3.connect(app.config['DATABASE'])
def init_db():
with closing(connect_db()) as db:
with app.open_resource('schema.sql', mode='r') as f:
db.cursor().executescript(f.read())
db.commit()
if __name__ == '__main__':
app.run()
照着这个弄的。
初始化数据库出错，初学者不明白问题出在哪，请帮忙指点一下
代码如下：
>>> from flaskr import init_db
>>> init_db()
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "flaskr.py", line 22, in init_db
with closing(connect_db()) as db:
File "flaskr.py", line 19, in connect_db
return sqlite3.connect(app.config['DATABASE'])
KeyError: 'DATABASE'
>>>
# flaskr.py：
import sqlite3
from flask import Flask, request, session, g, redirect, url_for, \
abort, render_template, flash
from contextlib import closing
# configuration
DATABASE = '/tmp/flaskr.db'
DEBUG = True
SECRET_KEY = 'development key'
USERNAME = 'admin'
PASSWORD = 'default'
#create out little application :)
app = Flask(__name__)
app.config.from_envvar('FLASKR_SETTINGS', silent=True)
def connect_db():
return sqlite3.connect(app.config['DATABASE'])
def init_db():
with closing(connect_db()) as db:
with app.open_resource('schema.sql', mode='r') as f:
db.cursor().executescript(f.read())
db.commit()
if __name__ == '__main__':
app.run()
 |
1
cloverstd Aug 3, 2014
你有 export FLASKR_SETTINGS=/path/to/settings.cfg 吗
|
 |
3
notedit Aug 3, 2014
你把app.config 打印出来就知道了 出错的意思是没有 DATABASE
没看到你设置 FLASKR_SETTINGS 当然会出错 |
|
4
notedit Aug 3, 2014
"""
Simply define the environment variable FLASKR_SETTINGS that points to a config file to be loaded. The silent switch just tells Flask to not complain if no such environment key is set. """ |
Select Language