python - 从InfluxDB数据库检索上一次温度测量(Retrieving the last temperature measurement from an InfluxDB database)

Question

I a sending data to an InfluxDB database on a Raspberry Pi.

(我将数据发送到Raspberry Pi上的InfluxDB数据库。)

Data sent via an ESP8266 device.

(通过ESP8266设备发送的数据。)

I am now writing a python script to retrieve the last temperature measurement from the database for the 'outside' sensor.

(我现在正在编写一个python脚本，以从数据库中检索“外部”传感器的最新温度测量值。)

Using:

(使用方法：)

SELECT LAST("temperature") FROM "envirodata" WHERE "location" = 'outside'

(从“环境数据”中选择LAST（“温度”），在“位置” =“外部”)

The ResultSet is always empty even though there is.

(即使有，ResultSet始终为空。)

What am I doing wrong please?

(请问我做错了什么？)

Thanks.

(谢谢。)

  ask by Mike McRoberts translate from so

Answer 1

等待大神答复