Hello. Help me understand what is not recording data. Or rather, it is recording empty memory cells. The data is recorded as text - it is recorded in the database, but the numeric values of the data are not recorded. What is the problem? Thank you if you help me solve this problem!
[
{
"id": "a177996e6b9ac64c",
"type": "sqlite",
"z": "01a7c1d8c3d27c56",
"mydb": "9c34a35ae76df126",
"sqlquery": "msg.topic",
"sql": "",
"name": "SQLite universal_data",
"x": 580,
"y": 180,
"wires": [
[
"15f2c5fc21578c76",
"ef8cdefb11f71822"
]
]
},
{
"id": "bfae83be4dc55073",
"type": "function",
"z": "01a7c1d8c3d27c56",
"name": "Insert universal data",
"func": "msg.topic = \"INSERT INTO universal_data (topic, value, timestamp) VALUES (?, ?, ?)\";\nmsg.payload = [\"sim800_rssi\", -87, Date.now()];\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 320,
"y": 180,
"wires": [
[
"a177996e6b9ac64c",
"bcd75a7f6e13dbe3"
]
]
},
{
"id": "df02f63aa9f2eefa",
"type": "inject",
"z": "01a7c1d8c3d27c56",
"name": "data go",
"props": [],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"x": 70,
"y": 220,
"wires": [
[
"bfae83be4dc55073",
"6559007b23da0b1e"
]
]
},
{
"id": "3e839ce6cb02c07d",
"type": "inject",
"z": "01a7c1d8c3d27c56",
"name": "CREATE TABLE",
"props": [
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "CREATE TABLE IF NOT EXISTS universal_data (id INTEGER PRIMARY KEY AUTOINCREMENT, topic TEXT, value REAL, timestamp INTEGER)",
"x": 140,
"y": 60,
"wires": [
[
"a177996e6b9ac64c"
]
]
},
{
"id": "e4d356cfa9cfbcb3",
"type": "inject",
"z": "01a7c1d8c3d27c56",
"name": "🗑DELETE FROM ",
"props": [
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "DELETE FROM universal_data",
"x": 150,
"y": 100,
"wires": [
[
"a177996e6b9ac64c"
]
]
},
{
"id": "c30f7d41f2d9d9be",
"type": "inject",
"z": "01a7c1d8c3d27c56",
"name": "DROP TABLE ",
"props": [
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "DROP TABLE IF EXISTS universal_data",
"x": 130,
"y": 140,
"wires": [
[
"a177996e6b9ac64c"
]
]
},
{
"id": "6bcb2a6550c942fd",
"type": "inject",
"z": "01a7c1d8c3d27c56",
"name": "SELECT * FROM 10",
"props": [
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "SELECT * FROM universal_data ORDER BY timestamp DESC LIMIT 10",
"x": 170,
"y": 260,
"wires": [
[
"a177996e6b9ac64c"
]
]
},
{
"id": "15f2c5fc21578c76",
"type": "function",
"z": "01a7c1d8c3d27c56",
"name": "ui_table",
"func": "if (!Array.isArray(msg.payload)) return msg;\n\nmsg.payload = msg.payload.map(row => {\n return {\n topic: row.topic,\n value: row.value,\n timestamp: new Date(row.timestamp).toLocaleString()\n };\n});\n\nmsg.ui_control = {\n columns: [\n { title: \"Topic\", field: \"topic\" },\n { title: \"Value\", field: \"value\" },\n { title: \"Time\", field: \"timestamp\" }\n ]\n};\n\nreturn msg;",
"outputs": 1,
"timeout": "",
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 400,
"y": 300,
"wires": [
[
"481a0d81e6f3c9c3",
"0e0d4fb401af991b"
]
]
},
{
"id": "481a0d81e6f3c9c3",
"type": "ui_table",
"z": "01a7c1d8c3d27c56",
"group": "db476597c929ed0e",
"name": "📊 universal_data",
"order": 1,
"width": 0,
"height": 0,
"columns": [],
"outputs": 1,
"cts": true,
"x": 710,
"y": 360,
"wires": [
[]
]
},
{
"id": "0e0d4fb401af991b",
"type": "ui-table",
"z": "01a7c1d8c3d27c56",
"group": "50c695cae29114f4",
"name": "📊 universal_data",
"label": "",
"order": 1,
"width": 0,
"height": 0,
"maxrows": "4",
"passthru": false,
"autocols": true,
"showSearch": true,
"deselect": true,
"selectionType": "none",
"columns": [],
"mobileBreakpoint": "sm",
"mobileBreakpointType": "defaults",
"action": "append",
"x": 550,
"y": 400,
"wires": [
[]
]
},
{
"id": "bcd75a7f6e13dbe3",
"type": "debug",
"z": "01a7c1d8c3d27c56",
"name": "debug 573",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 510,
"y": 100,
"wires": []
},
{
"id": "ef8cdefb11f71822",
"type": "debug",
"z": "01a7c1d8c3d27c56",
"name": "debug 574",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 390,
"y": 480,
"wires": []
},
{
"id": "6559007b23da0b1e",
"type": "debug",
"z": "01a7c1d8c3d27c56",
"name": "debug 575",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 190,
"y": 480,
"wires": []
},
{
"id": "9c34a35ae76df126",
"type": "sqlitedb",
"db": "C:\\Users\\aiovi\\Desktop\\sensor.db",
"mode": "RWC"
},
{
"id": "db476597c929ed0e",
"type": "ui_group",
"name": "Данные",
"tab": "0327c8b4b74de169",
"order": 1,
"disp": true,
"width": "10",
"collapse": false
},
{
"id": "50c695cae29114f4",
"type": "ui-group",
"name": "sim800l",
"page": "7dfe5adef484a0e0",
"width": "12",
"height": "1",
"order": 1,
"showTitle": true,
"className": "",
"visible": "true",
"disabled": "false",
"groupType": "default"
},
{
"id": "0327c8b4b74de169",
"type": "ui_tab",
"name": "SQLite",
"icon": "dashboard",
"order": 2,
"disabled": false,
"hidden": false
},
{
"id": "7dfe5adef484a0e0",
"type": "ui-page",
"name": "sim800l",
"ui": "1bb9db23437aaf62",
"path": "/page19",
"icon": "home",
"layout": "grid",
"theme": "27357e1026156686",
"breakpoints": [
{
"name": "Default",
"px": "0",
"cols": "3"
},
{
"name": "Tablet",
"px": "576",
"cols": "6"
},
{
"name": "Small Desktop",
"px": "768",
"cols": "9"
},
{
"name": "Desktop",
"px": "1024",
"cols": "12"
}
],
"order": 1,
"className": "",
"visible": true,
"disabled": false
},
{
"id": "1bb9db23437aaf62",
"type": "ui-base",
"name": "Устройства Управления",
"path": "/dashboard",
"appIcon": "",
"includeClientData": true,
"acceptsClientConfig": [
"ui-notification",
"ui-control"
],
"showPathInSidebar": false,
"navigationStyle": "icon",
"titleBarStyle": "default"
},
{
"id": "27357e1026156686",
"type": "ui-theme",
"name": "Default Theme",
"colors": {
"surface": "#ffffff",
"primary": "#0094CE",
"bgPage": "#eeeeee",
"groupBg": "#ffffff",
"groupOutline": "#cccccc"
},
"sizes": {
"pagePadding": "12px",
"groupGap": "12px",
"groupBorderRadius": "4px",
"widgetGap": "12px"
}
}
]
