Python Inserting data into Sql Server

Question

Struggling to figure out why this isnt working. I don't get any errors but it will not write to the table.

import pyodbc
connprod = pyodbc.connect('DRIVER={SQL Server};SERVER=server;DATABASE=master;Trusted_Connection=yes')
cursorprod = connprod.cursor()

conndev = pyodbc.connect('DRIVER={SQL Server};SERVER=server;DATABASE=master;Trusted_Connection=yes')
cursordev = conndev.cursor()

connlocal=pyodbc.connect('DRIVER={SQL Server};SERVER=server;DATABASE=DBA;Trusted_Connection=yes')
cursorlocal = connlocal.cursor()

cursorprod.execute("SELECT Servername = @@servername    ,Date = getdate()   ,wait_type  ,waiting_tasks_count    ,wait_time_ms   ,max_wait_time_ms   ,signal_wait_time_ms FROM sys.dm_os_wait_stats GO")
rows = cursorprod.fetchall()

for row in rows:
    cursorlocal.execute('insert into dba.dbo.dm_os_wait_stats values (?,?,?,?,?,?,?)', row)
    cursorlocal.commit

tuomur · Accepted Answer · 2014-10-21 13:00:02Z

2

If your example is accurate, you're not calling the commit method:

cursorlocal.commit()

answered Oct 21, 2014 at 13:00

tuomur

7,15838 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tuomur Over a year ago

commit is not the same as commit(). You are not calling the method. If you remove the indent the commit will be called after all execute() calls. It just depends on what you want to do.

Collectives™ on Stack Overflow

Python Inserting data into Sql Server

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related