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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95
| #include "mainwindow.h"
#include <QApplication>
#include <QFile>
#include <QTextStream>
#include <QDebug>
#include <QString>
#include <QStringList>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlQuery>
#include <iostream>
using namespace std;
int main(int argc, char *argv[])
{
QApplication a(argc, argv);
MainWindow w;
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("points.db");
if(db.isValid() && db.open())
{
qDebug() << "DATA BASE CONNECTION OK";
}
QSqlQuery Create_Table_Points;
if(Create_Table_Points.exec("CREATE TABLE IF NOT EXISTS points"
"(ID INTEGER PRIMARY KEY, "
"LONGITUDE DOUBLE, "
"LATITUDE DOUBLE)"))
{
qDebug() << "Creation Table Done";
}
QFile *f = new QFile("./machin.m");
if(f->open(QIODevice::ReadOnly | QIODevice::Text ))
{
qDebug() << "File Open in Read Mode\n";
}
else
{
qDebug() << "No";
}
while(!f->atEnd())
{
count++;
line = QString(f->readLine());
QStringList list;
/*Traitement sur les lignes du fichiers 'line'...*/
if(line.isEmpty())
{
continue;
}
qDebug() << list.value(1).toInt();
qDebug() << list.value(5).toDouble();
qDebug() << list.value(6).toDouble();
int toto = list.value(1).toInt();
double titi = list.value(5).toDouble();
double tutu = list.value(6).toDouble();
QSqlQuery fill_table_points;
fill_table_points.prepare("INSERT INTO points (ID, LONGITUDE, LATITUDE)"
"VALUE (:ID, :LONGITUDE, :LATITUDE)");
/*Remplissage avec les valeur toto, titi et tutu........mais je 'y arrive pas :(*/
fill_table_points.bindValue(":ID",toto);
fill_table_points.bindValue(":LONGITUDE",titi);
fill_table_points.bindValue(":LATITUDE",tutu);
if(fill_table_points.exec(
)){
qDebug() << " Fill OK";
}
else
{
qDebug() <<"NO" ;
}
}
w.show();
return a.exec();
} |
Partager