dd/d72/src__sql__kernel__qsqldatabase__snippet_8cpp_source.html

// Copyright (C) 2020 The Qt Company Ltd.

// SPDX-License-Identifier: LicenseRef-Qt-Commercial OR BSD-3-Clause


QSqlDatabase::registerSqlDriver("MYDRIVER", new QSqlDriverCreator<QSqlDriver>);

QVERIFY(QSqlDatabase::drivers().contains("MYDRIVER"));

QSqlDatabase db = QSqlDatabase::addDatabase("MYDRIVER");

QVERIFY(db.isValid());

PGconn *con = PQconnectdb("host=server user=bart password=simpson dbname=springfield");

QPSQLDriver *drv = new QPSQLDriver(con);

QSqlDatabase db = QSqlDatabase::addDatabase(drv); // becomes the new default connection

QSqlQuery query;

query.exec("SELECT NAME, ID FROM STAFF");


unix:LIBS += -lpq

win32:LIBS += libpqdll.lib


QPSQLDriver
Definition qsql_psql_p.h:34

QSqlDatabase
The QSqlDatabase class handles a connection to a database.
Definition qsqldatabase.h:35

QSqlDatabase::isValid
bool isValid() const
Returns true if the QSqlDatabase has a valid driver.
Definition qsqldatabase.cpp:1243

QSqlDatabase::addDatabase
static QSqlDatabase addDatabase(const QString &type, const QString &connectionName=QLatin1StringView(defaultConnection))
\threadsafe
Definition qsqldatabase.cpp:427

QSqlDatabase::registerSqlDriver
static void registerSqlDriver(const QString &name, QSqlDriverCreatorBase *creator)
[2]
Definition qsqldatabase.cpp:528

QSqlDatabase::drivers
static QStringList drivers()
Returns a list of all the available database drivers.
Definition qsqldatabase.cpp:491

QSqlDriverCreator
The QSqlDriverCreator class is a template class that provides a SQL driver factory for a specific dri...
Definition qsqldatabase.h:29

QSqlQuery
The QSqlQuery class provides a means of executing and manipulating SQL statements.
Definition qsqlquery.h:23

QSqlQuery::exec
bool exec(const QString &query)
Executes the SQL in query.
Definition qsqlquery.cpp:371

contains
static bool contains(const QJsonArray &haystack, unsigned needle)
Definition qopengl.cpp:116

query
GLenum query
Definition qopenglext.h:2738

PGconn
struct pg_conn PGconn
Definition qsql_psql_p.h:26

QVERIFY
#define QVERIFY(statement)
Definition qtestcase.h:29

con
PGconn * con
Definition src_sql_kernel_qsqldatabase_snippet.cpp:11

db
QSqlDatabase db
Definition src_sql_kernel_qsqldatabase_snippet.cpp:7

query
QSqlQuery query
Definition src_sql_kernel_qsqldatabase_snippet.cpp:14

drv
QPSQLDriver * drv
Definition src_sql_kernel_qsqldatabase_snippet.cpp:12