python - 当我尝试更新表中的行时，为什么我从 SQLAlchemy 得到 "FROM expression expected"？

Question

我正在尝试更新表格中的一行，但出现参数错误。

代码如下:

inventory_host = InventoryHost(ipv4_addr=ipv4, ipv6_addr=ipv6, macaddr=mac, host_name=name)

try:
    session.add(inventory_host)
    session.commit()
except sqlalchemy.exc.IntegrityError:
    session.execute(update(inventory_host))
    session.commit()

session.close()

这是我遇到的错误:

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "perception.py", line 77, in <module>
    main()
  File "perception.py", line 66, in main
    modules.nmap_parser.parse_nmap_xml(nmap_xml)
  File "/Users/arozar/Documents/Scripts_Code/Python-Projects/perception/modules/nmap_parser.py", line 128, in parse_nmap_xml
    session.execute(update(inventory_host))
  File "<string>", line 2, in update
  File "/Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/sqlalchemy/sql/dml.py", line 668, in __init__
    ValuesBase.__init__(self, table, values, prefixes)
  File "/Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/sqlalchemy/sql/dml.py", line 183, in __init__
    self.table = _interpret_as_from(table)
  File "/Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/sqlalchemy/sql/selectable.py", line 41, in _interpret_as_from
    raise exc.ArgumentError("FROM expression expected")
sqlalchemy.exc.ArgumentError: FROM expression expected

session.add(inventory_host) 适用于 inventory_host 表中的新主机，但只要我尝试使用 session.execute(update(inventory_host)) 我收到错误。

Answer 1

update 将表名作为其第一个参数，而不是您的表类的实例。您要更新什么值？例如，如果你想更新主机名，你可以这样做:

from sqlalchemy import update

# Ideally, just use your primary key(s) in your where clause; I'm not sure what they are
stmt = (update(InventoryHost).where(ipv4_addr=ipv4, ipv6_addr=ipv6, macaddr=mac)
        .values(host_name=name)    # updates the host_name, for example
session.execute(stmt)
...