Logic Machine Forum
Store and modify a data table via script in Wiser for KNX - Printable Version

+- Logic Machine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: Scripting (https://forum.logicmachine.net/forumdisplay.php?fid=8)
+--- Thread: Store and modify a data table via script in Wiser for KNX (/showthread.php?tid=3346)



Store and modify a data table via script in Wiser for KNX - Kilogica - 06.05.2021

Hello,

I'm trying to make in W4K a simple booking interface that saves name, code for room unlocking, date of code activation and date of code expiration, is it possible to manage a simple database?

I've even thought about JSON but I don't know if it can be safe enough.

Any ideas?

Thank you


RE: Store and modify a data table via script in Wiser for KNX - admin - 06.05.2021

You can create custom tables in LM SQLite database if needed. Docs on LM database commands: https://openrb.com/docs/db.htm


RE: Store and modify a data table via script in Wiser for KNX - Kilogica - 07.05.2021

Thank you, I'll check it out!


RE: Store and modify a data table via script in Wiser for KNX - Kilogica - 13.05.2021

Hello,

is there a way to check database tables besides LUA scripts?


RE: Store and modify a data table via script in Wiser for KNX - admin - 13.05.2021

You can download the backup, extract it and view the database using SQLite DB browser or similar software.