Support for upsert operations via sqlalchemy-hana? about sqlalchemy-hana HOT 3 CLOSED

Hi, I guess beside not using UPSERT but a kind of UPDATE/SELECT/INSERT combination with exception handling, I'm not aware of other options than adding support for UPSERT in sqlalchemy-hana. I'm currently busy working on cleanup tasks, but I can have a look in the following weeks

from sqlalchemy-hana.

@therhaag I did some research and I guess we need to make a difference between SQLAlchemy core and SQLAlchemy ORM.
For SQLAlchemy core, the only way is a manual approach using SELECT, INSERT and UPDATE. Not nice and it has some roundtrips. For this, we could build an UPSERT construct.

For SQLAlchemy ORM using the Session API on the other hand it's not quite easy, because how sessions work. For this, I would recommend using session.merge. I also found a blog explaining the idea.

So let's focus on SQLAlchemy Core. I guess it makes sense to invent a completly new construct, because neither insert nor update have a similar syntax compared to UPSERT.

As said, I'm happy to work on this in the next weeks but to be transparent, It will most likely somewhen in January. If you like you can also try to open a PR

from sqlalchemy-hana.

@therhaag 1.2.0 was just released 😄

from sqlalchemy-hana.