Below, I create a very basic temp table that will delete rows on commit. How do I go about replicating this example using the sqlalchemy orm?
I tried to research other posts related to temp tables and sql alchemy. The closest I got was Mike's SelectInto recipe and an older post in this google group. In my case, I'm working with a pre-defined temp table schema that I will be inserting values into. So, I don't think that the SelectInto recipe applies. sqlalchemy already has support for prefixes in __table_args__ but what about suffixes? Where do I put "on commit delete rows" ? I suppose that this would provide a working solution? create temp table check_keys (pk_id int primary key) ON COMMIT DELETE ROWS; begin; insert into check_keys values (1),(2),(3),(4),(7); select * from check_keys; commit; select * from check_keys; thanks for considering my request for help Regards Darin -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
