blob: 9599f868f4bdfd96bf4d1317368265513c05fea3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
#include "HandleMessage.h"
#include "../shared/util.h"
HandleMessage::HandleMessage(QObject *parent) : QObject(parent) { }
void HandleMessage::ParseToSQL(QString input) {
QSqlQuery queryInsertData;
QString output = "INSERT INTO `tblMain` (`temperature`, `humidity`, `pressure`) VALUES ";
QStringList data;
QStringList list = input.split("\n",Qt::SkipEmptyParts);
for (int i = 0; i < list.size(); ++i) {
data=list[i].split(",");
bool valid;
output.append("(");
output.append(QString::number(ws_sensor_tmp_to_f(data[1].toInt(&valid, 16))));
output.append(",");
output.append(QString::number(ws_sensor_hum_to_f(data[2].toInt(&valid, 16))));
output.append(",");
output.append(QString::number(ws_sensor_atm_to_f(data[3].toInt(&valid, 16))));
output.append(")");
if (i+1 < list.size()) output.append(",");
}
queryInsertData.exec(output);
}
|