KDb
KDb.cpp
117 ConnectionTestThread::ConnectionTestThread(ConnectionTestDialog* dlg, const KDbConnectionData& connData)
308 //! Converts textual representation @a data of a hex number (@a length digits) to a byte array @a array
451 for (KDbField::Type t = KDbField::InvalidType; t <= KDbField::LastType; t = KDbField::Type(int(t) + 1)) {
502 return (typeGroup <= KDbField::LastTypeGroup) ? KDb_typeCache->def_tlist.value(typeGroup) : KDbField::InvalidType;
579 tristate KDb::idForObjectName(KDbConnection* conn, int *id, const QString& objName, int objType)
981 bool KDb::setFieldProperty(KDbField *field, const QByteArray& propertyName, const QVariant& value)
1400 //! @internal Decodes hex of length @a digits for handleXhh(), handleUxxxx() and handleUcodePoint()
1404 //! If @a digits is smaller than CODE_POINT_DIGITS the function succeeds only if exactly @a digits
1409 static int handleHex(QString *result, int *from, int stringLen, int *errorPosition, int digits)
1479 static bool handleUcodePoint(QString *result, int *from, int to, int stringLen, int *errorPosition)
1492 static bool handleEscape(QString *result, int *from, int *to, int stringLen, int *errorPosition)
1716 if (length < 3 || data[0] != 'X' || data[1] != '\'' || data[length-1] != '\'') { // must be at least X''
2143 if (c == 0 || !(c == '_' || (c >= 'a' && c <= 'z') || (c >= 'A' && c <= 'Z') || (i > 0 && c >= '0' && c <= '9'))) {
2254 static QByteArray dateTimeToSqlInternal(const QVariant& v, char separator, bool allowInvalidKDbDateTime)
void start(const QString &program, const QStringList &arguments, QIODevice::OpenMode mode)
Q_OBJECTQ_OBJECT
void append(const T &value)
bool isNull() const const
QMap::const_iterator constBegin() const const
T & first()
KDB_EXPORT QVariant loadPropertyValueFromDom(const QDomNode &node, bool *ok)
Definition: KDb.cpp:1123
tristate containsTable(const QString &tableName)
Definition: KDbConnection.cpp:1039
KDB_EXPORT QString escapeIdentifier(const QString &string)
Definition: KDb.cpp:1334
bool isNull() const const
void squeeze()
bool isNull() const const
void truncate(int position)
short toShort(bool *ok, int base) const const
int toInt(bool *ok, int base) const const
QString text() const const
tristate querySingleNumber(const KDbEscapedString &sql, int *number, int column=0, QueryRecordOptions options=QueryRecordOption::Default)
Definition: KDbConnection.cpp:2477
virtual KDbEscapedString recentSqlString() const
Definition: KDbResult.shared.h:117
KDB_EXPORT void getProperties(const KDbLookupFieldSchema *lookup, QMap< QByteArray, QVariant > *values)
Definition: KDb.cpp:758
QDomElement toElement() const const
Definition: KDbVersionInfo.shared.h:43
Provides information about lookup field's setup.
Definition: KDbLookupFieldSchema.h:123
KDB_EXPORT QList< int > deserializeIntList(const QString &data, bool *ok)
Definition: KDb.cpp:1842
QString number(int n, int base)
WriteOnly
KDB_EXPORT bool splitToTableAndFieldParts(const QString &string, QString *tableName, QString *fieldName, SplitToTableAndFieldPartsOptions option=FailIfNoTableOrFieldName)
Definition: KDb.cpp:603
QString fromUtf8(const char *str, int size)
KDB_EXPORT QVariant cstringToVariant(const char *data, KDbField::Type type, bool *ok, int length=-1, KDb::Signedness signedness=KDb::Signed)
Definition: KDb.cpp:1984
virtual void reject()
QChar toLower() const const
int size() const const
CaseInsensitive
bool waitForFinished(int msecs)
Q_SLOTSQ_SLOTS
KDB_EXPORT bool deleteAllRecords(KDbConnection *conn, const QString &tableName)
Deletes all records from table tableName.
Definition: KDb.cpp:384
bool remove()
KDB_EXPORT QStringList fieldTypeNamesForGroup(KDbField::TypeGroup typeGroup)
Definition: KDb.cpp:490
Type type(const QSqlDatabase &db)
KDB_EXPORT QDomElement saveNumberElementToDom(QDomDocument *doc, QDomElement *parentEl, const QString &elementName, int value)
Definition: KDb.cpp:1169
QDateTime currentDateTime()
QStringRef midRef(int position, int n) const const
Definition: KDbError.h:114
int count(const T &value) const const
T value() const const
QByteArray encodeName(const QString &fileName)
virtual bool waitForBytesWritten(int msecs) override
KDB_EXPORT KDbEscapedString dateTimeToIsoString(const QVariant &v)
Converts date/time value to its string representation in ISO 8601 DateTime format - with "T" delimite...
Definition: KDb.cpp:2297
void clear()
bool testFlag(Enum flag) const const
QString arg(Args &&... args) const const
QDomText createTextNode(const QString &value)
KDB_EXPORT bool importSqliteFile(const QString &inputFileName, const QString &outputFileName)
Definition: KDb.cpp:2083
QString & prepend(QChar ch)
qlonglong toLongLong(bool *ok, int base) const const
KDB_EXPORT KDbEscapedString dateToSql(const QVariant &v)
Converts date value to its string representation required by KDBSQL commands.
Definition: KDb.cpp:2223
KDB_EXPORT KDbField::TypeGroup intToFieldTypeGroup(int typeGroup)
Definition: KDb.cpp:678
virtual QString escapeIdentifier(const QString &id) const
Identifier escaping function in the associated KDbDriver.
Definition: KDbConnection.cpp:3044
QByteArray toLatin1() const const
QList::const_iterator constBegin() const const
KDB_EXPORT QDomElement saveBooleanElementToDom(QDomDocument *doc, QDomElement *parentEl, const QString &elementName, bool value)
Definition: KDb.cpp:1183
void reserve(int size)
QByteArray toByteArray() const const
ushort toUShort(bool *ok, int base) const const
bool setProperties(const QMap< QByteArray, QVariant > &values)
Definition: KDbLookupFieldSchema.cpp:616
void clear()
KIOFILEWIDGETS_EXPORT QStringList list(const QString &fileClass)
QDomElement createElement(const QString &tagName)
QDate toDate() const const
bool exists() const const
KDB_DEPRECATED_EXPORT KDbEscapedString dateTimeToSql(const QDateTime &v)
Converts date/time value to its string representation in ISO 8601 DateTime format - with "T" delimite...
Definition: KDb.cpp:2282
QString simplified() const const
KDB_EXPORT QString defaultFileBasedDriverMimeType()
Definition: KDb.cpp:1962
KDB_EXPORT QVariant emptyValueForFieldType(KDbField::Type type)
Used in KDb::emptyValueForFieldType()
Definition: KDb.cpp:1222
Definition: KDbResult.shared.h:34
char at(int i) const const
Q_GLOBAL_STATIC(Internal::StaticControl, s_instance) class ControlPrivate
KDB_EXPORT bool setFieldProperty(KDbField *field, const QByteArray &propertyName, const QVariant &value)
Definition: KDb.cpp:981
KDB_EXPORT KDbField::Type defaultFieldTypeForGroup(KDbField::TypeGroup typeGroup)
Definition: KDb.cpp:500
virtual KDbEscapedString escapeString(const QString &str) const =0
KDB_EXPORT bool isLookupFieldSchemaProperty(const QByteArray &propertyName)
for isLookupFieldSchemaProperty()
Definition: KDb.cpp:976
QTime currentTime()
KDB_EXPORT QString unescapeString(const QString &string, char quote, int *errorPosition=nullptr)
Unescapes characters in string string for the KDBSQL dialect.
KDB_EXPORT QVariant stringToVariant(const QString &s, QVariant::Type type, bool *ok)
Definition: KDb.cpp:1859
KDB_EXPORT bool isKDbSqlKeyword(const QByteArray &word)
Record source information that can be specified for the lookup field schema.
Definition: KDbLookupFieldSchema.h:49
KDB_EXPORT void getLimitsForFieldType(KDbField::Type type, qlonglong *minValue, qlonglong *maxValue, KDb::Signedness signedness=KDb::Signed)
Provides limits for values of type type.
Definition: KDb.cpp:1912
void setMaxLengthStrategy(MaxLengthStrategy strategy)
Definition: KDbField.cpp:660
QString absoluteFilePath() const const
bool executeSql(const KDbEscapedString &sql)
Executes a new native (raw, backend-specific) SQL query.
Definition: KDbConnection.cpp:1286
QVariant::Type type() const const
KDB_EXPORT QString simplifiedFieldTypeName(KDbField::Type type)
Definition: KDb.cpp:1951
bool setProperty(const QByteArray &propertyName, const QVariant &value)
Definition: KDbLookupFieldSchema.cpp:567
virtual QString serverResultName() const
Definition: KDbResult.cpp:209
virtual void run()
DisplayWidget displayWidget() const
Definition: KDbLookupFieldSchema.cpp:738
KDB_EXPORT QString identifierExpectedMessage(const QString &valueName, const QVariant &v)
Definition: KDb.cpp:2191
QMap::const_iterator constEnd() const const
QVariant::Type variantType() const
Converts field's type to QVariant equivalent as accurate as possible.
Definition: KDbField.h:368
KDbLookupFieldSchemaRecordSource recordSource() const
Definition: KDbLookupFieldSchema.cpp:282
KDB_EXPORT bool deleteRecords(KDbConnection *conn, const QString &tableName, const QString &keyname, KDbField::Type keytype, const QVariant &keyval)
Deletes records using one generic criteria.
Definition: KDb.cpp:342
KDB_EXPORT bool supportsVisibleDecimalPlacesProperty(KDbField::Type type)
Definition: KDb.cpp:623
bool isEmpty() const const
KDB_EXPORT bool isDefaultValueAllowed(const KDbField &field)
Definition: KDb.cpp:1907
int length() const const
bool waitForStarted(int msecs)
bool columnHeadersVisible() const
Definition: KDbLookupFieldSchema.cpp:713
KDB_EXPORT QList< int > stringListToIntList(const QStringList &list, bool *ok=nullptr)
Definition: KDb.cpp:1766
KDB_EXPORT int loadIntPropertyValueFromDom(const QDomNode &node, bool *ok)
Definition: KDb.cpp:1097
KDB_EXPORT QStringList fieldTypeStringsForGroup(KDbField::TypeGroup typeGroup)
Definition: KDb.cpp:495
KDB_EXPORT QString escapeIdentifierAndAddQuotes(const QString &string)
Definition: KDb.cpp:1346
virtual void accept()
int toInt(bool *ok) const const
int toInt(bool *ok, int base) const const
KDB_EXPORT bool setFieldProperties(KDbField *field, const QMap< QByteArray, QVariant > &values)
Definition: KDb.cpp:833
KDB_EXPORT KDbField::Type maximumForIntegerFieldTypes(KDbField::Type t1, KDbField::Type t2)
Definition: KDb.cpp:1936
QueuedConnection
QList< int > columnWidths() const
Definition: KDbLookupFieldSchema.cpp:703
bool isEmpty() const const
KDB_EXPORT QByteArray zeroXHexToByteArray(const char *data, int length=-1, bool *ok=nullptr)
Definition: KDb.cpp:1740
QDate currentDate()
KDB_EXPORT void getFieldProperties(const KDbField &field, QMap< QByteArray, QVariant > *values)
Definition: KDb.cpp:787
virtual int exec()
Accepted
int indexOf(QChar ch, int from, Qt::CaseSensitivity cs) const const
3-state logical type with three values: true, false and cancelled and convenient operators.
Definition: KDbTristate.h:100
KDB_EXPORT QStringList deserializeList(const QString &data)
Definition: KDb.cpp:1813
bool convert(int targetTypeId)
QString typeName() const
Definition: KDbLookupFieldSchema.cpp:155
virtual KDbEscapedString escapeString(const QString &str) const
Definition: KDbConnection.cpp:3535
T * take()
QStringList values() const
Definition: KDbLookupFieldSchema.cpp:166
uint toUInt(bool *ok, int base) const const
QDir absoluteDir() const const
QString path() const const
QString nodeName() const const
double toDouble(bool *ok) const const
KDB_EXPORT KDbEscapedString valueToSql(KDbField::Type ftype, const QVariant &v)
Definition: KDb.cpp:2201
bool toBool() const const
KDB_EXPORT bool isEmptyValue(KDbField::Type type, const QVariant &value)
Definition: KDb.cpp:429
void error(QWidget *parent, const QString &text, const QString &title, const KGuiItem &buttonOk, Options options=Notify)
QString & replace(int position, int n, QChar after)
bool canConvert(int targetTypeId) const const
Q_SIGNALSQ_SIGNALS
bool startsWith(const QString &s, Qt::CaseSensitivity cs) const const
LocaleWrapper locale()
virtual KDbEscapedString valueToSql(KDbField::Type ftype, const QVariant &v) const
Definition: KDbDriver.cpp:246
KDB_EXPORT QString escapeBLOB(const QByteArray &array, BLOBEscapingType type)
typedef ConstIterator
bool setLookupFieldSchema(const QString &fieldName, KDbLookupFieldSchema *lookupFieldSchema)
Definition: KDbTableSchema.cpp:373
Detailed definition of driver's default behavior.
Definition: KDbDriverBehavior.h:32
QDateTime toDateTime() const const
KDB_EXPORT quint64 lastInsertedAutoIncValue(QSharedPointer< KDbSqlResult > result, const QString &autoIncrementFieldName, const QString &tableName, quint64 *recordId=nullptr)
Returns value of last inserted record for an autoincrement field.
Definition: KDb.cpp:392
KDB_EXPORT KDbEscapedString dateToIsoString(const QVariant &v)
Converts date value to its string representation in ISO 8601 DateTime format.
Definition: KDb.cpp:2287
bool isEmpty() const const
Structure for storing single record with type information.
Definition: KDbRecordData.h:36
KDB_EXPORT QByteArray pgsqlByteaToByteArray(const char *data, int length=-1)
Definition: KDb.cpp:1661
KDB_EXPORT QString numberToString(double value, int decimalPlaces)
Definition: KDb.cpp:654
void resize(int size)
QList::const_iterator constEnd() const const
QList< int > visibleColumns() const
Definition: KDbLookupFieldSchema.cpp:685
QString arg(qlonglong a, int fieldWidth, int base, QChar fillChar) const const
QDomNode appendChild(const QDomNode &newChild)
tristate querySingleRecord(const KDbEscapedString &sql, KDbRecordData *data, QueryRecordOptions options=QueryRecordOption::Default)
Definition: KDbConnection.cpp:2380
KDB_EXPORT KDbEscapedString sqlWhere(KDbDriver *drv, KDbField::Type t, const QString &fieldName, const QVariant &value)
Definition: KDb.cpp:440
QString left(int n) const const
QString fromLatin1(const char *str, int size)
void setCustomProperty(const QByteArray &propertyName, const QVariant &value)
Sets value value for custom property propertyName.
Definition: KDbField.cpp:1042
QString toUserVisibleString(UserVisibleStringOptions options=UserVisibleStringOption::AddUser) const
Definition: KDbConnectionData.cpp:33
QTime toTime() const const
KDB_EXPORT tristate showConnectionTestDialog(QWidget *parent, const KDbConnectionData &data, KDbMessageHandler *msgHandler)
Shows connection test dialog.
Definition: KDb.cpp:592
Database specific connection data, e.g. host, port.
Definition: KDbConnectionData.shared.h:35
const QChar at(int position) const const
KDB_EXPORT QString temporaryTableName(KDbConnection *conn, const QString &baseName)
Definition: KDb.cpp:2055
KDB_EXPORT QString loadStringPropertyValueFromDom(const QDomNode &node, bool *ok)
Definition: KDb.cpp:1110
int maxVisibleRecords() const
Definition: KDbLookupFieldSchema.cpp:723
KDB_EXPORT bool isExtendedTableFieldProperty(const QByteArray &propertyName)
for isExtendedTableProperty()
Definition: KDb.cpp:954
int size() const const
KDB_EXPORT void getHTMLErrorMesage(const KDbResultable &resultable, QString *msg, QString *details)
Sets HTML-formatted error message with extra details obtained from result object.
Definition: KDb.cpp:505
KDB_EXPORT tristate idForObjectName(KDbConnection *conn, int *id, const QString &objName, int objType)
Finds an identifier for object objName of type objType.
Definition: KDb.cpp:579
int compare(const QString &other, Qt::CaseSensitivity cs) const const
A driver manager for finding and loading driver plugins.
Definition: KDbDriverManager.h:37
QStringList toStringList() const const
Definition: KDbMessageHandler.h:134
KDB_EXPORT KDbEscapedString timeToSql(const QVariant &v)
Converts time value to its string representation required by KDBSQL commands.
Definition: KDb.cpp:2249
int length() const const
Provides database connection, allowing queries and data modification.
Definition: KDbConnection.h:51
bool ROW_ID_FIELD_RETURNS_LAST_AUTOINCREMENTED_VALUE
Definition: KDbDriverBehavior.h:108
void reset(T *other)
char toLatin1() const const
ByteArray
QString mid(int position, int n) const const
Q_DISABLE_COPY(Class)
KDB_EXPORT QByteArray xHexToByteArray(const char *data, int length=-1, bool *ok=nullptr)
Definition: KDb.cpp:1711
int capacity() const const
QVector< V > values(const QMultiHash< K, V > &c)
QString message
T value(int i) const const
QString & append(QChar ch)
void closeWriteChannel()
ISODate
KDB_EXPORT QString numberToLocaleString(double value, int decimalPlaces)
Returns number converted to string using default locale.
Definition: KDb.cpp:659
bool isReadable() const const
ushort unicode() const const
qint64 write(const char *data, qint64 maxSize)
KDB_EXPORT KDbEscapedString timeToIsoString(const QVariant &v)
Converts time value to its string representation in ISO 8601 Time format.
Definition: KDb.cpp:2292
QString toString() const const
QChar fromLatin1(char c)
KDB_EXPORT QString stringToIdentifier(const QString &s)
Definition: KDb.cpp:2158
KDbLookupFieldSchema * lookupFieldSchema(const KDbField &field)
Definition: KDbTableSchema.cpp:388
@ DefaultMaxLength
Default maximum text length defined globally by the application.
Definition: KDbField.h:430
This file is part of the KDE documentation.
Documentation copyright © 1996-2023 The KDE developers.
Generated on Mon May 8 2023 04:07:51 by doxygen 1.8.17 written by Dimitri van Heesch, © 1997-2006
Documentation copyright © 1996-2023 The KDE developers.
Generated on Mon May 8 2023 04:07:51 by doxygen 1.8.17 written by Dimitri van Heesch, © 1997-2006
KDE's Doxygen guidelines are available online.