Hello All can someone help me with the below code. Ive been working to try and get the output printed to a file with the datetime but each route Ive tried I seem to get an error can anyone point out what I am doing wrong?
2020-03-31
ERROR name 'sys' is not defined
Traceback (most recent call last):
File "./pncnetworktest.py", line 55, in <module>
sys.stdout.close()
NameError: name 'sys' is not defined
#! /usr/bin/python3.6 import pymysql import datetime date = str(datetime.date.today()-datetime.timedelta(1)) filename = datetime.datetime.now() print(date) try: db_con1 = pymysql.connect(host='nhmanpncblt01.xxx.xxx.com', port=3306, user='xxx', passwd='xxx', db='photonicnetworkcaptures') sql_select_Query = "select * from pncnetwork where startTime regexp \'^{}\'".format(date) db_con2 = pymysql.connect(host='nhmanpnckey01.xxx.xxx.com', port=3306, user='xxx', passwd='xxx', db='photonicnetworkcaptures') sql_select_Query = "select * from pncnetwork where startTime regexp \'^{}\'".format(date) db_con3 = pymysql.connect(host='nhmanpncfre01.xxx.xxx.com', port=3306, user='xxx', passwd='xxx', db='photonicnetworkcaptures') sql_select_Query = "select * from pncnetwork where startTime regexp \'^{}\'".format(date) db_con4 = pymysql.connect(host='NHMANPNCNE01.xxx.xxx.com', port=3306, user='xxx', passwd='xxx', db='photonicnetworkcaptures') sql_select_Query = "select * from pncnetwork where startTime regexp \'^{}\'".format(date) cursor1 = db_con1.cursor() cursor2 = db_con2.cursor() cursor3 = db_con3.cursor() cursor4 = db_con4.cursor() cursor1.execute(sql_select_Query) cursor2.execute(sql_select_Query) cursor3.execute(sql_select_Query) cursor4.execute(sql_select_Query) records1 = cursor1.fetchall() records2 = cursor2.fetchall() records3 = cursor3.fetchall() records4 = cursor4.fetchall() sys.stdout = open(filename.strftime("%d %B %Y")+".txt", "w") print ("Total number of rows in pncnetwork is: ", cursor1.rowcount + cursor2.rowcount + cursor3.rowcount + cursor4.rowcount) print ("\nPrinting each pncnetwork record") for row in records1: print("{}, {}".format("Beltway", row[2], row[3])) for row in records2: print("{}, {}".format("Keystone", row[2], row[3])) for row in records3: print("{}, {}".format("Freedom", row[2], row[3])) for row in records4: print("{}, {}".format("New England", row[2], row[3])) except Exception as e: print("ERROR ", str(e)) finally: db_con1.close() db_con2.close() db_con3.close() db_con4.close() sys.stdout.close()./pncnetworktest.py
2020-03-31
ERROR name 'sys' is not defined
Traceback (most recent call last):
File "./pncnetworktest.py", line 55, in <module>
sys.stdout.close()
NameError: name 'sys' is not defined