使用Python在复盆子上通过USB读取RFID

Question

我得到了这个2 python脚本

import serial
serial = serial.Serial("/dev/ttyUSB0", baudrate=9600)
code = ''
while True:
        data = serial.read()
        if data == 'r':
                print(code)
                code = ''
        else:
                code = code + data

和

import time
import datetime
import MySQLdb
localtime = time.localtime(time.time())
day = localtime.tm_wday
time = localtime.tm_hour
print day
print time
data = 'DOSEN1'
db = MySQLdb.connect("localhost", "root", "", "skripsi")
cur = db.cursor()
cond1 = "SELECT nama_dosen FROM dosen WHERE kode_dosen = '%s'" %data
cur.execute(cond1)
hitung = cur.rowcount
res1 = cur.fetchall()
for row in res1:
        nama_dosen = row[0]
if hitung == 1:
        res1 = nama_dosen
elif hitung != 1:
        print "Dosen tidak Terdaftar"

我如何加入这2个脚本，以便将数据="DOSEN1"替换为RFID标签号？

我真的是这个编程语言的新手，真的需要帮助。感谢

Answer 1

假设print(code)在第二个脚本中为data提供了值，则应该可以使用类似的方法：

import serial
import time
import datetime
import MySQLdb
serial = serial.Serial("/dev/ttyUSB0", baudrate=9600)
db = MySQLdb.connect("localhost", "root", "", "skripsi")
cur = db.cursor()
code = ''
while True:
    data = serial.read()
    if data == 'r':
        print(code)
        localtime = time.localtime(time.time())
        day = localtime.tm_wday
        time = localtime.tm_hour
        print day
        print time
        cond1 = "SELECT nama_dosen FROM dosen WHERE kode_dosen = '%s'" %code
        cur.execute(cond1)
        hitung = cur.rowcount
        res1 = cur.fetchall()
        for row in res1:
            nama_dosen = row[0]
        if hitung == 1:
            res1 = nama_dosen
        elif hitung != 1:
            print "Dosen tidak Terdaftar"
        code = ''
    else:
        code = code + data