Re: [sqlalchemy] How to create multiple TABLES and INSERTS programatically ?

2018-03-31 Thread Prashanth Budihal
Hello testing my messages are being deleted On Tuesday, March 27, 2018 at 12:12:51 AM UTC+5:30, Mike Bayer wrote: > > On Mon, Mar 26, 2018 at 1:54 PM, Prashanth Budihal > <prasha...@gmail.com > wrote: > > I have this project(stock market data) where I need many tables(2

Re: [sqlalchemy] How to create multiple TABLES and INSERTS programatically ?

2018-03-31 Thread Prashanth Budihal
For the benefit of others visiting this page. This is another way to do it. Uses Class type https://stackoverflow.com/questions/2768607/dynamic-class-creation-in-sqlalchemy On Tuesday, March 27, 2018 at 12:12:51 AM UTC+5:30, Mike Bayer wrote: > > On Mon, Mar 26, 2018 at 1:54 PM, Pra

Re: [sqlalchemy] How to create multiple TABLES and INSERTS programatically ?

2018-03-31 Thread Prashanth Budihal
> > @Mike Bayer > > I thought I will post here an alternate solution. > https://stackoverflow.com/questions/2768607/dynamic-class-creation-in-sqlalchemy > > > On Tuesday, March 27, 2018 at 12:12:51 AM UTC+5:30, Mike Bayer wrote: > > On Mon, Mar 26, 2018

Re: [sqlalchemy] How to create multiple TABLES and INSERTS programatically ?

2018-03-31 Thread Prashanth Budihal
For the benefit of other visitors to this page,another solution I found. https://stackoverflow.com/questions/2768607/dynamic-class-creation-in-sqlalchemy On Tuesday, March 27, 2018 at 12:12:51 AM UTC+5:30, Mike Bayer wrote: > > On Mon, Mar 26, 2018 at 1:54 PM, Prashanth Budihal >

Re: [sqlalchemy] How to create multiple TABLES and INSERTS programatically ?

2018-03-29 Thread Prashanth Budihal
> > Thanks Mike for that quick help. I will try write a new code and test it > out. All 200+ tables are same except the inserted data and table names vary. I will get back to you after I modify my code. Thanks. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper

[sqlalchemy] How to create multiple TABLES and INSERTS programatically ?

2018-03-26 Thread Prashanth Budihal
I have this project(stock market data) where I need many tables(200+) and each one will receive fresh data inserts periodically(every 5 minutes). I have gone thru couple of tutorials about sqlalchemy ORM and they all show how to create a single table and do few inserts. But if I have to create