![]() |
Qt 6.x
The Qt SDK
|
#include <qsql_psql_p.h>
Public Member Functions | |
QPSQLDriver (QObject *parent=nullptr) | |
QPSQLDriver (PGconn *conn, QObject *parent=nullptr) | |
~QPSQLDriver () | |
bool | hasFeature (DriverFeature f) const override |
Returns true if the driver supports feature feature; otherwise returns false . | |
bool | open (const QString &db, const QString &user, const QString &password, const QString &host, int port, const QString &connOpts) override |
Derived classes must reimplement this pure virtual function to open a database connection on database db, using user name user, password password, host host, port port and connection options options. | |
bool | isOpen () const override |
Returns true if the database connection is open; otherwise returns false. | |
void | close () override |
Derived classes must reimplement this pure virtual function in order to close the database connection. | |
QSqlResult * | createResult () const override |
Creates an empty SQL result on the database. | |
QStringList | tables (QSql::TableType) const override |
Returns a list of the names of the tables in the database. | |
QSqlIndex | primaryIndex (const QString &tablename) const override |
Returns the primary index for table tableName. | |
QSqlRecord | record (const QString &tablename) const override |
Returns a QSqlRecord populated with the names of the fields in table tableName. | |
Protocol | protocol () const |
QVariant | handle () const override |
Returns the low-level database handle wrapped in a QVariant or an invalid variant if there is no handle. | |
QString | escapeIdentifier (const QString &identifier, IdentifierType type) const override |
Returns the identifier escaped according to the database rules. | |
QString | formatValue (const QSqlField &field, bool trimStrings) const override |
Returns a string representation of the field value for the database. | |
bool | subscribeToNotification (const QString &name) override |
This function is called to subscribe to event notifications from the database. | |
bool | unsubscribeFromNotification (const QString &name) override |
This function is called to unsubscribe from event notifications from the database. | |
QStringList | subscribedToNotifications () const override |
Returns a list of the names of the event notifications that are currently subscribed to. | |
![]() | |
QSqlDriver (QObject *parent=nullptr) | |
Constructs a new driver with the given parent. | |
~QSqlDriver () | |
Destroys the object and frees any allocated resources. | |
virtual bool | isOpen () const |
Returns true if the database connection is open; otherwise returns false. | |
bool | isOpenError () const |
Returns true if the there was an error opening the database connection; otherwise returns false . | |
virtual bool | beginTransaction () |
This function is called to begin a transaction. | |
virtual bool | commitTransaction () |
This function is called to commit a transaction. | |
virtual bool | rollbackTransaction () |
This function is called to rollback a transaction. | |
virtual QStringList | tables (QSql::TableType tableType) const |
Returns a list of the names of the tables in the database. | |
virtual QSqlIndex | primaryIndex (const QString &tableName) const |
Returns the primary index for table tableName. | |
virtual QSqlRecord | record (const QString &tableName) const |
Returns a QSqlRecord populated with the names of the fields in table tableName. | |
virtual QString | formatValue (const QSqlField &field, bool trimStrings=false) const |
Returns a string representation of the field value for the database. | |
virtual QString | escapeIdentifier (const QString &identifier, IdentifierType type) const |
Returns the identifier escaped according to the database rules. | |
virtual QString | sqlStatement (StatementType type, const QString &tableName, const QSqlRecord &rec, bool preparedStatement) const |
Returns a SQL statement of type type for the table tableName with the values from rec. | |
QSqlError | lastError () const |
Returns a QSqlError object which contains information about the last error that occurred on the database. | |
virtual QVariant | handle () const |
Returns the low-level database handle wrapped in a QVariant or an invalid variant if there is no handle. | |
virtual bool | hasFeature (DriverFeature f) const =0 |
Returns true if the driver supports feature feature; otherwise returns false . | |
virtual void | close ()=0 |
Derived classes must reimplement this pure virtual function in order to close the database connection. | |
virtual QSqlResult * | createResult () const =0 |
Creates an empty SQL result on the database. | |
virtual bool | open (const QString &db, const QString &user=QString(), const QString &password=QString(), const QString &host=QString(), int port=-1, const QString &connOpts=QString())=0 |
Derived classes must reimplement this pure virtual function to open a database connection on database db, using user name user, password password, host host, port port and connection options options. | |
virtual bool | subscribeToNotification (const QString &name) |
This function is called to subscribe to event notifications from the database. | |
virtual bool | unsubscribeFromNotification (const QString &name) |
This function is called to unsubscribe from event notifications from the database. | |
virtual QStringList | subscribedToNotifications () const |
Returns a list of the names of the event notifications that are currently subscribed to. | |
virtual bool | isIdentifierEscaped (const QString &identifier, IdentifierType type) const |
Returns whether identifier is escaped according to the database rules. | |
virtual QString | stripDelimiters (const QString &identifier, IdentifierType type) const |
Returns the identifier with the leading and trailing delimiters removed, identifier can either be a table name or field name, dependent on type. | |
void | setNumericalPrecisionPolicy (QSql::NumericalPrecisionPolicy precisionPolicy) |
QSql::NumericalPrecisionPolicy | numericalPrecisionPolicy () const |
DbmsType | dbmsType () const |
virtual int | maximumIdentifierLength (IdentifierType type) const |
![]() | |
Q_INVOKABLE | QObject (QObject *parent=nullptr) |
Constructs an object with parent object parent. | |
virtual | ~QObject () |
Destroys the object, deleting all its child objects. | |
virtual bool | event (QEvent *event) |
This virtual function receives events to an object and should return true if the event e was recognized and processed. | |
virtual bool | eventFilter (QObject *watched, QEvent *event) |
Filters events if this object has been installed as an event filter for the watched object. | |
QString | objectName () const |
Q_WEAK_OVERLOAD void | setObjectName (const QString &name) |
Sets the object's name to name. | |
void | setObjectName (QAnyStringView name) |
This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts. | |
QBindable< QString > | bindableObjectName () |
bool | isWidgetType () const |
Returns true if the object is a widget; otherwise returns false . | |
bool | isWindowType () const |
Returns true if the object is a window; otherwise returns false . | |
bool | isQuickItemType () const |
Returns true if the object is a QQuickItem; otherwise returns false . | |
bool | signalsBlocked () const noexcept |
Returns true if signals are blocked; otherwise returns false . | |
bool | blockSignals (bool b) noexcept |
If block is true, signals emitted by this object are blocked (i.e., emitting a signal will not invoke anything connected to it). | |
QThread * | thread () const |
Returns the thread in which the object lives. | |
void | moveToThread (QThread *thread) |
Changes the thread affinity for this object and its children. | |
int | startTimer (int interval, Qt::TimerType timerType=Qt::CoarseTimer) |
This is an overloaded function that will start a timer of type timerType and a timeout of interval milliseconds. | |
int | startTimer (std::chrono::milliseconds time, Qt::TimerType timerType=Qt::CoarseTimer) |
void | killTimer (int id) |
Kills the timer with timer identifier, id. | |
template<typename T > | |
T | findChild (const QString &aName=QString(), Qt::FindChildOptions options=Qt::FindChildrenRecursively) const |
Returns the child of this object that can be cast into type T and that is called name, or \nullptr if there is no such object. | |
template<typename T > | |
QList< T > | findChildren (const QString &aName, Qt::FindChildOptions options=Qt::FindChildrenRecursively) const |
Returns all children of this object with the given name that can be cast to type T, or an empty list if there are no such objects. | |
template<typename T > | |
QList< T > | findChildren (Qt::FindChildOptions options=Qt::FindChildrenRecursively) const |
This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts. | |
const QObjectList & | children () const |
Returns a list of child objects. | |
void | setParent (QObject *parent) |
Makes the object a child of parent. | |
void | installEventFilter (QObject *filterObj) |
Installs an event filter filterObj on this object. | |
void | removeEventFilter (QObject *obj) |
Removes an event filter object obj from this object. | |
QMetaObject::Connection | connect (const QObject *sender, const char *signal, const char *member, Qt::ConnectionType type=Qt::AutoConnection) const |
bool | disconnect (const char *signal=nullptr, const QObject *receiver=nullptr, const char *member=nullptr) const |
bool | disconnect (const QObject *receiver, const char *member=nullptr) const |
void | dumpObjectTree () const |
Dumps a tree of children to the debug output. | |
void | dumpObjectInfo () const |
Dumps information about signal connections, etc. | |
bool | setProperty (const char *name, const QVariant &value) |
Sets the value of the object's name property to value. | |
bool | setProperty (const char *name, QVariant &&value) |
QVariant | property (const char *name) const |
Returns the value of the object's name property. | |
QList< QByteArray > | dynamicPropertyNames () const |
QBindingStorage * | bindingStorage () |
const QBindingStorage * | bindingStorage () const |
QObject * | parent () const |
Returns a pointer to the parent object. | |
bool | inherits (const char *classname) const |
Returns true if this object is an instance of a class that inherits className or a QObject subclass that inherits className; otherwise returns false . | |
Protected Member Functions | |
bool | beginTransaction () override |
This function is called to begin a transaction. | |
bool | commitTransaction () override |
This function is called to commit a transaction. | |
bool | rollbackTransaction () override |
This function is called to rollback a transaction. | |
![]() | |
QSqlDriver (QSqlDriverPrivate &dd, QObject *parent=nullptr) | |
virtual void | setOpen (bool o) |
This function sets the open state of the database to open. | |
virtual void | setOpenError (bool e) |
This function sets the open error state of the database to error. | |
virtual void | setLastError (const QSqlError &e) |
This function is used to set the value of the last error, error, that occurred on the database. | |
![]() | |
QObject * | sender () const |
Returns a pointer to the object that sent the signal, if called in a slot activated by a signal; otherwise it returns \nullptr. | |
int | senderSignalIndex () const |
int | receivers (const char *signal) const |
Returns the number of receivers connected to the signal. | |
bool | isSignalConnected (const QMetaMethod &signal) const |
virtual void | timerEvent (QTimerEvent *event) |
This event handler can be reimplemented in a subclass to receive timer events for the object. | |
virtual void | childEvent (QChildEvent *event) |
This event handler can be reimplemented in a subclass to receive child events. | |
virtual void | customEvent (QEvent *event) |
This event handler can be reimplemented in a subclass to receive custom events. | |
virtual void | connectNotify (const QMetaMethod &signal) |
virtual void | disconnectNotify (const QMetaMethod &signal) |
QObject (QObjectPrivate &dd, QObject *parent=nullptr) | |
Friends | |
class | QPSQLResultPrivate |
Additional Inherited Members | |
![]() | |
virtual bool | cancelQuery () |
![]() | |
void | deleteLater () |
\threadsafe | |
![]() | |
void | notification (const QString &name, QSqlDriver::NotificationSource source, const QVariant &payload) |
![]() | |
void | destroyed (QObject *=nullptr) |
This signal is emitted immediately before the object obj is destroyed, after any instances of QPointer have been notified, and cannot be blocked. | |
void | objectNameChanged (const QString &objectName, QPrivateSignal) |
This signal is emitted after the object's name has been changed. | |
![]() | |
static QMetaObject::Connection | connect (const QObject *sender, const char *signal, const QObject *receiver, const char *member, Qt::ConnectionType=Qt::AutoConnection) |
\threadsafe | |
static QMetaObject::Connection | connect (const QObject *sender, const QMetaMethod &signal, const QObject *receiver, const QMetaMethod &method, Qt::ConnectionType type=Qt::AutoConnection) |
template<typename Func1 , typename Func2 > | |
static QMetaObject::Connection | connect (const typename QtPrivate::FunctionPointer< Func1 >::Object *sender, Func1 signal, const typename QtPrivate::ContextTypeForFunctor< Func2 >::ContextType *context, Func2 &&slot, Qt::ConnectionType type=Qt::AutoConnection) |
template<typename Func1 , typename Func2 > | |
static QMetaObject::Connection | connect (const typename QtPrivate::FunctionPointer< Func1 >::Object *sender, Func1 signal, Func2 &&slot) |
static bool | disconnect (const QObject *sender, const char *signal, const QObject *receiver, const char *member) |
\threadsafe | |
static bool | disconnect (const QObject *sender, const QMetaMethod &signal, const QObject *receiver, const QMetaMethod &member) |
static bool | disconnect (const QMetaObject::Connection &) |
Disconnect a connection. | |
template<typename Func1 , typename Func2 > | |
static bool | disconnect (const typename QtPrivate::FunctionPointer< Func1 >::Object *sender, Func1 signal, const typename QtPrivate::FunctionPointer< Func2 >::Object *receiver, Func2 slot) |
template<typename Func1 > | |
static bool | disconnect (const typename QtPrivate::FunctionPointer< Func1 >::Object *sender, Func1 signal, const QObject *receiver, void **zero) |
![]() | |
QScopedPointer< QObjectData > | d_ptr |
![]() | |
QString | objectName |
the name of this object | |
![]() | |
template< class T > T | qobject_cast (const QObject *object) |
Returns the given object cast to type T if the object is of type T (or of a subclass); otherwise returns \nullptr. | |
template< typename T > T | qFindChildqFindChildren (const QObject *obj, const QString &name)() |
template< typename T > QList< T > | qFindChildrenqFindChildren (const QObject *obj, const QString &name)() |
QObjectList | |
\macro Q_CLASSINFO(Name, Value) | |
Definition at line 33 of file qsql_psql_p.h.
Definition at line 39 of file qsql_psql_p.h.
Definition at line 1083 of file qsql_psql.cpp.
Definition at line 1088 of file qsql_psql.cpp.
References d, QSqlDriver::setOpen(), and QSqlDriver::setOpenError().
QPSQLDriver::~QPSQLDriver | ( | ) |
Definition at line 1101 of file qsql_psql.cpp.
References d.
|
overrideprotectedvirtual |
This function is called to begin a transaction.
If successful, return true, otherwise return false. The default implementation does nothing and returns false
.
Reimplemented from QSqlDriver.
Definition at line 1231 of file qsql_psql.cpp.
References d, isOpen(), qMakeError(), qWarning, QSqlDriver::setLastError(), tr, and QSqlError::TransactionError.
|
overridevirtual |
Derived classes must reimplement this pure virtual function in order to close the database connection.
Return true on success, false on failure.
Implements QSqlDriver.
Definition at line 1208 of file qsql_psql.cpp.
References d, disconnect(), QSqlDriver::setOpen(), QSqlDriver::setOpenError(), SIGNAL, and SLOT.
Referenced by open().
|
overrideprotectedvirtual |
This function is called to commit a transaction.
If successful, return true, otherwise return false. The default implementation does nothing and returns false
.
Reimplemented from QSqlDriver.
Definition at line 1249 of file qsql_psql.cpp.
References d, isOpen(), qMakeError(), qstrcmp(), qWarning, QSqlDriver::setLastError(), tr, QSqlError::TransactionError, and Version8.
|
overridevirtual |
Creates an empty SQL result on the database.
Derived classes must reimplement this function and return a QSqlResult object appropriate for their database to the caller.
Implements QSqlDriver.
Definition at line 1226 of file qsql_psql.cpp.
Referenced by primaryIndex(), record(), and tables().
|
overridevirtual |
Returns the identifier escaped according to the database rules.
identifier can either be a table name or field name, dependent on type.
The default implementation does nothing.
Reimplemented from QSqlDriver.
Definition at line 1516 of file qsql_psql.cpp.
References QString::endsWith(), QString::isEmpty(), QString::replace(), and QString::startsWith().
Referenced by subscribeToNotification(), and unsubscribeFromNotification().
|
overridevirtual |
Returns a string representation of the field value for the database.
This is used, for example, when constructing INSERT and UPDATE statements.
The default implementation returns the value formatted as a string according to the following rules:
\list
\endlist
Reimplemented from QSqlDriver.
Definition at line 1435 of file qsql_psql.cpp.
References assignSpecialPsqlFloatValue(), ba, QLocale::c(), QByteArray::constData(), d, QSqlDriver::formatValue(), QMetaType::id(), QSqlField::isNull(), QTime::isValid(), QDateTime::isValid(), QSqlField::metaType(), qPQfreemem(), QStringLiteral, QByteArray::size(), QVariant::toBool(), QVariant::toByteArray(), QVariant::toDateTime(), QVariant::toDouble(), QVariant::toFloat(), QVariant::toString(), QLocale::toString(), QVariant::toTime(), QDateTime::toUTC(), and QSqlField::value().
|
overridevirtual |
Returns the low-level database handle wrapped in a QVariant or an invalid variant if there is no handle.
The handle returned here is database-dependent, you should query the type name of the variant before accessing it.
This example retrieves the handle for a connection to sqlite:
This snippet returns the handle for PostgreSQL or MySQL:
Reimplemented from QSqlDriver.
Definition at line 1108 of file qsql_psql.cpp.
References d, and QVariant::fromValue().
|
overridevirtual |
Returns true
if the driver supports feature feature; otherwise returns false
.
Note that some databases need to be open() before this can be determined.
Implements QSqlDriver.
Definition at line 1114 of file qsql_psql.cpp.
References QSqlDriver::BatchOperations, QSqlDriver::BLOB, QSqlDriver::CancelQuery, d, QSqlDriver::EventNotifications, QSqlDriver::FinishQuery, QSqlDriver::LastInsertId, QSqlDriver::LowPrecisionNumbers, QSqlDriver::MultipleResultSets, QSqlDriver::NamedPlaceholders, QSqlDriver::PositionalPlaceholders, QSqlDriver::PreparedQueries, QSqlDriver::QuerySize, QSqlDriver::SimpleLocking, QSqlDriver::Transactions, QSqlDriver::Unicode, and Version8_2.
|
overridevirtual |
Returns true
if the database connection is open; otherwise returns false.
Reimplemented from QSqlDriver.
Definition at line 1527 of file qsql_psql.cpp.
References d.
Referenced by beginTransaction(), commitTransaction(), primaryIndex(), record(), rollbackTransaction(), subscribeToNotification(), tables(), and unsubscribeFromNotification().
|
overridevirtual |
Derived classes must reimplement this pure virtual function to open a database connection on database db, using user name user, password password, host host, port port and connection options options.
The function must return true on success and false on failure.
Implements QSqlDriver.
Definition at line 1154 of file qsql_psql.cpp.
References QString::append(), Qt::CaseInsensitive, close(), QSqlError::ConnectionError, d, db, QString::isEmpty(), QString::number(), opt, qMakeError(), qQuote(), QSqlDriver::setLastError(), QSqlDriver::setOpen(), QSqlDriver::setOpenError(), toLocal8Bit(), and tr.
Returns the primary index for table tableName.
Returns an empty QSqlIndex if the table doesn't have a primary index. The default implementation returns an empty index.
Reimplemented from QSqlDriver.
Definition at line 1328 of file qsql_psql.cpp.
References QSqlIndex::append(), QString::arg(), arg, createResult(), i, QString::isEmpty(), isOpen(), qDecodePSQLType(), qSplitTableName(), QStringLiteral, QSqlIndex::setName(), QSqlDriver::stripDelimiters(), and QSqlDriver::TableName.
QPSQLDriver::Protocol QPSQLDriver::protocol | ( | ) | const |
Definition at line 1533 of file qsql_psql.cpp.
References d.
Referenced by record().
|
overridevirtual |
Returns a QSqlRecord populated with the names of the fields in table tableName.
If no such table exists, an empty record is returned. The default implementation returns an empty record.
Reimplemented from QSqlDriver.
Definition at line 1365 of file qsql_psql.cpp.
References QString::at(), createResult(), info, QString::isEmpty(), isOpen(), QString::lastIndexOf(), QString::mid(), protocol(), qDecodePSQLType(), qSplitTableName(), QStringLiteral, QSqlDriver::stripDelimiters(), QSqlDriver::TableName, and Version8.
|
overrideprotectedvirtual |
This function is called to rollback a transaction.
If successful, return true, otherwise return false. The default implementation does nothing and returns false
.
Reimplemented from QSqlDriver.
Definition at line 1278 of file qsql_psql.cpp.
References d, isOpen(), qMakeError(), qWarning, QSqlDriver::setLastError(), tr, and QSqlError::TransactionError.
|
overridevirtual |
Returns a list of the names of the event notifications that are currently subscribed to.
Reimplement this function if you want to provide event notification support in your own QSqlDriver subclass,
Reimplemented from QSqlDriver.
Definition at line 1613 of file qsql_psql.cpp.
References d.
|
overridevirtual |
This function is called to subscribe to event notifications from the database.
name identifies the event notification.
If successful, return true, otherwise return false.
The database must be open when this function is called. When the database is closed by calling close() all subscribed event notifications are automatically unsubscribed. Note that calling open() on an already open database may implicitly cause close() to be called, which will cause the driver to unsubscribe from all event notifications.
When an event notification identified by name is posted by the database the notification() signal is emitted.
Reimplement this function if you want to provide event notification support in your own QSqlDriver subclass,
Reimplemented from QSqlDriver.
Definition at line 1539 of file qsql_psql.cpp.
References QObject::connect(), d, escapeIdentifier(), isOpen(), qMakeError(), QStringLiteral, qWarning, QSocketNotifier::Read, QSqlDriver::setLastError(), SIGNAL, SLOT, socket, QSqlError::StatementError, QSqlDriver::TableName, and tr.
|
overridevirtual |
Returns a list of the names of the tables in the database.
The default implementation returns an empty list.
The tableType argument describes what types of tables should be returned. Due to binary compatibility, the string contains the value of the enum QSql::TableTypes as text. An empty string should be treated as QSql::Tables for backward compatibility.
Reimplemented from QSqlDriver.
Definition at line 1296 of file qsql_psql.cpp.
References createResult(), d, QPSQLDriverPrivate::exec(), isOpen(), QStringLiteral, QSql::SystemTables, QSql::Tables, and QSql::Views.
|
overridevirtual |
This function is called to unsubscribe from event notifications from the database.
name identifies the event notification.
If successful, return true, otherwise return false.
The database must be open when this function is called. All subscribed event notifications are automatically unsubscribed from when the close() function is called.
After calling this function the notification() signal will no longer be emitted when an event notification identified by name is posted by the database.
Reimplement this function if you want to provide event notification support in your own QSqlDriver subclass,
Reimplemented from QSqlDriver.
Definition at line 1579 of file qsql_psql.cpp.
References d, disconnect(), escapeIdentifier(), isOpen(), qMakeError(), QStringLiteral, qUtf16Printable, qWarning, QSqlDriver::setLastError(), SIGNAL, SLOT, QSqlError::StatementError, QSqlDriver::TableName, and tr.
|
friend |
Definition at line 35 of file qsql_psql_p.h.