我试着从一个函数中得到3个数据。^来自get_gyro_data()
函数的{
math functions
math functions
.
.
.
x= x/scaler
y= y/scaler
z=z/scaler
return {'x': x, 'y': y, 'z': z}
def get_all_data(self):
gyro = get_gyro_data()
得到陀螺数据后,尝试编写数据库
while True :
mpu = MPU6050(0x68) //my sensor
gyro_data = mpu.get_gyro_data()
print(gyro_data['x'])
print(gyro_data['y'])
print(gyro_data['z'])
Time = (time.strftime("%H:%M:%S"))
Date = (time.strftime("%Y-%m-%d"))
print (Time + " - " + Date)
sql = ("""INSERT INTO `TAB_TEMP` (`Date`,`Time`,`JX`,`JY`,`JZ`,`IX`,`IY`,`IZ`) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)"""(Date,Time,accel_data['x'],accel_data['y'],accel_data['z'],gyro_data['x'],gyro_data['y'],gyro_data['z']))
cursor.execute(sql) // execute sql command
调试程序时,出现异常TypeError:“str”对象不能在sql= (""" INSERT .... )
行调用
目前没有回答
相关问题 更多 >
编程相关推荐