import pymysql
import datetime
import serial
from time import sleep

# coding: utf8


ser = serial.Serial('/dev/ttyUSB1', 9600, timeout=0)


connection = pymysql.connect(host='localhost',
                             user='root',
                             password='',
                             db='fsae',
                             charset='utf8mb4')

while True:
    while (ser.inWaiting() == 0):
        pass
    data = ser.readline(9600).strip('\r\n')
    parsed = data.split(',')
    print
    data

    #   try:
    #    with connection.cursor() as cursor:
    #         # Novo recorde
    #          sql = "INSERT INTO pequena (seno,cosseno) VALUES (%s,%s)"
    #           cursor.execute(sql, (seno, cosseno))
#
#   connection.commit()
# finally:
#     pass
# if len(parsed)==2:
#	packet.append(parsed)
#	if len(packet)==10:
#		print packet
#		for i in range(10):
#			cursor = conn.cursor()
#			cursor.execute("INSERT INTO testes5 VALUES (%s, %s)", (packet[i][0], packet[i][1]))
#			conn.commit()
#			print "mysql upload", i+1
#		packet=[]
# else:
#	print "data com mais de 2 colunas"
# sleep(0.1)



connection.close()
ser.close()

# assyncio