/****************************************************************************+
−
**+
−
** Copyright (C) 2010 Nokia Corporation and/or its subsidiary(-ies).+
−
** All rights reserved.+
−
** Contact: Nokia Corporation (qt-info@nokia.com)+
−
**+
−
** 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 Nokia Corporation and its Subsidiary(-ies) 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$+
−
**+
−
****************************************************************************/+
−
+
−
#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. All the examples in this directory use this function to+
−
    connect to a database.+
−
*/+
−
//! [0]+
−
static bool createConnection()+
−
{+
−
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");+
−
    db.setDatabaseName(":memory:");+
−
    if (!db.open()) {+
−
        QMessageBox::critical(0, qApp->tr("Cannot open database"),+
−
            qApp->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 offices (id int primary key,"+
−
                                             "imagefile int,"+
−
                                             "location varchar(20),"+
−
                                             "country varchar(20),"+
−
                                             "description varchar(100))");+
−
    query.exec("insert into offices "+
−
               "values(0, 0, 'Oslo', 'Norway',"+
−
               "'Oslo is home to more than 500 000 citizens and has a "+
−
               "lot to offer.It has been called \"The city with the big "+
−
               "heart\" and this is a nickname we are happy to live up to.')");+
−
    query.exec("insert into offices "+
−
               "values(1, 1, 'Brisbane', 'Australia',"+
−
               "'Brisbane is the capital of Queensland, the Sunshine State, "+
−
               "where it is beautiful one day, perfect the next.  "+
−
               "Brisbane is Australia''s 3rd largest city, being home "+
−
               "to almost 2 million people.')");+
−
    query.exec("insert into offices "+
−
               "values(2, 2, 'Redwood City', 'US',"+
−
               "'You find Redwood City in the heart of the Bay Area "+
−
               "just north of Silicon Valley. The largest nearby city is "+
−
               "San Jose which is the third largest city in California "+
−
               "and the 10th largest in the US.')");+
−
    query.exec("insert into offices "+
−
               "values(3, 3, 'Berlin', 'Germany',"+
−
               "'Berlin, the capital of Germany is dynamic, cosmopolitan "+
−
               "and creative, allowing for every kind of lifestyle. "+
−
               "East meets West in the metropolis at the heart of a "+
−
               "changing Europe.')");+
−
    query.exec("insert into offices "+
−
               "values(4, 4, 'Munich', 'Germany',"+
−
               "'Several technology companies are represented in Munich, "+
−
               "and the city is often called the \"Bavarian Silicon Valley\". "+
−
               "The exciting city is also filled with culture, "+
−
               "art and music. ')");+
−
    query.exec("insert into offices "+
−
               "values(5, 5, 'Beijing', 'China',"+
−
               "'Beijing as a capital city has more than 3000 years of "+
−
               "history. Today the city counts 12 million citizens, and "+
−
               "is the political, economic and cultural centre of China.')");+
−
+
−
    query.exec("create table images (locationid int, file varchar(20))");+
−
    query.exec("insert into images values(0, 'images/oslo.png')");+
−
    query.exec("insert into images values(1, 'images/brisbane.png')");+
−
    query.exec("insert into images values(2, 'images/redwood.png')");+
−
    query.exec("insert into images values(3, 'images/berlin.png')");+
−
    query.exec("insert into images values(4, 'images/munich.png')");+
−
    query.exec("insert into images values(5, 'images/beijing.png')");+
−
+
−
+
−
+
−
    return true;+
−
}+
−
//! [0]+
−
+
−
#endif+
−