1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
| #!/usr/bin/env python
# -*- coding: utf-8 -*-
import MySQLdb
import time
import serial
db = MySQLdb.connect("localhost", "root", "root", "AcrobatX") or die
("impossible de se connecter a la bd")
curs = db.cursor()
device = '/dev/ttyUSB0' # définition du port USB utilise par l'arduino
try:
print("en cours de connexion..."), device
# arduino = serial.Serial(device, 9600),
arduino = serial.Serial(
port='/dev/ttyUSB0',
baudrate=57600,
parity=serial.PARITY_NONE,
stopbits=serial.STOPBITS_ONE,
bytesize=serial.EIGHTBITS,
timeout=5
)
except:
print("Echec de la connexion"), device
try:
data = arduino.readline() # lecture des données de arduino
print(data)
print("arduino readline")
line = data
print(line)
pieces = line.split(', ') # divise les donnees par une tabulation
print(pieces[x])
print("line: %s") % data
print("Piece 1: %s") % pieces[0]
print("Piece 2: %s") % pieces[1]
print("Piece 3: %s") % pieces[2]
print("Piece 4: %s") % pieces[3]
print("Piece 5: %s") % pieces[4]
try:
curs.execute("""INSERT INTO sauts
(id,piste1,piste2,piste3,piste4,piste5,moment)
VALUES("%s,%s,%s,%s,%s,NOW()),
(data)""")
#(pieces[0],pieces[1],pieces[2],pieces[3,pieces[4],)""")
db.commit()
print("Data insere")
cursor.close()
except MySQLdb.IntegrityError:
print("echec de transmission")
finally:
cursor.close()
except:
print("Impossible d'obtenir du data de l'arduino")
db.rollback() |
Partager