Revision control
++ // Copyright (C) 2016 The Qt Company Ltd.
++ // SPDX-License-Identifier: LicenseRef-Qt-Commercial OR BSD-3-Clause
++
++ #ifndef CONNECTION_H
++ #define CONNECTION_H
++
++ #include <QMessageBox>
++ #include <QSqlDatabase>
++ #include <QSqlError>
++ #include <QSqlQuery>
++
++ /*
++ This file defines a helper function to open a connection to an
++ in-memory SQLITE database and to create a test table.
++
++ If you want to use another database, simply modify the code
++ below.
++ */
++ //! [0]
++ static bool createConnection()
++ {
++ QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
++ db.setDatabaseName(":memory:");
++ if (!db.open()) {
++ QMessageBox::critical(nullptr, QObject::tr("Cannot open database"),
++ QObject::tr("Unable to establish a database connection.\n"
++ "This example needs SQLite support. Please read "
++ "the Qt SQL driver documentation for information how "
++ "to build it.\n\n"
++ "Click Cancel to exit."), QMessageBox::Cancel);
++ return false;
++ }
++
++ QSqlQuery query;
++ query.exec("create table person (id int primary key, "
++ "firstname varchar(20), lastname varchar(20))");
++ query.exec("insert into person values(101, 'Danny', 'Young')");
++ query.exec("insert into person values(102, 'Christine', 'Holand')");
++ query.exec("insert into person values(103, 'Lars', 'Gordon')");
++ query.exec("insert into person values(104, 'Roberto', 'Robitaille')");
++ query.exec("insert into person values(105, 'Maria', 'Papadopoulos')");
++
++ query.exec("create table items (id int primary key,"
++ "imagefile int,"
++ "itemtype varchar(20),"
++ "description varchar(100))");
++ query.exec("insert into items "
++ "values(0, 0, 'Qt',"
++ "'Qt is a full development framework with tools designed to "
++ "streamline the creation of stunning applications and "
++ "amazing user interfaces for desktop, embedded and mobile "
++ "platforms.')");
++ query.exec("insert into items "
++ "values(1, 1, 'Qt Quick',"
++ "'Qt Quick is a collection of techniques designed to help "
++ "developers create intuitive, modern-looking, and fluid "
++ "user interfaces using a CSS & JavaScript like language.')");
++ query.exec("insert into items "
++ "values(2, 2, 'Qt Creator',"
++ "'Qt Creator is a powerful cross-platform integrated "
++ "development environment (IDE), including UI design tools "
++ "and on-device debugging.')");
++ query.exec("insert into items "
++ "values(3, 3, 'Qt Project',"
++ "'The Qt Project governs the open source development of Qt, "
++ "allowing anyone wanting to contribute to join the effort "
++ "through a meritocratic structure of approvers and "
++ "maintainers.')");
++
++ query.exec("create table images (itemid int, file varchar(20))");
++ query.exec("insert into images values(0, 'images/qt-logo.png')");
++ query.exec("insert into images values(1, 'images/qt-quick.png')");
++ query.exec("insert into images values(2, 'images/qt-creator.png')");
++ query.exec("insert into images values(3, 'images/qt-project.png')");
++
++ return true;
++ }
++ //! [0]
++
++ #endif