Re: [sqlalchemy] Dynamic model creation for temporary table

2013-09-25 Thread Aleksandr Kuznetsov
Thanks for the answer! silly question, is there a reason standard replication techniques provided by the database can't be used here? they might be a little more heavy-handed to set up than some in-app trick but it'll work more solidly. Yes, there is a reason: there are no any standard

[sqlalchemy] Dynamic model creation for temporary table

2013-09-24 Thread Aleksandr Kuznetsov
Hi! I have ModelA model (declarative style) for persistent table. I have to periodically update that table with some external data (replace existing data with new). It must be performed with minimal locking and there must not be mixed old data and new data. I see the follwing way to implement