Write row from sql server table

Question

I am new to python. I can not figre out how to write a sql server table row to an output file. I can pt it on the screen but can't write it to a file.

import pyodbc
f.open(‘c:\python27\out.txt’,w)
cnxn = pyodbc.connect('DRIVER={SQL  Server};SERVER=localhost;DATABASE=vzw;trusted_connection=True')
cursor = cnxn.cursor()
cursor.execute ("select * from vzw.dbo.threcord")
row = cursor.fetchall()
print row  # displays row on screen
f.write     #what goes here to indicate the displayed row?

You can use the csv module to write out the row.

mechanical_meat
– mechanical_meat

2015-02-04 18:50:07 +00:00
Commented Feb 4, 2015 at 18:50 — mechanical_meat
– mechanical_meat, Commented Feb 4, 2015 at 18:50

Community · Accepted Answer · 2017-05-23 11:43:32Z

1

You can output to a comma separated file by utilizing the csv module.

import pyodbc
import csv

cnxn = pyodbc.connect('DRIVER={SQL  Server};SERVER=localhost;DATABASE=vzw;trusted_connection=True')
cursor = cnxn.cursor()
cursor.execute("select * from vzw.dbo.threcord")
row = cursor.fetchall()

with open(r"c:\python27\out.txt", "w") as f:
    csv.writer(f).writerows(row)

A few notes about what I've changed from your code:

I open the file to write to only after the query has been run, instead of at the beginning of the program. Additionally I use the with statement to open the file.
Notice that the file name is a raw string (with the r, because the \s are escape characters.
The file mode needed to be quoted.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Feb 5, 2015 at 18:39

Andy♦

50.8k62 gold badges181 silver badges240 bronze badges

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

Collectives™ on Stack Overflow

Write row from sql server table

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related