blocks|key|374765|text|只需使用getattr标准python库函数按名称获取属性：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|374766|col_name+=+'subject'
db_session.query(Notice).filter(getattr(Notice,+col_name).like("%25"+%2B+query+%2B+"%25"))|code-block|syntax|javascript|374767|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.python.org/library/functions.html#getattr^0|4|7|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Just use <a href="http://docs.python.org/library/functions.html#getattr">getattr</a> standard python library function to get an attribute by name:

<pre><code>col_name = 'subject'
db_session.query(Notice).filter(getattr(Notice, col_name).like("%" + query + "%"))
</code></pre>

blocks|key|374796|text|在较新的sqlalchemy版本中，应该这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|374797|Notice.__table__.c[col_name]|code-block|syntax|javascript|374798|所以：|374799|(db_session
++++.query(Notice)
++++.filter(Notice.__table__.c[col_name].like("%25"+%2B+query+%2B+"%25")
)|374800|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

In newer sqlalchemy version, it should be done this way:

<pre><code>Notice.__table__.c[col_name]
</code></pre>

So:

<pre><code>(db_session
 .query(Notice)
 .filter(Notice.__table__.c[col_name].like("%" + query + "%")
)
</code></pre>

blocks|key|590541|text|公认的答案有一个解决方案，但一个过时的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|590542|SQLAlchemy+1.3建议将所有文本过滤器放在text()中，并加入and。Docs|offset|length|style|CODE|590543|示例：session.query(User).filter(text("id<224")).order_by(text("id")).all()|590544|来自不同查询的文档的另一个example|590545|>>>+s+=+select([
...++++++++text("users.fullname+%7C%7C+',+'+%7C%7C+addresses.email_address+AS+title")
...+++++]).\
...+++++++++where(
...+++++++++++++and_(
...+++++++++++++++++text("users.id+=+addresses.user_id"),
...+++++++++++++++++text("users.name+BETWEEN+'m'+AND+'z'"),
...+++++++++++++++++text(
...+++++++++++++++++++++"(addresses.email_address+LIKE+:x+"
...+++++++++++++++++++++"OR+addresses.email_address+LIKE+:y)")
...+++++++++++++)
...+++++++++).select_from(text('users,+addresses'))|code-block|syntax|javascript|590546|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.sqlalchemy.org/en/latest/orm/tutorial.html#using-textual-sql|1|https://docs.sqlalchemy.org/en/latest/core/tutorial.html#using-text-fragments-inside-bigger-statements^0|0|Q|6|11|3|15|4|0|0|3|1X|0|D|7|1|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@$D|12|E|13|F|G]|$D|14|E|15|F|G]]|9|@$D|16|E|17|1|18]]|A|$]]|$1|H|3|I|5|6|7|19|8|@$D|1A|E|1B|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1C|8|@]|9|@$D|1D|E|1E|1|1F]]|A|$]]|$1|L|3|M|5|N|7|1G|8|@]|9|@]|A|$O|P]]|$1|Q|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]|Y|$5|T|U|V|A|$W|Z]]]]

The accepted answer has a solution, but an outdated one.

SQLAlchemy 1.3 suggests putting all text filters in <code>text()</code>, joined with <code>and</code>.
<a href="https://docs.sqlalchemy.org/en/latest/orm/tutorial.html#using-textual-sql" rel="nofollow noreferrer">Docs</a>

Example: <code>session.query(User).filter(text("id&lt;224")).order_by(text("id")).all()</code>

Another <a href="https://docs.sqlalchemy.org/en/latest/core/tutorial.html#using-text-fragments-inside-bigger-statements" rel="nofollow noreferrer">example</a> from docs on a different query

<pre><code>&gt;&gt;&gt; s = select([
... text("users.fullname || ', ' || addresses.email_address AS title")
... ]).\
... where(
... and_(
... text("users.id = addresses.user_id"),
... text("users.name BETWEEN 'm' AND 'z'"),
... text(
... "(addresses.email_address LIKE :x "
... "OR addresses.email_address LIKE :y)")
... )
... ).select_from(text('users, addresses'))
</code></pre>

blocks|key|374912|text|我尝试了@vans解决方案，但它不起作用。我总是收到一个AttributeError，抱怨我的表没有这一列。对我来说起作用的是table.columns|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|374913|getattr(Notice.columns,col_name)|code-block|syntax|javascript|374914|entityMap^0|1R|D|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

I tried @vans solution but it didn't work. I always got an AttributeError complaining that my table didn't have that column. What worked for me was <code>table.columns</code>:

<pre><code>getattr(Notice.columns,col_name)
</code></pre>

I want to create query in sql alchemy filter, but column is(dynamic) in variable/specified in variable.

Original Query:

<pre><code>db_session.query(Notice).filter(Notice.subject.like("%" +query+ "%"))
</code></pre>

I want to do query like this:

<pre><code>col_name='subject'
db_session.query(Notice).filter(Notice.col_name.like("%" +query+ "%"))
col_name='status'
status=0
db_session.query(Notice).filter(Notice.col_name != 1)
</code></pre>

How to give column name dynamically from string variable in sql alchemy filter?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我想在sql炼金术过滤器中创建查询，但列在变量中(动态)/在变量中指定。原始查询：db_session.query(Notice).filter(Notice.subject.like("%" +query+ "%"))我想做这样的查询：col_name='subject'db_session.query(Notice...

问如何在sql炼金术过滤器中从字符串变量中动态给出列名？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在sql炼金术过滤器中从字符串变量中动态给出列名？EN