SQL Server and Python Tutorial

Question

SQL Server and Python Tutorial

Daniel Calbimonte

SSCertifiable

Points: 6292
More actions
November 6, 2023 at 12:00 am

#4309305

Comments posted to this topic are about the item SQL Server and Python Tutorial

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

MMartin1 One Orange Chip Points: 27839 More actions · Answer 1

Finely written article. And well explained, thank you. I do have a question or two.

 with open('c:\data\currencies.csv', 'r') as csv_file:
        csv_reader = csv.reader(csv_file)
        next(csv_reader) # Skip the header row if it exists
        for row in csv_reader:
             currency_code = row[0]
             name = row[1]
        stored_procedure = 'InsertCurrency'
        cursor.execute("{CALL " + stored_procedure + " (?, ?)}", (currency_code, name))
        connection.commit()
        print(f"Inserted: {currency_code}, {name}")
        print("All currencies inserted successfully!")

Where does the loop end? It seems by layman's eyes that everything under "for row in csv_reader " would be indented once. Currency and name are but the rest of the lines are not.

Also since this seems to do a row by row operation, call to a SP, it seems I would not recommend this for a csv file holding tons of records. I would look to Bulk Insert for that. Or am I wrong?

----------------------------------------------------

Phil Parkin SSC Guru Points: 247156 More actions · Answer 2

Some practical examples of where Python beats standard SQL Server functions would be interesting. Or is this aimed simply at people who prefer writing their code in Python?

SQL Server and Python Tutorial

Cookies on SQLServerCentral