From 5d9f94ede1c5a9a110702088c2e06a6118eb8274 Mon Sep 17 00:00:00 2001
From: Norbert Moutarde <norbert.moutarde@nothing2do.eu>
Date: Tue, 3 Dec 2013 13:17:51 +0100
Subject: [PATCH] I try to sqlit'ize the soft

---
 mainwindow.cpp | 12 +++++++++---
 mainwindow.h   |  1 +
 2 files changed, 10 insertions(+), 3 deletions(-)

diff --git a/mainwindow.cpp b/mainwindow.cpp
index 8d5a8a5..e79ffb1 100644
--- a/mainwindow.cpp
+++ b/mainwindow.cpp
@@ -219,6 +219,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")));
     menuBar()->addMenu(EditMenu);
     HelpMenu=new QMenu(QString("&Help"));
     HelpMenu->addAction(tr("About Qt"), qApp, SLOT(aboutQt()), QKeySequence(tr("ctrl+H", "About Qt")));
@@ -335,7 +336,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;
+    if (b.isValid())qDebug()<<"q->lastError():"<<b.text();
     return q->size();
 }
 int MainWindow::alias(const QString & a){
@@ -368,10 +369,15 @@ int MainWindow::entry(){
     flux << a << endl;
     fichier.close();
     qDebug()<<a<<" content added into file";
-    q->prepare("INSERT INTO raw (date, texte) VALUES (:date :texte);");
+    q->prepare("INSERT INTO raw (date, texte) VALUES (:date, :texte);");
     q->bindValue(":date", v.currentDateTime().toString(QString("yyyy-MM-dd hh:mm:ss")));
     q->bindValue(":texte", texte->text());
     q->exec();
+    QSqlError b=q->lastError();
+    if (b.isValid())qDebug()<<"q->lastError():"<<b.text();
     texte->clear();
-
+}
+int MainWindow::createdb(){
+    exec(QString("create table ui(keyword text, label text, sql text);"));
+    exec(QString("create table raw(date timestamp, text text);"));
 }
diff --git a/mainwindow.h b/mainwindow.h
index 5a75440..67aa906 100644
--- a/mainwindow.h
+++ b/mainwindow.h
@@ -85,6 +85,7 @@ private slots:
     int alias(const QString &, int &);
     int exec(const QString &);
     int entry();
+    int createdb();
 public slots:
 
 signals:
-- 
2.45.1