AnswerDotAI / fastsql

https://answerdotai.github.io/fastsql
Apache License 2.0
41 stars 4 forks source link

Add core table record mod methods #2

Closed pydanny closed 3 months ago

pydanny commented 3 months ago
jph00 commented 3 months ago

Also update, although that's not in the .py file -- sorry!

Note that all except delete should return the updated/inserted record (e.g. including auto-generated primary key).

pydanny commented 3 months ago

Fun complication, some of these methods already exist on SQLAlchemy Table classes for rendering of SQL statements. So we'll need to abstract things away an extra step.

jph00 commented 3 months ago

Just need update and upsert now.

jph00 commented 3 months ago

I changed my mind about upsert, since it's not widely enough supported. So we're done for the basics :)