-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathsqlcon.h
98 lines (82 loc) · 6.66 KB
/
sqlcon.h
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
#pragma once
#include "sqlutil4_global.h"
#include <QSqlDatabase>
#include <QPair>
#include <QVariant>
namespace SqlUtil4 {
class SQLUTIL4SHARED_EXPORT Sql
{
private:
Sql() = default;
Sql(const Sql& ) = default;
~Sql() = default;
public:
static QSqlDatabase connectMySql(const QString & host, const QString & user, const QString & pass, const QString & dbname,const QString&conName=QStringLiteral("qt_sql_default_connection"), int port = 3306);
Q_DECL_DEPRECATED static QSqlDatabase connectFirebird(const QString & host, const QString & user, const QString & pass, const QString & dbFile, int port);
static QSqlDatabase connectIbase(const QString & host, const QString & user, const QString & pass, const QString & dbFile, int port);
static QSqlDatabase connectIbase(const QString & host, const QString & user, const QString & pass, const QString & dbFile, const QString&conName, int port);
static QSqlDatabase connectPg(const QString& host, const QString& user, const QString& pass, const QString& dbname, int port=5432);
static QSqlDatabase connectPg(const QString& host, const QString& user, const QString& pass, const QString& dbname, const QString&conName, int port=5432);
static QSqlDatabase connectPg(const QString& host, const QString& user, const QString& pass, int port=5432);
static QSqlDatabase connectSqlite(const QString &dbFile);
static QSqlDatabase connectSqlite(const QString &dbFile, const QString &connectionName);
static void execute(const QSqlDatabase & sqlCon, const QString &sqlQuery, const QList<QVariant> ¶ms);
static void execute(const QSqlDatabase & sqlCon, const QString &sqlQuery, int64_t param);
static void execute(const QSqlDatabase & sqlCon, const QString &sqlQuery, int param);
static void execute(const QSqlDatabase & sqlCon, const QString &sqlQuery, double param);
static void execute(const QSqlDatabase & sqlCon, const QString &sqlQuery, bool param);
static void execute(const QSqlDatabase & sqlCon, const QString &sqlQuery, float param);
static void execute(const QSqlDatabase & sqlCon, const QString &sqlQuery, const QString ¶m);
static void execute(const QSqlDatabase & sqlCon, const QString &sqlQuery, const QVariant ¶m);
static void execute(const QSqlDatabase & sqlCon, const QString &sqlQuery);
static QSqlQuery query(const QSqlDatabase & sqlCon,const QString& sql, const QVariant&);
static QSqlQuery query(const QSqlDatabase & sqlCon,const QString& sql);
static QSqlQuery query(const QSqlDatabase & sqlCon,const QString& sql, const QList<QVariant>& params);
static QSqlRecord fetchRow(const QSqlDatabase & sqlCon, const QString& sql, const QList<QVariant>& params) ;
#if QT_VERSION < QT_VERSION_CHECK(6, 0, 0)
static QSqlRecord fetchRow(const QSqlDatabase & sqlCon, const QString& sql, const QVector<int64_t>& params) ;
#endif
static QSqlRecord fetchRow(const QSqlDatabase & sqlCon, const QString& sql, const QSet<int64_t>& params) ;
static QSqlRecord fetchRow(const QSqlDatabase & sqlCon, const QString& sql, const QList<QPair<QString,QVariant>>& params) ;
static QSqlRecord fetchRow(const QSqlDatabase & sqlCon, const QString& sql, const QVariant¶m) ;
static QSqlRecord fetchRow(const QSqlDatabase & sqlCon, const QString& sql, const QString¶m) ;
static QSqlRecord fetchRow(const QSqlDatabase & sqlCon, const QString& sql) ;
static int fetchInt(const QSqlDatabase & sqlCon,const QString& sql, const QVariant & param);
static int fetchInt(const QSqlDatabase & sqlCon,const QString& sql, const QString & param);
static int fetchInt(const QSqlDatabase & sqlCon,const QString& sql, const QList<QVariant>& params);
static int fetchInt(const QSqlDatabase & sqlCon,const QString& sql, const QList<QPair<QString,QVariant>>& params);
#if QT_VERSION < QT_VERSION_CHECK(6, 0, 0)
static int fetchInt(const QSqlDatabase & sqlCon,const QString& sql, const QVector<int64_t>& params);
#endif
static int fetchInt(const QSqlDatabase & sqlCon,const QString& sql, const QSet<int64_t>& params);
static int fetchInt(const QSqlDatabase & sqlCon,const QString &sql);
static int64_t fetchInt64(const QSqlDatabase & sqlCon,const QString &sql);
static int64_t fetchInt64(const QSqlDatabase & sqlCon,const QString &sql, const QVariantList & params);
static int64_t fetchInt64(const QSqlDatabase & sqlCon,const QString &sql, const QString & param);
static int64_t fetchInt64(const QSqlDatabase & sqlCon,const QString &sql, const QVariant & param);
static uint fetchUInt(const QSqlDatabase & sqlCon,const QString &sql);
static uint fetchUInt(const QSqlDatabase & sqlCon,const QString &sql, const QVariantList & params);
static uint fetchUInt(const QSqlDatabase & sqlCon,const QString &sql, const QString & param);
static uint fetchUInt(const QSqlDatabase & sqlCon,const QString &sql, const QVariant & param);
static uint fetchUInt(const QSqlDatabase & sqlCon,const QString& sql, const QVector<int64_t>& params);
static QString fetchString(const QSqlDatabase & sqlCon,const QString& sql, const QList<QVariant>& params);
static QString fetchString(const QSqlDatabase & sqlCon,const QString& sql, const QVariant& param);
static QString fetchString(const QSqlDatabase & sqlCon,const QString& sql);
static QList<int64_t> fetchInt64Column(const QSqlDatabase & sqlCon,const QString& sql, const QList<QVariant>& params);
static QList<int64_t> fetchInt64Column(QSqlQuery &preparedStatement, const QList<QVariant>& params);
static QSet<int64_t> fetchInt64ColumnAsSet(QSqlQuery &preparedStatement, const QList<QVariant>& params);
static QSet<int64_t> fetchInt64ColumnAsSet(const QSqlDatabase &sqlCon,
const QString &sql,
const QList<QVariant> ¶ms);
static QStringList fetchStringColumn(QSqlQuery &preparedStatement, const QList<QVariant>& params);
static QStringList fetchStringColumn(const QSqlDatabase & sqlCon,const QString& sql, const QList<QVariant>& params);
static QSqlQuery prepare(const QSqlDatabase &sqlCon, const QString& sql);
static int64_t insert(const QSqlDatabase & sqlCon,const QString& sql, const QList<QVariant>& params);
static QString getDebugString(const QString & sql, const QList<QVariant> & params);
static QString getDebugString(const QString &sql, QList<QPair<QString, QVariant> > params);
static void beginTransaction(const QSqlDatabase & sqlCon);
static void commitTransaction(const QSqlDatabase & sqlCon);
static void rollbackTransaction(const QSqlDatabase & sqlCon);
static QSet<int64_t> fetchInt64ColumnAsSet(const QSqlDatabase &sqlCon, const QString &sql);
};
}