我想运行一个查询,选择所有标题匹配'%'+ [some_phrase] +'%'的不区分大小写的帖子。也就是说,选择标题包含某个短语的所有行,不区分大小写。从我做的研究,看起来像我需要使用Postgres的ILIKE查询来匹配不区分大小写。如何使用SQLAlchemy执行这样的查询?
$ b $ pre $ class Post(db.Model): id = db .Column(db.Integer,primary_key = True) title = db.Column(db.String(250)) content = db.Column(db.String(5000))解决方案
我认为它应该工作
Post.query.filter(Post.title.ilike('%some_phrase%'))docs.sqlalchemy/en/latest/orm/internals.html?highlight=ilike#sqlalchemy.orm.attributes.QueryableAttribute.ilike
I'd like to run a query that selects all posts, case insensitive, that have titles that match '%' + [some_phrase] + '%'. That is, select all rows that have titles that contain some phrase, case insensitive. From the research I've done, it looks like I need to use Postgres's ILIKE query for it to match case insensitive. How can I execute a query like this with SQLAlchemy?
class Post(db.Model): id = db.Column(db.Integer, primary_key = True) title = db.Column(db.String(250)) content = db.Column(db.String(5000))解决方案
I think it should work
Post.query.filter(Post.title.ilike('%some_phrase%'))docs.sqlalchemy/en/latest/orm/internals.html?highlight=ilike#sqlalchemy.orm.attributes.QueryableAttribute.ilike
更多推荐
PostgreSQL与SQLAlchemy的ILIKE查询
发布评论