Python SQL help

[Stanzilus]

Hello all,

I am new to python and working on a school project to import an SQL query with python and have it print out results then save them to a file location. This is what I have so far and wanted to know what I am missing or if this looks good :)

Any help would be great as I am trying to get this down.

Thanks!

import adodbapi

# Connect to the SQL DB

conn = adodbapi.connect("Provider=SQLDB.1;SERVER= x.x.x.x ;User Id=user;Password=pass;DATABASE=db database;")
curs = conn.cursor()

# Execute SQL query test_file.sql"

query = 'test_file'
curs.execute('test_file')
results = curs.fetchall()
print results
results = open('test_file.txt','w')
print>>results,'test_file'
results.close()

conn.close()