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?

chris47803

Hello.
Unfortunately, I only see my headings. The contents of my database are not displayed.

{
            module: 'MMM-MysqlQuery',
			      position: "top_right",
			      header: "Test",            
            config: {
                connection: {
                    host: "192.168.2.1",
                    port: 3306,
                    user: "test",
                    password: "test",
                    database: "test"
                },
                query: `select titel, jahr from test order by titel
                        limit 3`,
    			intervalSeconds: 15 * 60,
                emptyMessage: "No spices",
                columns: [
                    { name: "titel",      title: "Titel",  cssClass: "right" },
                    { name: "jahr",      title: "Jahr",  cssClass: "right" },                    

                ]
            }
        },

sifuhall

@chris47803
I have the same issue. Only the headings are displayed