"ON COMMIT" is supported in 1.0: http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#postgresql-table-options
until then just emit a SQL string with execute() or DDL(). On Sep 14, 2014, at 12:22 PM, Darin Gordon <[email protected]> wrote: > 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. -- 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.
