19 #include "hsactivitydbclientinterface.h" |
19 #include "hsactivitydbclientinterface.h" |
20 #include <QSqlDatabase> |
20 #include <QSqlDatabase> |
21 |
21 |
22 /** |
22 /** |
23 * Class implements HsActivityDbClientInterface and storage functionality using |
23 * Class implements HsActivityDbClientInterface and storage functionality using |
24 * database subsystem |
24 * database subsystem |
25 */ |
25 */ |
26 class HsActivityStoragePrivate: public HsActivityDbClientInterface |
26 class HsActivityStoragePrivate: public HsActivityDbClientInterface |
27 { |
27 { |
28 public: |
28 public: |
29 /** |
29 /** |
30 * Constructor |
30 * Constructor |
31 */ |
31 */ |
32 HsActivityStoragePrivate(); |
32 HsActivityStoragePrivate(); |
33 |
33 |
34 /** |
34 /** |
35 * Destructor |
35 * Destructor |
36 */ |
36 */ |
37 ~HsActivityStoragePrivate(); |
37 ~HsActivityStoragePrivate(); |
38 |
38 |
39 /** |
39 /** |
40 * Interface implementation. |
40 * Interface implementation. |
41 * @see int HsActivityDbClientInterface::addActivity(const QVariantHash&) |
41 * @see int HsActivityDbClientInterface::addActivity(const QVariantHash&) |
42 */ |
42 */ |
43 int addActivity(const QVariantHash &); |
43 int addActivity(const QVariantHash &); |
44 |
44 |
45 /** |
45 /** |
46 * Interface implementation. |
46 * Interface implementation. |
47 * @see int HsActivityDbClientInterface::updateActivity(const QVariantHash&) |
47 * @see int HsActivityDbClientInterface::updateActivity(const QVariantHash&) |
48 */ |
48 */ |
49 int updateActivity(const QVariantHash &); |
49 int updateActivity(const QVariantHash &); |
50 |
50 |
51 /** |
51 /** |
52 * Interface implementation. |
52 * Interface implementation. |
53 * @see int HsActivityDbClientInterface::removeActivity(const QVariantHash &) |
53 * @see int HsActivityDbClientInterface::removeActivity(const QVariantHash &) |
54 */ |
54 */ |
55 int removeActivity(const QVariantHash &activity); |
55 int removeActivity(const QVariantHash &activity); |
56 |
56 |
57 /** |
57 /** |
58 * Interface implementation. |
58 * Interface implementation. |
59 * @see int HsActivityDbClientInterface::removeApplicationActivities(const QVariantHash &) |
59 * @see int HsActivityDbClientInterface::removeApplicationActivities(const QVariantHash &) |
60 */ |
60 */ |
61 int removeApplicationActivities(const QVariantHash &activity); |
61 int removeApplicationActivities(const QVariantHash &activity); |
62 |
62 |
63 /** |
63 /** |
64 * Interface implementation. |
64 * Interface implementation. |
65 * @see int HsActivityDbClientInterface::requestedActivityName( QString &, const QVariantHash &) |
65 * @see int HsActivityDbClientInterface::requestedActivityName( QString &, const QVariantHash &) |
66 */ |
66 */ |
67 int requestedActivityName(QString& result, |
67 int requestedActivityName(QString &result, |
68 const QVariantHash &activity); |
68 const QVariantHash &activity); |
69 |
69 |
70 /** |
70 /** |
71 * Interface implementation. |
71 * Interface implementation. |
72 * @see int HsActivityDbClientInterface::activities(QList<QVariantHash> &) |
72 * @see int HsActivityDbClientInterface::activities(QList<QVariantHash> &) |
73 */ |
73 */ |
74 int activities(QList<QVariantHash> &); |
74 int activities(QList<QVariantHash> &); |
75 |
75 |
76 /** |
76 /** |
77 * Interface implementation. |
77 * Interface implementation. |
78 * @see int HsActivityDbClientInterface::applicationActivities(QList<QVariantHash> &, const QVariantHash &) |
78 * @see int HsActivityDbClientInterface::applicationActivities(QList<QVariantHash> &, const QVariantHash &) |
79 */ |
79 */ |
80 int applicationActivities(QList<QVariantHash> &, const QVariantHash &); |
80 int applicationActivities(QList<QVariantHash> &, const QVariantHash &); |
81 |
81 |
82 /** |
82 /** |
83 * Interface implementation. |
83 * Interface implementation. |
84 * @see int HsActivityDbClientInterface::waitActivity(const QVariantHash &) |
84 * @see int HsActivityDbClientInterface::waitActivity(const QVariantHash &) |
85 */ |
85 */ |
86 int waitActivity(const QVariantHash &activity); |
86 int waitActivity(const QVariantHash &activity); |
87 |
87 |
88 /** |
88 /** |
89 * Interface implementation. |
89 * Interface implementation. |
90 * @see int HsActivityDbClientInterface::launchActivity(const QVariantHash &) |
90 * @see int HsActivityDbClientInterface::launchActivity(const QVariantHash &) |
91 */ |
91 */ |
92 int launchActivity(const QVariantHash &activity); |
92 int launchActivity(const QVariantHash &activity); |
94 /** |
94 /** |
95 * Function check database structure |
95 * Function check database structure |
96 * @return true if structure is valid, false otherwise |
96 * @return true if structure is valid, false otherwise |
97 */ |
97 */ |
98 bool checkTables(); |
98 bool checkTables(); |
99 |
99 |
100 /** |
100 /** |
101 * Function create database structure |
101 * Function create database structure |
102 */ |
102 */ |
103 void recreateTables(); |
103 void recreateTables(); |
104 |
104 |
105 /** |
105 /** |
106 * Function return last SQL query error code |
106 * Function return last SQL query error code |
107 * @param querty - executed sql query |
107 * @param querty - executed sql query |
108 * @return SQL query error code |
108 * @return SQL query error code |
109 */ |
109 */ |
110 int getSqlErrorCode(const QSqlQuery& query); |
110 int getSqlErrorCode(const QSqlQuery &query); |
111 |
111 |
112 /** |
112 /** |
113 * Function exeute SQL query |
113 * Function exeute SQL query |
114 * @param query - SQL |
114 * @param query - SQL |
115 * @return true on succees, false otherwise |
115 * @return true on succees, false otherwise |
116 */ |
116 */ |
117 bool exec(QSqlQuery& query); |
117 bool exec(QSqlQuery &query); |
118 |
118 |
119 /** |
119 /** |
120 * Function exeute SQL query |
120 * Function exeute SQL query |
121 * @param query - SQL query that has to be executed |
121 * @param query - SQL query that has to be executed |
122 * @return true on succees, false otherwise |
122 * @return true on succees, false otherwise |
123 */ |
123 */ |
124 bool exec(const QString &query, const QVariantHash& params); |
124 bool exec(const QString &query, const QVariantHash ¶ms); |
125 |
125 |
126 /** |
126 /** |
127 * Funciton bind provided filtering rules with prepared SQL query |
127 * Funciton bind provided filtering rules with prepared SQL query |
128 * @param query - SQL query |
128 * @param query - SQL query |
129 * @param activity - filtering rules |
129 * @param activity - filtering rules |
130 * @param additionalData - additional filetering rules |
130 * @param additionalData - additional filetering rules |
131 */ |
131 */ |
132 void bind( QSqlQuery& query, |
132 void bind(QSqlQuery &query, |
133 const QVariantHash &activity, |
133 const QVariantHash &activity, |
134 const QVariantHash &additionalData = QVariantHash()); |
134 const QVariantHash &additionalData = QVariantHash()); |
135 |
135 |
136 /** |
136 /** |
137 * Funciton get records that match conditions |
137 * Funciton get records that match conditions |
138 * @param result - output destination |
138 * @param result - output destination |
139 * @param query - SQL query sting |
139 * @param query - SQL query sting |
140 * @param conditions - query conditions |
140 * @param conditions - query conditions |
141 */ |
141 */ |
142 int activities(QList<QVariantHash> &results, |
142 int activities(QList<QVariantHash> &results, |
143 const QString &query, |
143 const QString &query, |
144 const QVariantHash &conditions); |
144 const QVariantHash &conditions); |
145 |
145 |
146 private: |
146 private: |
147 /** |
147 /** |