diff options
author | UnavailableDev <69792062+UnavailableDev@users.noreply.github.com> | 2022-10-29 14:19:51 +0200 |
---|---|---|
committer | UnavailableDev <69792062+UnavailableDev@users.noreply.github.com> | 2022-10-29 14:19:51 +0200 |
commit | 6d9df6fe97502a852b68c8c8e6781d7208170cae (patch) | |
tree | 2485788cf73e7ccaaa02288285cd2f536d65f600 /client/main.cpp | |
parent | 28af8ed412224bd8969db98521b67e0f4027ddf7 (diff) |
test version
Diffstat (limited to 'client/main.cpp')
-rw-r--r-- | client/main.cpp | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/client/main.cpp b/client/main.cpp index 8561786..0a1c4e4 100644 --- a/client/main.cpp +++ b/client/main.cpp @@ -16,6 +16,8 @@ #include "ui_mainwindow.h" #include "mytcpsocket.h" #include "timetest.h" +#include "csv_import.h" +#include <QDebug> QSqlDatabase dbRef = QSqlDatabase(); @@ -29,7 +31,21 @@ int main(int argc, char *argv[]) dbRef = QSqlDatabase::addDatabase("QMYSQL"); - w.show(); + QString input = "000e,1d,2f,28\n000d,1d,2f,28\n000c,1d,2f,29\n000b,1d,2f,28\n000a,1d,2f,2a"; + CSV_Import import; + + + QString output = "INSERT INTO `WSdb`.`tblMain` () VALUES "; + QVector<QString> list = input.split("\n"); + for (int i = 0; i < list.size(); ++i) { + output.append(import.csvToSql(list[i])); + if (i+1 < list.size()){ + output.append(","); + } + } + qDebug() << output; + + w.show(); return a.exec(); } |