#include "database.h"
#include <QDir>
#include <QtSql>
#include <QSqlDatabase>
#include <QFile>
#include <QObject>
#include <QSqlError>
#include <QSqlQuery>
#include <QDeclarativeItem>
#include <QDebug>
#include <QVariantList>
#include <settings.h>

Database::Database(QDeclarativeItem *parent)
    : QDeclarativeItem(parent)
 {

 }




QVariantList Database::load(QString sql)
{
    QString databaseUrl;
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE", "update");
    //db.setDatabaseName("/home/user/inputMethod/wubiCN.sqlite");


    QVariantList temp;

    if (db.open()) {

        QSqlQuery query(db);

        if( query.exec(sql)) {

            while (query.next()) {
                temp.append(query.value(0).toString());
            }

            qDebug() << temp;
        }

    }
    db.close();
    return temp;

}

void Database::update(QString sql)
{
    QString databaseUrl;
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE", "update");
    //db.setDatabaseName("/home/user/inputMethod/wubiCN.sqlite");
    db.setDatabaseName(Settings.databaseUrl());

    if (db.open()) {

        QSqlQuery query(db);
        query.prepare("PRAGMA synchronous = OFF");
        query.prepare("PRAGMA journal_mode = OFF");
        query.prepare(sql);
        if( query.exec() ) {
            //qDebug() << query.numRowsAffected();
        }
    }

    db.close();

}