Ticket #215: dbhelper.h

File dbhelper.h, 3.5 KB (added by fvilas@…, 19 years ago)

DB helper functions, place in libs/libmythtv

Line 
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
8class DBHelper {
9public:
10
11static QString dbCreateTable(const QString &dbType, const QString &tableName, bool temporary = false);
12
13static QString dbDropTable(const QString &dbType, const QString &tableName);
14
15static 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
17static 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
19static 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
21static 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
23static 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
25static QString dbFloat(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, bool unsignedCol = false, const QString &defaultVal = "");
26
27
28static QString dbTimeStamp(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, const QString &defaultVal = "");
29
30static QString dbDatetime(const QString &dbType, const QString &colName, bool nullable = true, const QString &defaultVal = "");
31
32static QString dbDate(const QString &dbType, const QString &colName, bool nullable = true, const QString &defaultVal = "");
33
34static QString dbYear(const QString &dbType, const QString &colName, const QString &width = "", bool nullable = true, const QString &defaultVal = "");
35
36static QString dbBlob(const QString &dbType, const QString &colName, bool nullable = true, const QString &defaultVal = "");
37
38static QString dbText(const QString &dbType, const QString &colName, bool nullable = true);
39
40
41
42static QString dbAddIndex(const QString &dbType, const QString &tableName, const QString &indexName, const QString &colList, bool unique = false);
43
44static QString dbDropPKey(const QString &dbType, const QString &tableName);
45
46static QString dbChangeColumn(const QString &dbType, const QString &tableName, const QString &oldColName, const QString &newColDef);
47
48static QString dbReplaceInto(const QString &dbType, const QString &tableName, const QString &fields, const QString &values, unsigned long where);
49
50
51static QString dbTimetoDOW(const QString &dbType, const QString &colName);
52
53static QString dbTimetoDays(const QString &dbType, const QString &colName);
54
55static QString dbTimetoSeconds(const QString &dbType, const QString &colName);
56
57static QString dbFromUnixTime(const QString &dbType, const QString &colName);
58
59static QString dbHoursMinutes(const QString &dbType, const QString &colName);
60
61
62
63static QString dbDateSub(const QString &dbType, const QString &colName1, const QString &colName2);
64
65static QString dbDateAdd(const QString &dbType, const QString &colName1, const QString &colName2);
66
67static QString dbCurrentTimestamp(const QString &dbType);
68
69static QString dbCurrentDate(const QString &dbType);
70
71
72static QString dbHex(const QString &dbType, const QString &value);
73
74};
75
76#endif