From dbf83a3e789a31e670f1f1182de3c4094a5b75fd Mon Sep 17 00:00:00 2001
From: Norbert Moutarde <norbert.moutarde@nothing2do.eu>
Date: Wed, 4 Dec 2013 15:32:10 +0100
Subject: [PATCH] button is yet in the SQLite database (see ui.sql for example)

---
 mainwindow.cpp | 33 ++++++++++++++-------------------
 mainwindow.h   |  2 +-
 2 files changed, 15 insertions(+), 20 deletions(-)

diff --git a/mainwindow.cpp b/mainwindow.cpp
index d5bad52..36cb4c6 100644
--- a/mainwindow.cpp
+++ b/mainwindow.cpp
@@ -51,21 +51,15 @@ void MainWindow::start(){
     flush();
     connectdb();
 
-    //exec(QString("select * from ui;"));
+    qDebug()<<exec(QString("select * from ui;"));
 
-    //r=q->record();
-    /*q->first();
-    int labCol = 0;//r.indexOf("label");
-    int sqlCol = 1;//r.indexOf("sql");
+    r=q->record();
+    qDebug()<<"nmb of col : "<<r.count();
+    int labCol = r.indexOf("label");
+    int sqlCol = r.indexOf("sql");
     while(q->next()){
         addWidget(q->value(sqlCol).toString(), new CLabel(q->value(labCol).toString()));
-    }*/
-    addWidget(QString("select distinct nom from alias order by nom;"), new CLabel("alias"));
-    /*addWidget(QString("select nom from var;"), new CLabel("varr rrr rrr rrr rrr rrr rrr"));
-    addWidget(QString("select distinct word from memo;"), new CLabel("memo dans ton gros culs de chien lymphatique"));*/
-    addWidget(QString("port"), new CLabel("port"));
-    addWidget(QString("host"), new CLabel("host"));
-    addWidget(QString("file"), new CLabel("file"));
+    }
 
 }
 MainWindow::~MainWindow()
@@ -219,7 +213,7 @@ void MainWindow::createMenuBar(){
     menuBar()->addMenu(FileMenu);
     EditMenu=new QMenu(QString("&Edit"));
     EditMenu->addAction(tr("Co&nfig"), this, SLOT(lsconfig()), QKeySequence(tr("Ctrl+N", "Edit|Co&nfig")));
-    EditMenu->addAction(tr("c&reate database"), this, SLOT(createdb()), QKeySequence(tr("Ctrl+R", "Edit|Database")));
+    EditMenu->addAction(tr("C&reate database"), this, SLOT(createdb()), QKeySequence(tr("Ctrl+R", "Edit|Database")));
     menuBar()->addMenu(EditMenu);
     HelpMenu=new QMenu(QString("&Help"));
     HelpMenu->addAction(tr("About Qt"), qApp, SLOT(aboutQt()), QKeySequence(tr("ctrl+H", "About Qt")));
@@ -306,11 +300,11 @@ QString MainWindow::getText(const QString &a){
 void MainWindow::connectdb(){
     db = QSqlDatabase::addDatabase("QSQLITE");
     //db = QSqlDatabase::addDatabase("QPSQL");
-    db.setHostName(host);
+    //db.setHostName(host); useless with SQLite
     db.setDatabaseName(database);
-    db.setUserName(user);
-    db.setPassword(password);
-    db.setConnectOptions(QString("requiressl=1 connect_timeout=10000"));//10sec
+    //db.setUserName(user); useless
+    //db.setPassword(password); same
+    //db.setConnectOptions(QString("requiressl=1 connect_timeout=10000"));//10sec, useless
     qDebug()<<"db.open() ? "<<db.open()<< ". sqlite file : "<<db.databaseName();
     q=new QSqlQuery(db);
 
@@ -336,7 +330,7 @@ int MainWindow::exec(const QString & a){
     q->prepare(a);// make it
     q->exec();// do it
     QSqlError b=q->lastError();
-    if (b.isValid())qDebug()<<"q->lastError():"<<b.text();
+    if (b.isValid())qDebug()<<"SQL error->exec() :"<<b.text();
     return q->size();
 }
 int MainWindow::alias(const QString & a){
@@ -380,6 +374,7 @@ int MainWindow::entry(){
     texte->clear();
 }
 int MainWindow::createdb(){
-    exec(QString("create table ui(keyword text, label text, sql text);"));
+    exec(QString("create table ui(keyword text, label text, action text);"));
     exec(QString("create table raw(date timestamp, text text);"));
+    exec(QString("insert into ui (keyword, label, action) values ('begin', 'chat', 'select texte from raw');"));
 }
diff --git a/mainwindow.h b/mainwindow.h
index 67aa906..7f78724 100644
--- a/mainwindow.h
+++ b/mainwindow.h
@@ -109,7 +109,7 @@ private:
     QList<QString> way;
     QSqlDatabase db;
     QSqlQuery *q;
-    //QSqlRecord r;
+    QSqlRecord r;
 
 };
 
-- 
2.45.1