推荐学习书目
› 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
这是一个创建于 3030 天前的主题，其中的信息可能已经有所发展或是发生改变。
正在使用ponyorm尝试弄出一个基于flask的网站. 但是在处理 update 的时候发现怎么弄都弄不好.
处理 update 的 view 如下. 可是在实际情况中是点了 submit 之后, redirect 到的 index.html 页面上显示的数据信息根本就没有 update 到.
目前的 active 是 False, 我想在通过选择 active 到 True 然后点击 submit:
- 把 active 保存到数据库;
- 之后重定向到 index.html.
@app.route('/update/<int:id>', methods=('GET', 'POST'))
@db_session
def update(id):
record = Tconfused.get(lambda p: p.id == id)
form = UpdateForm()
form.id.data = record.id
form.active.data = record.active
form.url.data = record.url
if request.method == 'POST' and form.validate_on_submit():
record.active = form.active.data
record.url = form.url.data.strip()
return redirect(url_for('index'))
return render_template('update.html', record=record, form=form)
从 f12 看见的 form data 也都没有错误
csrf_token:1473071404##a662b5cd7428bb709b74372a0d12eed2d9c26b32
active:1
url:http://www.google.com
请问, 要达到我的目的, 这个 view 里面有关数据库操作的部分要怎么写呢? 这里是完整的 3 个文件代码:
- confused.py
- templates/index.html
- templates/update.html
confused.py
import os
from pony.orm import Database, db_session, Required, Optional
from flask import Flask, redirect, url_for, render_template, request
from flask_wtf import Form
from wtforms import SelectField, StringField, IntegerField
from wtforms.validators import DataRequired
ABS_DB_PATH = os.path.basename(__file__) + 'confuse.db'
db = Database()
app = Flask(__name__)
app.config['SECRET_KEY'] = 'confused'
class Tconfused(db.Entity):
active = Required(bool, default=0)
url = Optional(str)
class UpdateForm(Form):
id = IntegerField('ID')
active = SelectField('Active', choices=[(1, 'True'),
(0, 'False')])
url = StringField('URL', validators=[DataRequired('url needed.')])
@app.route('/')
@db_session
def index():
records = Tconfused.select()[:]
return render_template('index.html', records=records)
@app.route('/update/<int:id>', methods=('GET', 'POST'))
@db_session
def update(id):
record = Tconfused.get(lambda p: p.id == id)
form = UpdateForm()
form.id.data = record.id
form.active.data = record.active
form.url.data = record.url
if request.method == 'POST' and form.validate_on_submit():
record.active = form.active.data
record.url = form.url.data.strip()
return redirect(url_for('index'))
return render_template('update.html', record=record, form=form)
if __name__ == '__main__':
db.bind('sqlite', ABS_DB_PATH, create_db=1)
db.generate_mapping(create_tables=1)
app.run(host='0.0.0.0', debug=1, port=5011)
index.html
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<div>
<table>
<thead>
<tr>
<td>edit</td>
<td>id</td>
<td>active</td>
<td>url</td>
</tr>
</thead>
<tbody>
{% for record in records %}
<tr>
<td><a href="/update/{{ record.id }}">edit</a></td>
<td>{{ record.id }}</td>
<td>{{ record.active }}</td>
<td>{{ record.url }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</body>
</html>
update.html
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<div>
<form action="" method="post">
{{ form.hidden_tag() }}
<div>{{ form.id.label(disabled=True) }} {{ form.id.data }}</div>
<div>{{ form.active.label }} {{ form.active() }}</div>
<div>{{ form.url.label }} {{ form.url(size=50) }}</div>
<div><input type="submit"></div>
</form>
</div>
<br>
<div>
<table>
<thead>
<tr>
<td>id</td>
<td>active</td>
<td>url</td>
</tr>
</thead>
<tbody>
<tr>
<td>{{ record.id }}</td>
<td>{{ record.active }}</td>
<td>{{ record.url }}</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
Select Language