diff options
Diffstat (limited to 'examples/quick/controls/calendar/src/sqleventmodel.cpp')
| -rw-r--r-- | examples/quick/controls/calendar/src/sqleventmodel.cpp | 103 |
1 files changed, 0 insertions, 103 deletions
diff --git a/examples/quick/controls/calendar/src/sqleventmodel.cpp b/examples/quick/controls/calendar/src/sqleventmodel.cpp deleted file mode 100644 index 92e558ef3..000000000 --- a/examples/quick/controls/calendar/src/sqleventmodel.cpp +++ /dev/null @@ -1,103 +0,0 @@ -/**************************************************************************** -** -** Copyright (C) 2015 The Qt Company Ltd. -** Contact: http://www.qt.io/licensing/ -** -** This file is part of the examples of the Qt Toolkit. -** -** $QT_BEGIN_LICENSE:BSD$ -** You may use this file under the terms of the BSD license as follows: -** -** "Redistribution and use in source and binary forms, with or without -** modification, are permitted provided that the following conditions are -** met: -** * Redistributions of source code must retain the above copyright -** notice, this list of conditions and the following disclaimer. -** * Redistributions in binary form must reproduce the above copyright -** notice, this list of conditions and the following disclaimer in -** the documentation and/or other materials provided with the -** distribution. -** * Neither the name of The Qt Company Ltd nor the names of its -** contributors may be used to endorse or promote products derived -** from this software without specific prior written permission. -** -** -** THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS -** "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT -** LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR -** A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT -** OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, -** SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT -** LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, -** DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY -** THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT -** (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE -** OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE." -** -** $QT_END_LICENSE$ -** -****************************************************************************/ - -#include "sqleventmodel.h" - -#include <QDebug> -#include <QFileInfo> -#include <QSqlError> -#include <QSqlQuery> - -SqlEventModel::SqlEventModel() -{ - createConnection(); -} - -QList<QObject*> SqlEventModel::eventsForDate(const QDate &date) -{ - const QString queryStr = QString::fromLatin1("SELECT * FROM Event WHERE '%1' >= startDate AND '%1' <= endDate").arg(date.toString("yyyy-MM-dd")); - QSqlQuery query(queryStr); - if (!query.exec()) - qFatal("Query failed"); - - QList<QObject*> events; - while (query.next()) { - Event *event = new Event(this); - event->setName(query.value("name").toString()); - - QDateTime startDate; - startDate.setDate(query.value("startDate").toDate()); - startDate.setTime(QTime(0, 0).addSecs(query.value("startTime").toInt())); - event->setStartDate(startDate); - - QDateTime endDate; - endDate.setDate(query.value("endDate").toDate()); - endDate.setTime(QTime(0, 0).addSecs(query.value("endTime").toInt())); - event->setEndDate(endDate); - - events.append(event); - } - - return events; -} - -/* - Defines a helper function to open a connection to an - in-memory SQLITE database and to create a test table. -*/ -void SqlEventModel::createConnection() -{ - QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); - db.setDatabaseName(":memory:"); - if (!db.open()) { - qFatal("Cannot open database"); - return; - } - - QSqlQuery query; - // We store the time as seconds because it's easier to query. - query.exec("create table Event (name TEXT, startDate DATE, startTime INT, endDate DATE, endTime INT)"); - query.exec("insert into Event values('Grocery shopping', '2014-01-01', 36000, '2014-01-01', 39600)"); - query.exec("insert into Event values('Ice skating', '2014-01-01', 57600, '2014-01-01', 61200)"); - query.exec("insert into Event values('Doctor''s appointment', '2014-01-15', 57600, '2014-01-15', 63000)"); - query.exec("insert into Event values('Conference', '2014-01-24', 32400, '2014-01-28', 61200)"); - - return; -} |
