English 中文(简体)
如何在sqlalchemy ORM查询中传递一个not like运算符
原标题:how to pass a not like operator in a sqlalchemy ORM query

我有一个问题:

MyModel.query.filter(Mymodel.name.contains( a_string ))

我需要执行相同的查询,但使用否定(运算符不同),但在SQLAlchemy文档

有没有什么方法可以在不使用SQLAlchemy的sql部分的情况下做到这一点???

最佳回答

只需否定过滤器:

MyModel.query.filter(sqlalchemy.not_(Mymodel.name.contains( a_string )))
问题回答

现在有一个notlike()方法。在文档中找不到它,但它存在!

MyModel.query.filter(Mymodel.name.notlike( %a_string% ))




相关问题
Entity Framework with File-Based Database

I am in the process of developing a desktop application that needs a database. The application is currently targeted to SQL Express 2005 and works wonderfully. However, I m not crazy about having ...

Assistance with CakePHP model relationships

How would I represent the following in a CakePHP model? Product ======= product_id .... Cart ==== cart_id .... Carts_Products ============== cart_id product_id quantity

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How are Models (in MVC) and DAOs supposed to interact?

How are models and DAOs supposed to interact? I m in the process of putting together a simple login module and I m unsure where to put the "business logic." If I put the logic with the data in the ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签