Como guardar y visualizar datos en base de datos GRATIS

				
					[
    {
        "id": "72594c6cf3e187c5",
        "type": "debug",
        "z": "a7cda68e269cad0e",
        "name": "debug 25",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "true",
        "targetType": "full",
        "statusVal": "",
        "statusType": "auto",
        "x": 720,
        "y": 940,
        "wires": []
    },
    {
        "id": "e49938d64834e868",
        "type": "http request",
        "z": "a7cda68e269cad0e",
        "name": "",
        "method": "GET",
        "ret": "txt",
        "paytoqs": "ignore",
        "url": "http://192.168.0.34/cm?cmnd=STATUS%200",
        "tls": "",
        "persist": false,
        "proxy": "",
        "insecureHTTPParser": false,
        "authType": "",
        "senderr": false,
        "headers": [],
        "x": 530,
        "y": 880,
        "wires": [
            [
                "273d22936082a16a"
            ]
        ]
    },
    {
        "id": "7957f9fe99d9eee6",
        "type": "inject",
        "z": "a7cda68e269cad0e",
        "name": "",
        "props": [
            {
                "p": "date",
                "v": "iso",
                "vt": "date"
            }
        ],
        "repeat": "3",
        "crontab": "",
        "once": true,
        "onceDelay": "3",
        "topic": "",
        "x": 200,
        "y": 880,
        "wires": [
            [
                "23d3e98baab1ce6a"
            ]
        ]
    },
    {
        "id": "273d22936082a16a",
        "type": "function",
        "z": "a7cda68e269cad0e",
        "name": "Extraer datos del JSON",
        "func": "// Convierte msg.payload a string si no lo es\nvar payloadStr = msg.payload.toString();\n\n// Elimina espacios en blanco al inicio y al final\npayloadStr = payloadStr.trim();\n\n// Si el payload comienza y termina con comillas dobles, las elimina\nif (payloadStr.startsWith('\"') && payloadStr.endsWith('\"')) {\n    payloadStr = payloadStr.substring(1, payloadStr.length - 1);\n}\n\n// Reemplaza las comillas dobles escapadas por comillas dobles reales\npayloadStr = payloadStr.replace(/\\\\\"/g, '\"');\n\ntry {\n    // Parsea el string a objeto JSON\n    var payloadObj = JSON.parse(payloadStr);\n\n    // Verifica si existen los datos de ENERGY\n    if (payloadObj.StatusSNS && payloadObj.StatusSNS.ENERGY) {\n        // Asigna los valores de ENERGY al payload\n        msg.payload = payloadObj.StatusSNS.ENERGY;\n    } else {\n        node.error(\"No se encontró 'StatusSNS.ENERGY' en el payload\", msg);\n        return null;\n    }\n} catch (e) {\n    // Maneja errores de parseo\n    node.error(\"Error al parsear JSON: \" + e.message, msg);\n    return null;\n}\n\nreturn msg;\n",
        "outputs": 1,
        "timeout": 0,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 250,
        "y": 940,
        "wires": [
            [
                "456e7462c5d896e9"
            ]
        ]
    },
    {
        "id": "4086d7eafeeaf2bd",
        "type": "mysql-r2",
        "z": "a7cda68e269cad0e",
        "name": "",
        "host": "192.168.0.125",
        "database": "****",
        "username": "****",
        "password": "****",
        "sql": "",
        "port": "****",
        "pooling": false,
        "waitForConnections": true,
        "connectionLimit": "10",
        "queueTimeout": "10000",
        "x": 580,
        "y": 940,
        "wires": [
            [
                "72594c6cf3e187c5"
            ]
        ]
    },
    {
        "id": "456e7462c5d896e9",
        "type": "template",
        "z": "a7cda68e269cad0e",
        "name": "",
        "field": "sql",
        "fieldType": "msg",
        "format": "handlebars",
        "syntax": "mustache",
        "template": "INSERT INTO `Grafana`.`Consume` (`con_date`, `con_voltage`, `con_current`, `con_power`, `con_AppPower`, `con_ReactPower`, `con_PowerFactor`, `con_EnergyToday`) VALUES ('{{date}}', '{{payload.Voltage}}', {{payload.Current}}, {{payload.Power}}, {{payload.ApparentPower}}, {{payload.ReactivePower}}, {{payload.Factor}}, {{payload.Today}});",
        "output": "str",
        "x": 440,
        "y": 940,
        "wires": [
            [
                "4086d7eafeeaf2bd"
            ]
        ]
    },
    {
        "id": "23d3e98baab1ce6a",
        "type": "function",
        "z": "a7cda68e269cad0e",
        "name": "Normalizar hora",
        "func": "// Obtiene la fecha original de msg.date\nvar originalDate = msg.date;\n\n// Verifica si msg.date está definido\nif (!originalDate) {\n    node.error(\"msg.date no está definido.\", msg);\n    return null;\n}\n\n// Convierte la cadena de fecha a un objeto Date\nvar dateObj = new Date(originalDate);\n\n// Verifica si la fecha es válida\nif (isNaN(dateObj.getTime())) {\n    node.error(\"La fecha proporcionada no es válida: \" + originalDate, msg);\n    return null;\n}\n\n// Extrae los componentes de la fecha y hora en UTC\nvar year = dateObj.getUTCFullYear();\nvar month = ('0' + (dateObj.getUTCMonth() + 1)).slice(-2);\nvar day = ('0' + dateObj.getUTCDate()).slice(-2);\nvar hours = ('0' + dateObj.getUTCHours()).slice(-2);\nvar minutes = ('0' + dateObj.getUTCMinutes()).slice(-2);\nvar seconds = ('0' + dateObj.getUTCSeconds()).slice(-2);\n\n// Formatea la fecha al formato deseado\nmsg.date = `${year}-${month}-${day} ${hours}:${minutes}:${seconds}`;\n\nreturn msg;\n",
        "outputs": 1,
        "timeout": 0,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 360,
        "y": 880,
        "wires": [
            [
                "e49938d64834e868"
            ]
        ]
    }
]