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

I wonder if one can also do this with Declarative Base classes using `type` construction? Like, to dynamically create a Declarative Class from some pre-defined namespace dicts: Base = declarative_base() metas = [{'__tablename__': 'footable'}, ...] columns = [{ 'key': 'field1', 'type': Text},

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

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 > wrote: > > I have this project(stock market data) where I need many tables(200+) > and > > each

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

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, Prashanth

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

> > @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 at 1:54 PM, Prashanth Budihal >

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

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 ?

> > 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

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

On Mon, Mar 26, 2018 at 1:54 PM, Prashanth Budihal wrote: > 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

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

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