Changeset adb0f52 for de.wigbels.ruby

Timestamp:

Nov 20, 2014, 11:47:30 PM (9 years ago)

Author:

njw <njw@…>

Branches:

master

Children:

516b934

Parents:

9125727

Message:

Fetch one result

File:

• de.wigbels.ruby/hothotwrite/hhw.rb (modified) (1 diff)

de.wigbels.ruby/hothotwrite/hhw.rb

@@ -53 +53 @@
     log.info("Inserted sensor: #{sensorid} with data: #{data}")
   else
-    years = dbh.query( %Q"select count(distinct year(measuredat)) FROM sensor" )
-    put years
+    years = dbh.query( %Q"select count(distinct year(measuredat)) FROM sensor" ).fetch_row[0]
     # Auswertung Gesamtes Jahr, Monat, Vergleich Vorjahr
     myquery = %Q{ select sum(data), 'Liter Verbrauch in #{month}-#{logyear}' \