我試圖只過濾外來 id 為 1 的行，或者在這種情況下是“護膚品”，我兩種都試過了，但無論我嘗試什么組合，它要么不應用過濾器，什么都不顯示，要么我得到一個錯誤，它不可迭代。我想要
@views.route("/makeup")
def makeup():
blogs = Blog.query.filter(Blog.category_id == '1').all()
for date, img, title in blogs:
date = Blog.date
img = Blog.fileid
title = Blog.title
return render_template('./makeup.html', blogs = blogs)
class Category(db.Model):
id = db.Column(db.Integer, primary_key = True)
categories = db.Column(db.String(150), unique = True)
formss = db.relationship('Blog', backref = 'category', lazy=True)
def __repr__(self):
return '<Category %r>' % self.id
def __init__(self, categories):
self.categories = categories
class Blog(db.Model):
id = db.Column(db.Integer, primary_key = True)
title = db.Column(db.String(150), unique = True)
fileid = db.Column(db.String(150), unique = True)
date = db.Column(db.String(150))
content = db.Column(db.String(150))
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
def __repr__(self):
return '<Blog %r>' % self.id
def __init__(self, title, fileid, date, content, category):
self.title = title
self.fileid = fileid
self.date = date
self.content = content
self.category = category
{% for date, img, title in blogs %}
<div class="fade1"><div class="fade"><img class="fadeimg" src="{{url_for('static', filename='uploads/')}}{{img}}"><button class="btn">View Post</button></div><p>{{date}}</p><h2>{{title}}</h2></div>
{% endfor %}
uj5u.com熱心網友回復：
我不確定發生了什么，id 是字串還是 int 似乎并不重要。像這樣的東西應該作業。
@views.route("/makeup")
def makeup():
blogs = Blog.query.filter(Blog.category_id == '1').all()
# blogs is a list of model objects
return render_template('./makeup.html', blogs = blogs)
在這里，我們遍歷模型物件串列并使用模型來填充模板。
{% for blog in blogs %}
<div class="fade1"><div class="fade"><img class="fadeimg" src="{{url_for('static', filename='uploads/')}}{{ blog.fileid }}"><button class="btn">View Post</button></div><p>{{ blog.date }}</p><h2>{{ blog.title }}</h2></div>
{% endfor %}
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/456119.html
標籤：Python 烧瓶 网络 sqlalchemy