title: Why can't my code run this code onto python?
body: <p>I am running this code on Python 3(IDLE) on my raspberry pi 3 whith the latest raspbian software. With this code I am trying to obtain temperature data through ds18b20 sensor and sending that same data towards the mysql database I created.</p>
  
  <p>Help would be very much appreciated!</p>
  
  <p>All that is getting executed out of this code is : </p>
  
  <pre><code>Connected to MySQL database... MySQL Server version on  5.5.5-10.1.37-MariaDB-0+deb9u1
  Your connected to -  ('temp_pi',)
  </code></pre>
  
  <p>Which is saying that the connection has been established between the mysql database. But the goal of this code is to obtain temperature data through the ds18b20 sensor and send that same data into the TAB_CLASSROOM table. </p>
  
  <pre><code>import os
  import glob
  import time
  import MySQLdb
  import datetime
  import mysql.connector
  from mysql.connector import Error
  
  i = datetime.datetime.now()
  
  # Establish the connection to the mysql database.
  try:
      connection = mysql.connector.connect(host='127.0.0.1',
                               database='temp_pi',
                               user='root',
                               password='test')
  
      if connection.is_connected():
         db_Info = connection.get_server_info()
         print("Connected to MySQL database... MySQL Server version on ",db_Info)
         cursor = connection.cursor()
         cursor.execute("select database();")
         record = cursor.fetchone()
         print ("Your connected to - ", record)
  
  except Error as e :
      print ("Error while connecting to MySQL", e)
  
  # Obtain the temperature data through the ds18b20 sensor.           
  os.system('modprobe w1-gpio')
  os.system('modprobe w1-therm')
  
  base_dir = '/sys/bus/w1/devices/'
  device_folder = glob.glob(base_dir + '28*')[0]
  device_file = device_folder + '/w1_slave'
  
  def read_temp_raw():
      f = open(device_file, 'r')
      lines = f.readlines()
      f.close()
      return lines
  
  def read_temp():
      lines = read_temp_raw()
      while lines[0].strip()[-3:] != 'YES':
          time.sleep(0.2)
          lines = read_temp_raw()
      equals_pos = lines[1].find('t=')
      if equals_pos != -1:
          temp_string = lines[1][equals_pos+2:]
          temp_c = float(temp_string) / 1000.0
          temp_f = temp_c * 9.0 / 5.0 + 32.0
          return temp_c  
  
      # Send the temperature data into a specific table entitled TAB_CLASSROOM.   
      while True:
              print("recording data into database(period = 5s.)....press ctrl+Z to stop!")
  
              valT = str(read_temp())
  
              year = str(i.year)
              month = str(i.month)
              day = str(i.day)
              date = day + "-" + month + "-" + year
  
              hour = str(i.hour)
              minute = str(i.minute)
              second = str(i.second)
              timestr = hour + ":" + minute + ":" + second
  
              try:
                  cur.execute("""INSERT INTO TAB_CLASSROOM(temp_c,T_Date,T_Time) VALUES(%s,%s,%s)""",(valT,date,timestr))
                  db.commit()
              except:
                  db.rollback()
  
              time.sleep(10)
  
      cur.close()  
      db.close() 
  </code></pre>