/****************************************************************************+
−
**+
−
** 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:LGPL$+
−
** No Commercial Usage+
−
** This file contains pre-release code and may not be distributed.+
−
** You may use this file in accordance with the terms and conditions+
−
** 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$+
−
**+
−
****************************************************************************/+
−
+
−
#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+
−