diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2019-02-07 10:19:08 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2019-02-07 10:20:51 -0500 |
| commit | 6c30a06aefd511ac3e84d1ceec0ea314e59117c2 (patch) | |
| tree | 2be4068b480132cffde1ba907c3f2d06e1ba0723 /doc | |
| parent | f572cdf7850b7a2ee6b7535b8129a76fa73496e6 (diff) | |
| download | sqlalchemy-6c30a06aefd511ac3e84d1ceec0ea314e59117c2.tar.gz | |
Use declarative mapping for the embedded SQL expressions example
Change-Id: I1e778409f2d6e50dfba40bafc58e56f3625e7a27
(cherry picked from commit 7816476cdd0a6c83cdd0eeab8698c2469aa0197b)
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/build/orm/persistence_techniques.rst | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/doc/build/orm/persistence_techniques.rst b/doc/build/orm/persistence_techniques.rst index ec13ff782..a26be6b4c 100644 --- a/doc/build/orm/persistence_techniques.rst +++ b/doc/build/orm/persistence_techniques.rst @@ -12,14 +12,17 @@ expression instead of a literal value. It's especially useful for atomic updates, calling stored procedures, etc. All you do is assign an expression to an attribute:: - class SomeClass(object): - pass - mapper(SomeClass, some_table) + class SomeClass(Base): + __tablename__ = "some_table" + + # ... + + value = Column(Integer) someobject = session.query(SomeClass).get(5) # set 'value' attribute to a SQL expression adding one - someobject.value = some_table.c.value + 1 + someobject.value = SomeClass.value + 1 # issues "UPDATE some_table SET value=value+1" session.commit() |
