nebgor / sma-bluetooth

Automatically exported from code.google.com/p/sma-bluetooth
0 stars 0 forks source link

Multiple sma-tool processes breaks auto_set_dates #17

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
Multiple inputs to the mysql database breaks the auto_set_dates function.

it needs to add inverter or serial to the query string. - otherwise a race 
condition occurs and data is skipped

Suggested query:-

SELECT DATE_FORMAT( DateTime, \"%%Y-%%m-%%d %%H:%%i:%%S\" ) FROM DayData 
WHERE conf.inverter (probably should capture serial somewhere) = "xxxxTL"
ORDER BY DateTime DESC LIMIT 1

Original issue reported on code.google.com by b...@ticm.com on 28 Mar 2011 at 1:58

GoogleCodeExporter commented 8 years ago

Original comment by stephenb...@gmail.com on 20 Apr 2011 at 5:55

GoogleCodeExporter commented 8 years ago
This will be 0.16

Original comment by stephenb...@gmail.com on 27 Nov 2011 at 4:13

GoogleCodeExporter commented 8 years ago
this has been added to code it selects by inverter type and serial

Original comment by stephenb...@gmail.com on 27 Feb 2013 at 7:11