Re: [sqlalchemy] What is the best way to declare a table with 260 columns and add rows on that table

tps://docs.sqlalchemy.org/en/14/core/metadata.html#sqlalchemy.schema.Table > > If you want to use the ORM layer of SQLAlchemy, you can map classes to > those tables something like this: > > > https://docs.sqlalchemy.org/en/14/orm/mapping_styles.html#imperative-a-k-a-classical-mappings > >

Re: [sqlalchemy] What is the best way to declare a table with 260 columns and add rows on that table

torial.html#executing-multiple-statements > > Hope that helps, > > Simon > > On Wed, Feb 23, 2022 at 8:42 PM janio mendonca junior > wrote: > > > > Hi all, > > > > I have a inquiry from my job to create 2 tables related one-to-one and > insert some rows

[sqlalchemy] What is the best way to declare a table with 260 columns and add rows on that table

Hi all, I have a inquiry from my job to create 2 tables related one-to-one and insert some rows on the table. I have a .CSV with the data dictionary from the table and I am wondering to know how to declare the tables columns automatically without write one by one column (there are 260 columns).