1 | #ifndef DBHELPER_H_ |
---|
2 | #define DBHELPER_H_ |
---|
3 | |
---|
4 | #include <qstring.h> |
---|
5 | |
---|
6 | /// These are the helper functions for supporting different db backends |
---|
7 | |
---|
8 | class DBHelper { |
---|
9 | public: |
---|
10 | |
---|
11 | static QString dbCreateTable(const QString &dbType, const QString &tableName, bool temporary = false); |
---|
12 | |
---|
13 | static QString dbDropTable(const QString &dbType, const QString &tableName); |
---|
14 | |
---|
15 | static QString dbInt(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, bool unsignedCol = false, const QString &defaultVal = "", bool auto_num = false); |
---|
16 | |
---|
17 | static QString dbBigInt(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, bool unsignedCol = false, const QString &defaultVal = "", bool auto_num = false); |
---|
18 | |
---|
19 | static QString dbSmallInt(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, bool unsignedCol = false, const QString &defaultVal = "", bool auto_num = false); |
---|
20 | |
---|
21 | static QString dbTinyInt(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, bool unsignedCol = false, const QString &defaultVal = "", bool auto_num = false); |
---|
22 | |
---|
23 | static QString dbMedInt(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, bool unsignedCol = false, const QString &defaultVal = "", bool auto_num = false); |
---|
24 | |
---|
25 | static QString dbFloat(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, bool unsignedCol = false, const QString &defaultVal = ""); |
---|
26 | |
---|
27 | |
---|
28 | static QString dbTimeStamp(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, const QString &defaultVal = ""); |
---|
29 | |
---|
30 | static QString dbDatetime(const QString &dbType, const QString &colName, bool nullable = true, const QString &defaultVal = ""); |
---|
31 | |
---|
32 | static QString dbDate(const QString &dbType, const QString &colName, bool nullable = true, const QString &defaultVal = ""); |
---|
33 | |
---|
34 | static QString dbYear(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, const QString &defaultVal = ""); |
---|
35 | |
---|
36 | static QString dbBlob(const QString &dbType, const QString &colName, bool nullable = true, const QString &defaultVal = ""); |
---|
37 | |
---|
38 | static QString dbText(const QString &dbType, const QString &colName, bool nullable = true); |
---|
39 | |
---|
40 | |
---|
41 | |
---|
42 | static QString dbAddIndex(const QString &dbType, const QString &tableName, const QString &indexName, const QString &colList, bool unique = false); |
---|
43 | |
---|
44 | static QString dbDropPKey(const QString &dbType, const QString &tableName); |
---|
45 | |
---|
46 | static QString dbChangeColumn(const QString &dbType, const QString &tableName, const QString &oldColName, const QString &newColDef); |
---|
47 | |
---|
48 | static QString dbReplaceInto(const QString &dbType, const QString &tableName, const QString &fields, const QString &values, unsigned long where); |
---|
49 | |
---|
50 | |
---|
51 | static QString dbTimetoDOW(const QString &dbType, const QString &colName); |
---|
52 | |
---|
53 | static QString dbTimetoDays(const QString &dbType, const QString &colName); |
---|
54 | |
---|
55 | static QString dbTimetoSeconds(const QString &dbType, const QString &colName); |
---|
56 | |
---|
57 | static QString dbFromUnixTime(const QString &dbType, const QString &colName); |
---|
58 | |
---|
59 | static QString dbHoursMinutes(const QString &dbType, const QString &colName); |
---|
60 | |
---|
61 | |
---|
62 | |
---|
63 | static QString dbDateSub(const QString &dbType, const QString &colName1, const QString &colName2); |
---|
64 | |
---|
65 | static QString dbDateAdd(const QString &dbType, const QString &colName1, const QString &colName2); |
---|
66 | |
---|
67 | static QString dbCurrentTimestamp(const QString &dbType); |
---|
68 | |
---|
69 | static QString dbCurrentDate(const QString &dbType); |
---|
70 | |
---|
71 | |
---|
72 | static QString dbHex(const QString &dbType, const QString &value); |
---|
73 | |
---|
74 | }; |
---|
75 | |
---|
76 | #endif |
---|