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

Re: [sqlalchemy] Dynamic model creation for temporary table

2013-09-25 Thread Michael Bayer
On Sep 25, 2013, at 2:15 AM, Aleksandr Kuznetsov aku.ru...@gmail.com wrote: The rotation of tables is not a problem. Of course I can do it by constructing simple SQL statement. I just want to simplify life for a client (client is an app for collecting data) - I want it should pass to me

[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

Re: [sqlalchemy] Dynamic model creation for temporary table

2013-09-24 Thread Michael Bayer
On Sep 24, 2013, at 10:42 AM, Aleksandr Kuznetsov aku.ru...@gmail.com wrote: 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). silly question, is there a reason standard