Exporting all Logic variables to MySQL?

[Pat_M]

Hi!

Is it possible to traverse all my Logic variables and insert them into my MySQL database in an easy way?

Many thanks!

[Peter_Kawa]

Here’s a way to start:

[APP][PRO] MySQL-Client

[small] A MySQL client for Homey Add this app to use SQL queries in Homey to read or write datasets from/to a local MySQL compatible database. The app provides a driver/device to connect to a database server and one of its databases. The following flow actions can be used from this device: SELECT a dataset with a SQL query (read periodical logged values to use in Homey). UPDATE/INSERT lines using global tokens (log device capabilities to your database). The following flow triggers can …

[Arie_J_Godschalk]

Or the app

Exporteer Insights

[Peter_Kawa]

That would work for numeric values, Arie, but string and bool variables won’t be exported I think.

[Arie_J_Godschalk]

@Peter_Kawa

but string and bool variables won’t be exported I think

Ah, you might be right Peter!

[Pat_M]

Hi,

I have installed the MySQL since earlier and I’m inserting data from my flows into the db. But what I’m really looking for is a (convenient?) way to “flash”-insert/update all of my Logic variables (String/Boolean/Int) ad hoc into the db. So I mirror the Logic variables into MySQL whenever I like to.

I guessing I need a traverse/loop script for all variables and then create a SQL-script with these variables that I will kick off at the the end of the script?

Thanks!

[Arie_J_Godschalk]

If you use BetterLogic variables, there are multiple ways of exporting them

[Pat_M]

Aha, to bad that I already setup all (hundreds) in Logic!