MMM-MysqlQuery module just released!

ralberth

I just finished a new MySQL module, available at MMM-MysqlQuery.

This queries a MySQL database you have access to on a regular basis, and displays the results as an HTML table on MagicMirror.

Screenshots:
Table

Empty table

Foguet

Just what I needed. Thank you for your contribution

Richard238

Had to add a line:

position: 'bottom_right'

Now to make the SQL work with the Mysqli db I have running on an adjacent pi.

Richard238

I have this module working quite well, just a couple of queries:

How do you get the title “______________MYSQL SPICES” line displayed?
I am getting just the table, not the title header line.

And how might you change “Amt” form an integer, to a message saying “Too High” or Too low"?
[I am actually measuring temperature and lux levels, but the principle’s the same.]

Thank you.

Richard238

@Richard238 said in MMM-MysqlQuery module just released!:

I have this module working quite well, just a couple of queries:

How do you get the title “______________MYSQL SPICES” line displayed?
I am getting just the table, not the title header line.

And how might you change “Amt” form an integer, to a message saying “Too High” or Too low"?
[I am actually measuring temperature and lux levels, but the principle’s the same.]

Thank you.

~~How do you get the title “______________MYSQL SPICES” line displayed?~~
Fixed that one in config.js with header: 'Module Title',

Other enhancements still need attention, if anyone can help, please?