SQLAlchemy insert or update example

Question

In Python  using SQLAlchemy  I want to insert or update a row   I tried this   existing   db session query Toner  for row in data      new   Toner row 0   row 1   row 2     It does not work   How do I INSERT or UPDATE new into Toner table   I suspect it s done with merge  but I cannot understand how to do that

User · Answer

assuming certain column names    INSERT one newToner   Toner toner id   1                      toner color    blue                       toner hex     0F85FF    dbsession add newToner     dbsession commit    INSERT multiple newToner1   Toner toner id   1                      toner color    blue                       toner hex     0F85FF    newToner2   Toner toner id   2                      toner color    red                       toner hex     F01731    dbsession add all  newToner1  newToner2      dbsession commit    UPDATE q   dbsession query Toner  q   q filter Toner toner id  1  record   q one   record toner color    Azure Radiance   dbsession commit    or using a fancy one-liner using MERGE record   dbsession merge Toner    kwargs

User · Answer

I try lots of ways and finally try this   def db persist func       def persist  args    kwargs           func  args    kwargs          try              session commit               logger info  success calling db func      func   name                return True         except SQLAlchemyError as e              logger error e args              session rollback               return False      return persist   and     db persist def insert or update table object       return session merge table object

[python] SQLAlchemy insert or update example

Examples related to python

Examples related to sqlalchemy