import pymssql

server = 'srv-sql-mirror\jirareport'
database = 'srv-jira-prod-report'
username = ''
password = ''

cnxn = pymssql.connect(host=server, user=username, password=password, database=database)

cursor = cnxn.cursor()
cursor.execute("SELECT count(*) from dbo.worklog")
row = cursor.fetchone()
for t in row:
    print(t)