blob: 02d7257493bb6b46fb82b4305ef71b5a5f9b1f1a (
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
#include "HandleMessage.h"
HandleMessage::HandleMessage(QObject *parent) : QObject(parent) { }
// void HandleMessage::ParseToSQL(QString input) {
// QSqlQuery queryInsertData;
// QString output = "insert into WSdb.tblMain (temperature, humidity, pressure) values ";
// QStringList data;
//
// output.append("(");
// data=input.split(",");
//
// for (int i = 1; i < data.size(); i++) {
// bool valid;
// output.append(QString::number(data[i].toInt(&valid, 16)));
// if (i + 1 < data.size()) output.append(",");
// }
//
// output.append(")");
// }
void HandleMessage::ParseToSQL(QString input) {
QSqlQuery queryInsertData;
QString output = "INSERT INTO `tblMain` (`temperature`, `humidity`, `pressure`) VALUES ";
QStringList data;
QStringList list = input.split("\n");
for (int i = 0; i < list.size(); ++i) {
output += "(";
data=list[i].split(",");
for (int j = 1; j < data.size(); ++j) {
bool valid;
output.append(QString::number(data[j].toInt(&valid, 16)));
if (j <= data[j].size()) {
output.append(",");
}
}
output.append(")");
if (i+1 < list.size()){
output.append(",");
}
}
queryInsertData.exec(output);
}
|