DB Connection from Python and Serial Port connection in Python

 Hi 

Use this code for Python MySql connection. You need mysql.connector for this purpose. you can install this using pip command in Python.

Also install serial using pip for serial connection.

---------------------------------------------------------------------------------------------------------------------

import mysql.connector

import time;

import serial;

from mysql.connector import Error

from mysql.connector import errorcode

ser = serial.Serial('COM3', 9600, timeout=0,parity=serial.PARITY_EVEN, rtscts=1)

try:

   connection = mysql.connector.connect(host='localhost',

                             database='iot',

                             user='root',

                             password='')

   cur = connection.cursor()

   while True:

      s=ser.read();

      print(s);

      time.sleep(1);

      sql=("INSERT INTO timerecord (userid, recordtime, userrole ) VALUES (%s,%s,%s)")

      val=("1",s,"1")

      if s=="9":

         cur.execute(sql,val)

   connection.close()

except mysql.connector.Error as error :

    connection.rollback() #rollback if any exception occured

    print("Failed inserting record into python_users table {}".format(error))