Check-A-Prijs-Mobile-App_Hack-O-Topia_PTC / PriceCharm / sqltest.py
sqltest.py
Raw
"""
Supposed to be our Database Connection File managing 
all the connections From or to the database
"""

import pyodbc 
cnxn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                      "Server=localhost;"
                      "Database=master;"
                      "Trusted_Connection=yes;")


cursor = cnxn.cursor()

print(cursor)
cursor.execute("""SELECT TOP (1000) [optname]
      ,[value]
      ,[major_version]
      ,[minor_version]
      ,[revision]
      ,[install_failures]
  FROM [master].[dbo].[MSreplication_options]""")

for row in cursor:
    print('row = %r' % (row,))