sqlalchemy中同一表中另一列的sql更新列

Question

列1=abc列1=3列

如何在sqlalchemyorm中执行上述查询

table1 = Table('table1', metadata,
    Column("column1",     SmallInteger(),     nullable=False, autoincrement=False),
    Column("column2",     SmallInteger(),    nullable=False, autoincrement=False),
    Column("column3",     String(length=255), nullable=False)
)

class Table1(object):
    pass
mapper(Table1, table1)

Answer 1

DBSession.query(table1).filter_by(column3 = 'abc').update({"column1":column2}, synchronize_session=False)

用这个

^{pr2}$

http://docs.sqlalchemy.org/en/latest/core/dml.html遵循此链接将指导您