Python plugin store data in database

[Ewaldharmsen]

I am currently working on a python plugin, and I would like store data in the database so that it is still available after a reboot.

So I have a variable A with Value 12345. After a reboot of the plugin I want to retrieve the value 12345 from the database.

If I am correct this is not yet possible, is this correct?

Will this be possible in the future?

[pipiche]

What python plugin developpers usaly do is to store those data in a local file created/updated and managed by the plugin itself.
For instance you can use some serialize python module like json or pickle to store and read your data

[Dnpwwo]

@Ewaldharmsen,

There is no specific support from the Plugin Framework for database access other than values in the Parameter dictionary to help you locate database itself.

Developers of C++ hardware support access the database directly using a sqlite3 library and there is nothing to prevent Python developers from doing the same using the Python sqlite3 module that ships with Python.

Creating your own table and storing data is a better user experience than writing a data file because restoring a database will give users a consistent experience of rolling your plugin data back to time of the backup along with the rest of Domoticz.

[Ewaldharmsen]

@Ewaldharmsen,

There is no specific support from the Plugin Framework for database access other than values in the Parameter dictionary to help you locate database itself.

Developers of C++ hardware support access the database directly using a sqlite3 library and there is nothing to prevent Python developers from doing the same using the Python sqlite3 module that ships with Python.

Creating your own table and storing data is a better user experience than writing a data file because restoring a database will give users a consistent experience of rolling your plugin data back to time of the backup along with the rest of Domoticz.

Do you have an example for me?

[Ewaldharmsen]

Another question: is it possible to store data on the hardware page itself?

Simply putting Parameters["Mode2"] == "test" obviously does not work.
I would like a more dynamic hardware page.

In this case I want to have an optional field on the hardware page. If people fill it in it is ok. If they don't I want to fill it in from the plugin.

[Dnpwwo]

@Ewaldharmsen,

There is no specific example because it very straightforward. Search 'python sqlite3' on the internet and there are tutorials on what to do.

The plugin is handed the database file name in the 'Parameters["Database"]' dictionary entry.

To modify the parameters you could update 'Mode2' in the 'Hardware' table where the 'Extra' field = 'Parameters["Key"]'

[Ewaldharmsen]

thank you very much, works like a charm!