|
|
#ifndef PYTHONQTWRAPPER_QSQLQUERY_H
|
|
|
#define PYTHONQTWRAPPER_QSQLQUERY_H
|
|
|
|
|
|
#include <qsqlquery.h>
|
|
|
#include <QObject>
|
|
|
|
|
|
#include <QSize>
|
|
|
#include <QSqlError>
|
|
|
#include <QSqlRecord>
|
|
|
#include <QStringList>
|
|
|
#include <QVariant>
|
|
|
#include <qsqldatabase.h>
|
|
|
#include <qsqldriver.h>
|
|
|
#include <qsqlerror.h>
|
|
|
#include <qsqlquery.h>
|
|
|
#include <qsqlrecord.h>
|
|
|
#include <qsqlresult.h>
|
|
|
|
|
|
class PythonQtWrapper_QSqlQuery : public QObject
|
|
|
{ Q_OBJECT
|
|
|
public:
|
|
|
Q_ENUMS(BatchExecutionMode )
|
|
|
enum BatchExecutionMode{
|
|
|
ValuesAsRows = QSqlQuery::ValuesAsRows, ValuesAsColumns = QSqlQuery::ValuesAsColumns};
|
|
|
public slots:
|
|
|
QSqlQuery* new_QSqlQuery(QSqlDatabase db);
|
|
|
QSqlQuery* new_QSqlQuery(QSqlResult* r);
|
|
|
QSqlQuery* new_QSqlQuery(const QSqlQuery& other);
|
|
|
QSqlQuery* new_QSqlQuery(const QString& query = QString(), QSqlDatabase db = QSqlDatabase());
|
|
|
void delete_QSqlQuery(QSqlQuery* obj) { delete obj; }
|
|
|
void addBindValue(QSqlQuery* theWrappedObject, const QVariant& val, QSql::ParamType type = QSql::In);
|
|
|
int at(QSqlQuery* theWrappedObject) const;
|
|
|
void bindValue(QSqlQuery* theWrappedObject, const QString& placeholder, const QVariant& val, QSql::ParamType type = QSql::In);
|
|
|
void bindValue(QSqlQuery* theWrappedObject, int pos, const QVariant& val, QSql::ParamType type = QSql::In);
|
|
|
QVariant boundValue(QSqlQuery* theWrappedObject, const QString& placeholder) const;
|
|
|
QVariant boundValue(QSqlQuery* theWrappedObject, int pos) const;
|
|
|
QMap<QString , QVariant > boundValues(QSqlQuery* theWrappedObject) const;
|
|
|
void clear(QSqlQuery* theWrappedObject);
|
|
|
const QSqlDriver* driver(QSqlQuery* theWrappedObject) const;
|
|
|
bool exec(QSqlQuery* theWrappedObject);
|
|
|
bool exec(QSqlQuery* theWrappedObject, const QString& query);
|
|
|
bool execBatch(QSqlQuery* theWrappedObject, QSqlQuery::BatchExecutionMode mode = QSqlQuery::ValuesAsRows);
|
|
|
QString executedQuery(QSqlQuery* theWrappedObject) const;
|
|
|
void finish(QSqlQuery* theWrappedObject);
|
|
|
bool first(QSqlQuery* theWrappedObject);
|
|
|
bool isActive(QSqlQuery* theWrappedObject) const;
|
|
|
bool isForwardOnly(QSqlQuery* theWrappedObject) const;
|
|
|
bool isNull(QSqlQuery* theWrappedObject, int field) const;
|
|
|
bool isSelect(QSqlQuery* theWrappedObject) const;
|
|
|
bool isValid(QSqlQuery* theWrappedObject) const;
|
|
|
bool last(QSqlQuery* theWrappedObject);
|
|
|
QSqlError lastError(QSqlQuery* theWrappedObject) const;
|
|
|
QVariant lastInsertId(QSqlQuery* theWrappedObject) const;
|
|
|
QString lastQuery(QSqlQuery* theWrappedObject) const;
|
|
|
bool next(QSqlQuery* theWrappedObject);
|
|
|
bool nextResult(QSqlQuery* theWrappedObject);
|
|
|
int numRowsAffected(QSqlQuery* theWrappedObject) const;
|
|
|
QSql::NumericalPrecisionPolicy numericalPrecisionPolicy(QSqlQuery* theWrappedObject) const;
|
|
|
bool prepare(QSqlQuery* theWrappedObject, const QString& query);
|
|
|
bool previous(QSqlQuery* theWrappedObject);
|
|
|
QSqlRecord record(QSqlQuery* theWrappedObject) const;
|
|
|
const QSqlResult* result(QSqlQuery* theWrappedObject) const;
|
|
|
bool seek(QSqlQuery* theWrappedObject, int i, bool relative = false);
|
|
|
void setForwardOnly(QSqlQuery* theWrappedObject, bool forward);
|
|
|
void setNumericalPrecisionPolicy(QSqlQuery* theWrappedObject, QSql::NumericalPrecisionPolicy precisionPolicy);
|
|
|
int size(QSqlQuery* theWrappedObject) const;
|
|
|
QVariant value(QSqlQuery* theWrappedObject, int i) const;
|
|
|
};
|
|
|
|
|
|
#endif // PYTHONQTWRAPPER_QSQLQUERY_H
|
|
|
|
