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 > <[email protected] <javascript:>> 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 they all > show > > how to create a single table and do few inserts. But if I have to create > > 200+ tables then should I create/type manually 200+ mapped classes ? > Thats > > impractical isnt it ? I face same hurdle while doing INSERTS. Can > anybody > > here give me a hint atleast how to go about this ? Which part of > sqlalchemy > > addresses this hurdle. I admit I am a newbie to sql and sqlalchemy so > please > > bear with me if there is already a solution and I havent studied it yet. > > Thanks in advance. > > Python is a fully dynamic language so if you needed 200 classes given > a list of 200 names, you would never have to "type" that manually. > However if this is a really simple case then just use core: > > my_twohundred_names = [ ... names ....] > > with engine.connect() as conn: > for name in my_twohundred_names: > t = Table(name, MetaData(), Column('q', Integer), Column('p', > Integer), ... ) > conn.execute(t.insert(), {"q": 5, "p": 10}) > > something like that. > > if these tables have all kinds of different columns you can reflect them: > > > my_twohundred_names = [ ... names ....] > > with engine.connect() as conn: > for name in my_twohundred_names: > t = Table(name, MetaData(), autoload_with=conn) > conn.execute(t.insert(), {"q": 5, "p": 10}) > > but you need to know what the columns are that you are inserting. > > > > > > -- > > SQLAlchemy - > > The Python SQL Toolkit and Object Relational Mapper > > > > http://www.sqlalchemy.org/ > > > > To post example code, please provide an MCVE: Minimal, Complete, and > > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > > description. > > --- > > 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] <javascript:>. > > To post to this group, send email to [email protected] > <javascript:>. > > Visit this group at https://groups.google.com/group/sqlalchemy. > > For more options, visit https://groups.google.com/d/optout. > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
