Python Forum

Python Forum > Python Coding > General Coding Help > Generate Multiple sql Files With csv inputs
Full Version: Generate Multiple sql Files With csv inputs
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2

vkomarag

Aug-20-2021, 02:26 PM
That's Awesome !! This is my first post in this forum and I literally felt stranded. Thanks for saving me. I will try this and let you know if it is working fine.

vkomarag

Aug-20-2021, 02:37 PM
Can I do it using data frames rather than hardcoding

Yoriz

Aug-20-2021, 02:39 PM
Of course, I just hardcoded it so I didn't need the data frame.

vkomarag

Aug-20-2021, 07:03 PM
(Aug-20-2021, 02:39 PM)Yoriz Wrote: [ -> ]Of course, I just hardcoded it so I didn't need the data frame.

Quote:How can I apply the below lines to data frame?

appropriate_name = ".".join((row["DB"], row["SCH"], row["TAB"]))

columns = ",\n".join(row["COLS"].split(","))
Pages: 1 2
Python Forum > Python Coding > General Coding Help > Generate Multiple sql Files With csv inputs