Exercise record for connecting to sqlserver using Python

Import pymssql

# Connect database
Conn = pymssql. Connect (host = "192.168.1.28", user = "boomink", password = "boomink", database = "boomink ")

Cur = conn. cursor ()

Print '============================================== ='

Cur.exe cute ("Exec orders_gettest1 @ value = % s", ('2017-01-01 ',))

While 1:
Print cur. fetchall ()
If 0 = cur. nextset ():
Break

Data = cur. fetchall ()

Print data

Print '============================================== ='

Export cur.exe cute ("Exec orders_gettest ")
Cur.exe cute ("Exec orders_gettest2 @ value1 = % s, @ value2 = % s", ('rule', 'yu '))

While 1:
Print cur. fetchall ()

If 0 = cur. nextset ():
Break

Data = cur. fetchall ()

Print data

Print '============================================== ='

Cur.exe cute ("Exec orders_gettracking @ begindate = % s, @ enddate = % s", ('2017-01-01 ', '2017-01-01 '))

Record = cur. fetchall ()

While 1:
Print cur. nextset ()

For R in record:
Print '============================================== ='
A = R [1]
Print 'orderid: % s' % R [0]

Print R
Print '============================================== ='

If 0 = cur. nextset ():
Break

Print "rnrow count: % d" % cur. rowcount

# Commit the connection
Conn. Commit

# Close the connection
Conn. Close