7public:

10

11 TSqlQuery &prepare(const QString &query);

12 bool load(const QString &filename);

13 bool loadPreparedQuery(const QString &filename) { return load(filename); }

14 TSqlQuery &bind(const QString &placeholder, const QVariant &val);

15 TSqlQuery &bind(int pos, const QVariant &val);

16 TSqlQuery &addBind(const QVariant &val);

17 QVariant boundValue(int pos) const;

18 QVariantList boundValues() const;

19 QVariant getNextValue();

20 QString queryDirPath() const;

21 bool exec(const QString &query);

22 bool exec();

23 int numRowsAffected() const;

24 int size() const;

25 bool next();

26 QVariant value(int index) const;

27 QVariant value(const QString &name) const;

28

29 static void clearCachedQueries();

30 static QString escapeIdentifier(const QString &identifier, QSqlDriver::IdentifierType type = QSqlDriver::FieldName, int databaseId = 0);

31 static QString escapeIdentifier(const QString &identifier, QSqlDriver::IdentifierType type, const QSqlDriver *driver);

32 static QString formatValue(const QVariant &val, const QMetaType &type, int databaseId = 0);

33 static QString formatValue(const QVariant &val, const QMetaType &type, const QSqlDatabase &database);

34 static QString formatValue(const QVariant &val, const QMetaType &type, const QSqlDriver *driver);

35 static QString formatValue(const QVariant &val, const QSqlDriver *driver);

36 static QString formatValue(const QVariant &val, const QSqlDatabase &database) { return formatValue(val, database.driver()); }

37

38private:

39 QString _connectionName;

40 QVariantList _boundValues;

41};

45{

46 return (next()) ? record().value(0) : QVariant();

47}

51{

52 return QSqlQuery::numRowsAffected();

53}

57{

58 return QSqlQuery::size();

59}

63{

64 return QSqlQuery::next();

65}

69{

70 return QSqlQuery::value(index);

71}

75{

76 return QSqlQuery::value(name);

77}