From 399adc0792855ccae0326352812c8bd7c2ff557f Mon Sep 17 00:00:00 2001
From: Norbert Moutarde <norbert.moutarde@nothing2do.eu>
Date: Sun, 24 Nov 2013 13:07:38 +0100
Subject: [PATCH] begin to think about ui

---
 diary-mobile-android.pro |  3 ++-
 mainwindow.cpp           | 25 ++++++++++++++++---------
 mainwindow.h             |  1 +
 ui.sql                   |  1 +
 4 files changed, 20 insertions(+), 10 deletions(-)
 create mode 100644 ui.sql

diff --git a/diary-mobile-android.pro b/diary-mobile-android.pro
index da46ab0..419b418 100644
--- a/diary-mobile-android.pro
+++ b/diary-mobile-android.pro
@@ -26,4 +26,5 @@ QMAKE_CXXFLAGS += -fpermissive
 ANDROID_PACKAGE_SOURCE_DIR = $$PWD/android
 
 OTHER_FILES += \
-    android/AndroidManifest.xml
+    android/AndroidManifest.xml \
+    ui.sql
diff --git a/mainwindow.cpp b/mainwindow.cpp
index 965564e..95a2984 100644
--- a/mainwindow.cpp
+++ b/mainwindow.cpp
@@ -44,13 +44,22 @@ MainWindow::MainWindow(QWidget *parent)
     setCentralWidget(screen);
     createMenuBar();
     statusBar()->addPermanentWidget(label);
-    qDebug()<<grid->expandingDirections();
+    toggleMenu();
     start();
 }
 void MainWindow::start(){
     flush();
     //connectdb();
 
+    //exec(QString("select * from ui;"));
+
+    //r=q->record();
+    /*q->first();
+    int labCol = 0;//r.indexOf("label");
+    int sqlCol = 1;//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"));*/
@@ -118,7 +127,6 @@ void MainWindow::choosehost(){
     bool ok=0;
     host=QInputDialog::getText(this, QString("Host"), QString("Enter hostname (or ip)"), QLineEdit::Normal, host, &ok);
     if(ok==1)conf->setValue(QString("host"), host);
-    start();
 }
 void MainWindow::chooseuser(){
     bool ok=0;
@@ -144,13 +152,12 @@ void MainWindow::chooseport(){
     }else{
         port=22;
     }
-    start();
 }
 void MainWindow::choosefile(){
     bool ok=0;
     file=QFileDialog::getSaveFileName(this, tr("Open file to write into"), file);
     if (ok)conf->setValue(QString("file"), file);
-    start();
+
 }
 void MainWindow::lsconfig(){
     flush();
@@ -183,7 +190,7 @@ void MainWindow::remWidget(const QString & a){
 }
 void MainWindow::action(const QString & a){
     qDebug()<<"action("<<a<<")";
-    int b;
+    int b=0;
     //if(!alias(a))b=exec(a);
     //qDebug()<<"q->size(action)="<<q->size();
     flush();
@@ -200,6 +207,7 @@ void MainWindow::action(const QString & a){
         addWidget(c,  new CLabel(c));
     }
     qDebug()<<"action() end";
+    start();
 
 }
 void MainWindow::createMenuBar(){
@@ -300,11 +308,10 @@ void MainWindow::connectdb(){
     db.setDatabaseName(database);
     db.setUserName(user);
     db.setPassword(password);
-    db.setConnectOptions(QString("requiressl=1 connect_timeout=10000"));//10sec
+    db.setConnectOptions(QString("requiressl=1 connect_timeout=10000"));//10sec*/
     bool ok=db.open();
-    qDebug()<<"db.open() ? "<<ok;
+    qDebug()<<"db.open() ? "<<ok<< ". Available drivers: " << QSqlDatabase::drivers();
     q=new QSqlQuery(db);
-    qDebug() << "Available drivers: " << QSqlDatabase::drivers();
 
 }
 void MainWindow::firstrun(){
@@ -359,7 +366,7 @@ int MainWindow::entry(){
     flux << a << endl;
     texte->clear();
     fichier.close();
-
+    qDebug()<<a;
     /*q->prepare("INSERT INTO "+database+"raw (date, texte) VALUES (:date, :texte);");
     q->bindValue(":date", v.currentDateTime().toString(QString("yyyy-MM-dd hh:mm:ss")));
     q->bindValue(":texte", texte->text());
diff --git a/mainwindow.h b/mainwindow.h
index ace9bb2..7825970 100644
--- a/mainwindow.h
+++ b/mainwindow.h
@@ -106,6 +106,7 @@ private:
     QList<QString> way;
     QSqlDatabase db;
     QSqlQuery *q;
+    //QSqlRecord r;
 
 };
 
diff --git a/ui.sql b/ui.sql
new file mode 100644
index 0000000..8658b1e
--- /dev/null
+++ b/ui.sql
@@ -0,0 +1 @@
+insert into ui (keyword, label, sql) values ('begin', 'chat', 'select texte from raw')
-- 
2.45.1