小白第一次嘗試用flask-sqlalchemy操作sql
food表中的tags是以逗號分隔的字串，例：blue,guitar
我想查詢資料庫中tags欄位是否含有某關鍵字，例如將表中所有含有blue的tags的項的價格查出來
我嘗試在filter中用in，但是報錯AttributeError: 'NoneType' object has no attribute 'in_'
class Food(db.Model):
__tablename__ = 'food'
id = db.Column(db.Integer, primary_key=True)
cat_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
name = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue())
price = db.Column(db.Numeric(10, 2), nullable=False)
main_image = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue())
summary = db.Column(db.String(10000), nullable=False, server_default=db.FetchedValue())
stock = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
tags = db.Column(db.String(200), nullable=False, server_default=db.FetchedValue())
status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
def query_price(self,goodsname):
obj = self.query.filter(self.tags.in_(goodsname)).first()
return obj.price
下面是我的查詢陳述句
goods_price = Food().query_price(data_name)
求問大佬們有沒有好方法解決
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/23223.html
標籤：MySQL
下一篇：mysql前后字符之間截取替換