aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorlonkaars <loek@pipeframe.xyz>2022-10-30 14:40:34 +0100
committerlonkaars <loek@pipeframe.xyz>2022-10-30 14:40:34 +0100
commita2f62610144d1ba496ece3946a1e64fe8d6e0f9c (patch)
tree6b44a790030765ef09d15a697e7e24420cc62f1b
parente892ee5639d0f538740e4f1d51284ec27039e270 (diff)
WIP fix HandleMessage
-rw-r--r--client/HandleMessage.cpp7
1 files changed, 2 insertions, 5 deletions
diff --git a/client/HandleMessage.cpp b/client/HandleMessage.cpp
index aa73828..dc25b21 100644
--- a/client/HandleMessage.cpp
+++ b/client/HandleMessage.cpp
@@ -17,15 +17,12 @@ QString HandleMessage::ParseMessage(const QString Msg , int totalRecords )
void HandleMessage::ParseToSQL(QString input)
{
QSqlQuery queryInsertData;
- QString output = "INSERT INTO `WSdb`.`tblMain` () VALUES ";
+ QString output = "insert into WSdb.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)));
@@ -35,11 +32,11 @@ void HandleMessage::ParseToSQL(QString input)
}
output.append(")");
-
if (i+1 < list.size()){
output.append(",");
}
}
+ printf("%s\n", output.toStdString().c_str());
queryInsertData.exec(output);
}