Hi Simon, Thank you for your help. I am brand new working with SQLalchemy, really appreciate if you explain how to generate the metadata with the list of column names from the .CSV to create the tables?
On Wed, Feb 23, 2022, 3:52 PM Simon King <si...@simonking.org.uk> wrote: > Build a list of Column objects from the columns in the CSV file, and > use that list to create a Table: > > https://docs.sqlalchemy.org/en/14/core/metadata.html > > Once you've created the Table, you can insert data into it using the > table.insert() method: > > > https://docs.sqlalchemy.org/en/14/core/tutorial.html#executing-multiple-statements > > Hope that helps, > > Simon > > On Wed, Feb 23, 2022 at 8:42 PM janio mendonca junior > <janio...@gmail.com> wrote: > > > > 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). Same > thing for the insert, how to add rows to the multiple columns table without > write column by column? > > > > I have the data in a Data frame but I was not able to insert it using > df.to_sql from pandas. Do you guys have any similar example? > > > > Thank you all > > > > -- > > 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 sqlalchemy+unsubscr...@googlegroups.com. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/CADF7wwb0_ncRuU_CadqFegE9583W-xWWD4x%3DGy8V%3DgW0jKtcyg%40mail.gmail.com > . > > -- > 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 sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/CAFHwexexvrpmr%3DEA4w%3DmncyiKyxj0yk%3Dcr9_%2Br%3Db3MCyOiHg%3DA%40mail.gmail.com > . > -- 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 sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/CADF7wwYLD-OrxU9-Eq5mnSMoCBJ-EcFEcD%3DVXUEJJNLCx_dOjw%40mail.gmail.com.
