How to assign lastUpdate to an item?

[Udo_Hartmann]

Hi,

I used the following Code to get lastUpdate from mysql:

MyItem_LastUpdate.postUpdate(DateTimeType::DATE_FORMATTER_WITH_TZ.format(MyItem.lastUpdate("mysql")))

But now this Code doesn’t work anymore.
I found https://github.com/openhab/openhab/issues/2945 where DATE_FORMATTER_WITH_TZ is removed in code, so it seems, I have to change the rule, but… how?

[watou (John Cocula)]

Could you replace it with:

MyItem_LastUpdate.postUpdate(new DateTimeType(MyItem.lastUpdate("mysql"))

[Udo_Hartmann]

Finally, I found the time to test, but no luck

The designer says: Incompatible types. Expected java.util.Calendar but was java.util.Date

[watou (John Cocula)]

Ooops, sorry. This might work:

import java.util.Calendar
// ...
var Calendar cal = Calendar::getInstance()
cal.setTime(MyItem.lastUpdate("mysql"))
MyItem_LastUpdate.postUpdate(new DateTimeType(cal))

[Udo_Hartmann]

Thanks, that’s working like a charm

[gnalbandian]

Hi everyone.
I am trying to do the same thing, but I am getting an error.

I have traced the error to this line: cal.setTime(MyItem.lastUpdate(“mysql”))

This is my rule.rules file:

rule "Update timestamp"
when
    Item LastSeenDevices received update
then
        LastSeenDevices.members.forEach[i |
                var Calendar cal = Calendar::getInstance()
                cal.setTime(i.lastUpdate("mysql"))
                // postUpdate("Label_" + i.name, new DateTimeType(cal))
                // logInfo( "HB_LastSeen", "Updating Last seen value for" + i.name)
        ]
end

and the error I am getting is:

00:55:14.579 [ERROR] [.script.engine.ScriptExecutionThread] - Error during the execution of rule 'Update timestamp': Could not invoke method: java.util.Calendar.setTime(java.util.Date) on instance: java.util.GregorianCalendar[time=1457495714566,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="America/Argentina/Cordoba",offset=-10800000,dstSavings=0,useDaylight=false,transitions=62,lastRule=null],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=2016,MONTH=2,WEEK_OF_YEAR=10,WEEK_OF_MONTH=2,DAY_OF_MONTH=9,DAY_OF_YEAR=69,DAY_OF_WEEK=4,DAY_OF_WEEK_IN_MONTH=2,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=55,SECOND=14,MILLISECOND=566,ZONE_OFFSET=-10800000,DST_OFFSET=0]

Could you please help me find the way to solve this.
Thanks, regards!

EDIT: Forgot to told you I am using OH2 and mysql persitence working fine:
±--------------------±------+
| Time | Value |
±--------------------±------+
| 2016-03-08 22:21:05 | OFF |
| 2016-03-08 22:32:03 | ON |
| 2016-03-08 22:33:03 | OFF |
| 2016-03-08 22:34:03 | ON |
| 2016-03-08 22:35:03 | OFF |
| 2016-03-08 22:36:03 | ON |

[smhgit (Eyal Cohen)]

This is exactly the problem I have. wonder if someone solved this issue.

[Udo_Hartmann]

I’m pretty sure you can’t define the var over and over again. Please move the definition out of the rule:

var Calendar cal = null

...

rule...
... cal = Calendar::getInstance() ...
...end

[StefanH (Stefan Haupt)]

just wondering, after two years is this still the preferred way?

EDIT: I somehow expected it. When implementing I got:

The constructor DateTimeType(Calendar) is deprecated

[Udo_Hartmann]

If talking about Time and Date, please take a look at

DateTime Conversion

Overview In openHab there are different ways to handle Date/Time values. DateTimeType A DateTime Item carries a DateTimeType. Joda DateTime By default Rules use a Joda DateTime class to represent time, most notably now. Epoch The lowest common denominator when working with time is to get at the epoc value. Epoc is the number of milliseconds that has passed since 1 January 1970 GMT and stored in a long. With epoc, one can compare two dates together, convert a Joda DateTime to a DateTi…

There are some other really good tutorials for Type conversion.
Maybe also interesting:

Design Pattern: Time Of Day

Please see Design Pattern: What is a Design Pattern and How Do I Use Them for an explanation of what a DP is and how to use them. Problem Statement Often in home automation one has certain rules they want to run at certain times or have the home automation exhibit different behaviors for different times of day. The naieve approach would be to do the time comparisons inline in each Rule that cares about the time of day. This DP provides an alternative approach. This DP is particularly suitable …

[StefanH (Stefan Haupt)]

awesome, now it’s as easy as:

postUpdate(myItem, now.toString)