Deleting data from a database in Qt

Overview

This example shows you how to delete data from an SQLite database in Qt.

The table 'person' has the following columns:

• 76ytuiytuityutyutututyutyutyu, this is an autoincrement field
• 76ytuiytuityutyutututyutyutyu
• 76ytuiytuityutyutututyutyutyu
• 76ytuiytuityutyutututyutyutyu

Preconditions

• Qt is installed on your platform.
  • S60:
    • Download Qt release from here: Qt pre-release
    • Install Qt: How to Install Qt
    • Check this link for installation guide: How to install the package
    • Qt Tower release has SQLite support. The required libraries are built into the Qt release.
  • Maemo:
    • More information about Qt on Maemo can be found here: Qt4 Maemo port

For Maemo SQLite development, the following packages must be installed:

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

Header

1. include <QObject>
2. include <QSqlDatabase>
3. include <QSqlError>
4. include <QSqlQuery>
5. include <QString>

class DatabaseManager : public QObject

   {
   public:
       DatabaseManager(QObject *parent = 0);
       ~DatabaseManager();
       
   public:
       bool openDB();
       bool deletePerson(int id);

   private:
       QSqlDatabase db;
   };

Source

Delete a person from the database: bool DatabaseManager::deletePerson(int id)

   {
   bool ret = false;
   if (db.isOpen())
       {
       QSqlQuery query;
       ret = query.exec(QString("delete from person where id=%1").arg(id));
       }
   return ret;
   }

The 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

A person's data is deleted from the database.

See also

• Creating an SQLite database in Qt
• Creating a database table in Qt
• Inserting a row into a database in Qt
• Searching for data in a database in Qt
• Selecting data from a database without using SQL statements in Qt
• Using QDataWidgetMapper to show data from a database in Qt

• QtSql module