How to collect information from multiple mqtt Node-Red nodes?

Question

JavaScript

The existing scheme in Node-Red:

the db_query function is described as follows and only populates the database with the values ​​of one node:

var newMsg = {payload : msg.payload};
newMsg.topic ="INSERT INTO `m2m`.`sens1` (`TEMP`) VALUES ("+newMsg.payload+")";
return newMsg;

Please tell me how to write data collection (collect_data function) from nodes into several variables to pass them to the db_query function and create one SQL INSERT query in the database.
The table in the database in which the data is entered:

select * from sens1;
+----+------+-------+-------+-----+---------------------+
| id | TEMP | HUMID | PRESS | AIR | date                |
+----+------+-------+-------+-----+---------------------+
|  1 | 41.2 |     0 |     0 |   0 | 2016-11-15 22:08:54 |
+----+------+-------+-------+-----+---------------------+
1 row in set (0.00 sec)

Thank you!

Answer 1

As an option, use the global node-red space, that is, use either global.get/set or flow.get/set
nodered.org/docs/writing-functions (find the Flow context subheading)
You can put readings from these mqqt into this global variable blocks and do a check for filling them, as soon as they are filled, make an entry in the database and reset this global variable and everything will start over again.