我的数据从数据库中打印出来时是这样的。
[(0,), (0,), (0,), (0,), (0,), (0,)]
下面是我的python结果脚本
def readDbHeating():
cursor = mariadb_connection.cursor()
result = []
try:
cursor.execute("SELECT control FROM house_DB")
for reading in cursor.fetchall():
result.append(reading)
except () as e:
print(e)
return (result)
while 1:
result = readDbHeating()
print result
waterState = result[0]
denState = result[3]
niamhState = result[4]
downWCstate = result[5]
if(waterState == 0):
print("here")
flag = 0
print("Water state = %s ") % waterState
我尝试将0设为“0”,并尝试将waterState的传入结果转换为整数,但得到的错误是这是一个元组