×
Namespaces

Variants
Actions
(Difference between revisions)

Creating a database table in Qt

From Nokia Developer Wiki
Jump to: navigation, search
tepaa (Talk | contribs)
tepaa (Talk | contribs)
Line 96: Line 96:
  
 
     #ifdef Q_OS_LINUX
 
     #ifdef Q_OS_LINUX
     // in Maemo we create database into memory because
+
     // NOTE: We have to store database file into user home folder in Linux
     // it does not work from file
+
     QString path(QDir::home().path());
     db.setDatabaseName(":memory:");
+
     path.append(QDir::separator()).append("my.db.sqlite");
 +
    path = QDir::toNativeSeparators(path);
 +
    db.setDatabaseName(path);
 
     #else
 
     #else
     // Set database to be created into file.
+
     // NOTE: File exists in the application private folder, in Symbian Qt implementation
    // In Symbian file exists in the application private folder
+
 
     db.setDatabaseName("my.db.sqlite");
 
     db.setDatabaseName("my.db.sqlite");
 
     #endif
 
     #endif

Revision as of 14:41, 22 September 2009

Article Metadata
Tested with
Devices(s): Nokia 5800 eXpressMusic, Nokia N900
Compatibility
Platform(s): Qt
Symbian
Article
Keywords: QSqlDatabase, QSQlite, QSqlError, QSqlQuery
Created: (09 Sep 2009)
Last edited: tepaa (22 Sep 2009)

Contents

Overview

This example shows you how to create 'person' table into (SQLite) database in Qt.

Table person has following columns


Preconditions

  • Qt is installed on your platform


    • Maemo
      • More information about Qt on Maemo can be found here: Qt4 Maemo port


Maemo SQLite development needs following packages to be installed:

  • libqt4-sql
  • libqt4-sql-sqlite
  • libsqlite3-0
  • libsqlite3-dev


Header

#include <QObject>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
 
class DatabaseManager : public QObject
{
public:
DatabaseManager(QObject *parent = 0);
~DatabaseManager();
 
public:
bool openDB();
bool createPersonTable();
 
private:
QSqlDatabase db;
};


Source

Create "person" table.

bool DatabaseManager::createPersonTable()
{
// Create table "person"
bool ret = false;
if (db.isOpen())
{
QSqlQuery query;
ret = query.exec("create table person "
"(id integer primary key, "
"firstname varchar(20), "
"lastname varchar(30), "
"age integer)");
 
}
return ret;
}

Rest of the code...

bool DatabaseManager::openDB()
{
// Find QSLite driver
db = QSqlDatabase::addDatabase("QSQLITE");
 
#ifdef Q_OS_LINUX
// NOTE: We have to store database file into user home folder in Linux
QString path(QDir::home().path());
path.append(QDir::separator()).append("my.db.sqlite");
path = QDir::toNativeSeparators(path);
db.setDatabaseName(path);
#else
// NOTE: File exists in the application private folder, in Symbian Qt implementation
db.setDatabaseName("my.db.sqlite");
#endif
 
// Open databasee
return db.open();
}


Postconditions

Database table "person" created.


See also

688 page views in the last 30 days.

Was this page helpful?

Your feedback about this content is important. Let us know what you think.

 

Thank you!

We appreciate your feedback.

×