I met a problem in Chapter Test Web Application,new test code of git tag 15b.

[alexli0707]

Thank you for sharing your knowledge,I have a nice flask tutorial with your book. But I got a problem when I do the test of test_client.py. I got "RuntimeError: Application was not able to create a URL adapter for request independent URL generation. You might be able to fix this by setting the SERVER_NAME config variable." when goes in url_for('main.index). After I added SERVER_NAME='http://localhost:5000' to TestingConfig I got Page not found error.Can you help me ?tks

[alexli0707]

After I add
self._ctx = self.app.test_request_context()
self._ctx.push()
after self.client = self.app.test_client(use_cookies=True)
it works perfect!

[miguelgrinberg]

Can you give me the output of pip freeze?

[alexli0707]

Here it is
walembic==0.7.7
amqp==1.4.6
anyjson==0.3.3
app==0.0.2
appscript==1.0.1
argh==0.26.1
Babel==1.3
billiard==3.3.0.20
biplist==0.9
bleach==1.4.1
blinker==1.3
celery==3.1.17
click==4.0
colorama==0.2.7
config==0.3.9
coverage==3.7.1
Creoleparser==0.7.4
decorator==3.4.2
dominate==2.1.12
ecdsa==0.13
envoy==0.0.3
Fabric==1.10.2
Flask==0.10.1
Flask-Babel==0.9
Flask-Bootstrap==3.3.5.6
Flask-DebugToolbar==0.10.0
Flask-Email==1.4.4
Flask-HTTPAuth==2.5.0
Flask-Login==0.2.11
Flask-Mail==0.9.0
Flask-Migrate==1.5.0
Flask-Moment==0.5.0
Flask-OpenID==1.2.4
Flask-PageDown==0.2.1
Flask-Script==0.6.6
Flask-SQLAlchemy==2.0
Flask-WhooshAlchemy==0.56
Flask-WTF==0.11
flipflop==1.0
ForgeryPy==0.1
Genshi==0.7
gevent==1.0.1
greenlet==0.4.5
guess-language==0.2
gunicorn==19.3.0
html5lib==0.999999
httpie==0.9.2
itsdangerous==0.24
Jinja2==2.7.3
kombu==3.0.24
Mako==1.0.1
Markdown==2.6.2
MarkupSafe==0.23
mercurial==3.1.1
msgpack-python==0.4.6
mysql==0.0.1
mysql-connector-python==2.0.4
MySQL-python==1.2.5
osascript==0.0.4
paramiko==1.15.2
pathtools==0.1.2
pbr==0.11.0
Pillow==2.8.1
py==1.4.30
pycrypto==2.6.1
Pygments==2.0.2
pytest==2.7.2
python-openid==2.2.5
pytz==2015.2
PyYAML==3.11
raven==5.2.0
requests==2.7.0
simplejson==3.6.5
six==1.9.0
speaklater==1.3
SQLAlchemy==0.9.9
sqlalchemy-migrate==0.9.6
sqlparse==0.1.15
Tempita==0.5.2
umysql==2.61
virtualenv==12.1.1
watchdog==0.8.3
Werkzeug==0.10.4
Whoosh==2.7.0
WTForms==2.0.2

[miguelgrinberg]

Are you running the original code from this repository, or is this your own application? The virtualenv has a lot of packages that are not used by Flasky.

[alexli0707]

Thanks for your time.I had reused virtualenv created by last project, maybe different version of flask cause this problem.
By the way,I met another problem that I am trying hard to fixed it:After studying the whole book I deploy flasky on aws's ec2 instance with nginx and gunicorn.Before done this I ran

python manage runserver 

in localhost env it works perfect.But when I run it with

gunicorn  -b 0.0.0.0 manage:app  

I found SQLAlchemy cannot auto commit .I logged sqlalchemy.engine to file I find it always call Rollback after a SELECT perform and couldn't found INSERT perform without a commit() transfer .If I added

db.session.commit(self)

after

db.session.add(User) 

it worked fine.

[miguelgrinberg]

I found SQLAlchemy cannot auto commit

Did you get any errors regarding this commit failure?

[alexli0707]

No errors ,it also flash 'You have confirmed your account. Thanks!'
When I start with

python manage.py runserver

after every sql it log COMMIT.Everything goes fine.
When I start with

gunicorn manage:app

after every sql it log ROLLBACK. I thought in gunicorn SQLALCHEMY_COMMIT_ON_TEARDOWN=True not worked.

[miguelgrinberg]

What's your database URL for the working and not working commits?

[alexli0707]

Same as your demo project,Here is log:SQLALCHEMY_DATABASE_URI:sqlite:////Users/walker/Documents/python/github/flasky/data.sqlite

[alexli0707]

Here is a part of sqlalchemy's log,only start server with gunicorn will cause this.
SELECT roles.id AS roles_id, roles.name AS roles_name, roles."default" AS roles_default, roles.permissions AS roles_permissions
FROM roles
WHERE roles.id = ?
(2,)
SELECT count(*) AS count_1
FROM (SELECT comments.id AS comments_id, comments.body AS comments_body, comments.body_html AS comments_body_html, comments.timestamp AS comments_timestamp, comments.disabled AS comments_disabled, comments.author_id AS comments_author_id, comments.post_id AS comments_post_id
FROM comments
WHERE ? = comments.post_id) AS anon_1
(1,)
ROLLBACK

[sphkan]

@miguelgrinberg : I also ran into the same problem, and I used @alexli0707 's fix. It affected both my test_api.py and my test_client.py files, and I fixed them by adding:

self._ctx = self.app.test_request_context()
self._ctx.push()

at the end of my setUp() functions.

My pip freeze is:

Flask-Bootstrap==3.0.3.1
Flask-HTTPAuth==2.2.0
Flask-Login==0.3.1
Flask-Mail==0.9.0
Flask-Migrate==1.1.0
Flask-Moment==0.2.1
Flask-PageDown==0.1.4
Flask-SQLAlchemy==1.0
Flask-Script==0.6.6
Flask-WTF==0.9.4
ForgeryPy==0.1
Jinja2==2.7.1
Mako==0.9.1
Markdown==2.3.1
MarkupSafe==0.18
Pygments==1.6
SQLAlchemy==0.9.9
WTForms==1.0.5
Werkzeug==0.10.4
alembic==0.6.2
argparse==1.2.1
bleach==1.4
blinker==1.3
colorama==0.2.7
coverage==3.7.1
html5lib==1.0b3
httpie==0.7.2
itsdangerous==0.23
requests==2.1.0
selenium==2.45.0
six==1.4.1
wsgiref==0.1.2

[miguelgrinberg]

This is a Flask bug that has been fixed already, but won't be available until a new release is made. See the PR for the issue.

[sphkan]

Thanks for the information, @miguelgrinberg!