ML_ECMO/ConnectionMySQL.py
b71ab0e3472emaster

ConnectionMySQL.py
View Options

			import tensorflow as tf

			import mysql.connector
			from mysql.connector import Error


			try:
			mySQLconnection = mysql.connector.connect(host='localhost',
			database='newschema',
			user='root',
			password='stella0712')
			sql_select_Query = "SELECT * from results"
			cursor = mySQLconnection .cursor()
			cursor.execute(sql_select_Query)
			records = cursor.fetchall()
			print("Total number of rows in newschema is - ", cursor.rowcount)
			print ("Printing each row's column values i.e. schema record")
			for row in records:
			print("Id = ", row[0], )
			print("SvO2 = ", row[1])
			print("pam = ", row[2])
			print("pp = ", row[3], "\n")
			cursor.close()

			print("\n")
			print(records, "\n")
			print(type(records), "\n")

			dataset = tf.convert_to_tensor(records)

			print(dataset);

			except Error as e:
			print("Error while connecting to MySQL", e)
			finally:
			#closing database connection.
			if mySQLconnection .is_connected():
			mySQLconnection.close()
			print("MySQL connection is closed")