/****************************************************************************

**

** All rights reserved.

** Contact: Nokia Corporation (qt-info@nokia.com)

**

** This file is part of the Qt Mobility Components.

**

** $QT_BEGIN_LICENSE:LGPL$

** No Commercial Usage

** This file contains pre-release code and may not be distributed.

** contained in the Technology Preview License Agreement accompanying

** this package.

**

** GNU Lesser General Public License Usage

** Alternatively, this file may be used under the terms of the GNU Lesser

** General Public License version 2.1 as published by the Free Software

** Foundation and appearing in the file LICENSE.LGPL included in the

** packaging of this file.  Please review the following information to

** ensure the GNU Lesser General Public License version 2.1 requirements

** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.

** In addition, as a special exception, Nokia gives you certain additional

** rights.  These rights are described in the Nokia Qt LGPL Exception

** version 1.1, included in the file LGPL_EXCEPTION.txt in this package.

**

** If you have questions regarding the use of this file, please contact

** Nokia at qt-info@nokia.com.

**

**

**

**

**

**

**

** $QT_END_LICENSE$

**

****************************************************************************/

#include <QtCore>

#include <QDebug>

#include "notesmanager.h"

NotesManager::NotesManager(QObject *parent)

    : QObject(parent)

{

    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");

    db.setDatabaseName("todoDB");

    db.open();

    QSqlQuery create;

    create.exec("CREATE TABLE todolist(id INTEGER PRIMARY KEY, notes VARCHAR(255), date VARCHAR(255))");

    nextAlarm();

    QTimer *timer = new QTimer(this);

    QObject::connect(timer, SIGNAL(timeout()), this, SLOT(checkAlarm()));

    timer->start(1000);

}

void NotesManager::nextAlarm()

{

    QSqlQuery alarmQuery("SELECT * FROM todolist WHERE date > DATETIME('now', 'localtime') ORDER BY date");

    if (alarmQuery.next()) { 

    }

}

void NotesManager::checkAlarm()

{

    QString currStr = QDateTime::currentDateTime().toString(Qt::ISODate);

    QDateTime curr = QDateTime::fromString(currStr, Qt::ISODate);

    nextAlarm();

}

{

}

{

}

{

}

{

}

void NotesManager::addNote(const QString& note, const QDateTime& alarm)

{

    QString alert = alarm.toString("yyyy-MM-dd HH:mm:ss");

    QSqlQuery query("INSERT INTO todolist(notes, date) VALUES ('" + note + "', '" + alert + "')");

}

void NotesManager::removeNote(int id)

{

    QSqlQuery query("DELETE FROM todolist WHERE id='" + QString::number(id) + "'");

}

{

    QString queryString = "SELECT * FROM todolist";

    queryString += " ORDER BY date";

    QSqlQuery query(queryString);

    while (query.next()) {

    }

}