Post reply

SQL Server and Python Tutorial

  • November 6, 2023 at 12:00 am

    #4309305

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

  • November 6, 2023 at 6:39 am

    #4322041

    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?

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

  • November 6, 2023 at 9:55 am

    #4322147

    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?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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