summaryrefslogtreecommitdiffstats
path: root/examples/quick/controls/calendar/src/sqleventmodel.cpp
diff options
context:
space:
mode:
Diffstat (limited to 'examples/quick/controls/calendar/src/sqleventmodel.cpp')
-rw-r--r--examples/quick/controls/calendar/src/sqleventmodel.cpp103
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;
-}