Add item id to sql parameters

[GoogleCodeExporter]

SqlPersistenceService currently provides two parameters for the SQL statement: 
item state and current time. It would be great if the item id could also be 
included as a parameter as it would allow the use of groups when specifying the 
persistent items.

I would use the functionality log all changes on switch states. Now in order to 
record the switch id I need to specify each switch separately.

I'm happy to send a patch, if necessary.

Original issue reported on code.google.com by tho...@raehalme.net on 7 Apr 2013 at 6:31

[GoogleCodeExporter]

+1 from me, too. I did also a local patch to be able to log all information 
into the DB and to get better error messages. Its attached.
@Kai: I can also just check it in, if you don't mind...

Original comment by thomas.letsch.de on 24 Apr 2013 at 6:52

Attachments:

• sqlpersistenceservice.patch

[GoogleCodeExporter]

Thanks for the patch, it is implemented with changeset 
https://code.google.com/p/openhab/source/detail?r=a4c36ea2e8d6cc2f7618b7b7c3f2e9
033082903d

Original comment by kai.openhab on 26 Apr 2013 at 10:03

• Changed state: Implemented
• Added labels: Version-1.3.0
• Removed labels: Version-later