1 #ifndef BZS_DB_PROTOCOL_TDAP_CLIENT_ACTIVETABLE_H
2 #define BZS_DB_PROTOCOL_TDAP_CLIENT_ACTIVETABLE_H
21 #include "recordset.h"
22 #include "memRecord.h"
75 inline pq_handle& getFilter() {
return m_filter; };
82 class activeTableImple* m_imple;
88 inline void _supplyValue(pq_handle& q,
int index,
const T v)
91 THROW_BZS_ERROR_WITH_MSG(_T(
"Prepared query : supply value error."));
98 short mode = TD_OPEN_NORMAL);
100 short mode = TD_OPEN_NORMAL);
102 short mode = TD_OPEN_NORMAL);
104 short mode = TD_OPEN_NORMAL);
108 activeTable& alias(
const _TCHAR* orign,
const _TCHAR* alias);
115 const _TCHAR* name2 = NULL,
const _TCHAR* name3 = NULL,
116 const _TCHAR* name4 = NULL,
const _TCHAR* name5 = NULL,
117 const _TCHAR* name6 = NULL,
const _TCHAR* name7 = NULL,
118 const _TCHAR* name8 = NULL);
122 const _TCHAR* name2 = NULL,
const _TCHAR* name3 = NULL,
123 const _TCHAR* name4 = NULL,
const _TCHAR* name5 = NULL,
124 const _TCHAR* name6 = NULL,
const _TCHAR* name7 = NULL,
125 const _TCHAR* name8 = NULL);
128 const _TCHAR* name2 = NULL,
const _TCHAR* name3 = NULL,
129 const _TCHAR* name4 = NULL,
const _TCHAR* name5 = NULL,
130 const _TCHAR* name6 = NULL,
const _TCHAR* name7 = NULL,
131 const _TCHAR* name8 = NULL);
134 outerJoin(
recordset& rs, pq_handle& q,
const _TCHAR* name1,
135 const _TCHAR* name2 = NULL,
const _TCHAR* name3 = NULL,
136 const _TCHAR* name4 = NULL,
const _TCHAR* name5 = NULL,
137 const _TCHAR* name6 = NULL,
const _TCHAR* name7 = NULL,
138 const _TCHAR* name8 = NULL);
153 _supplyValue(q, 0, v0);
158 template<
class T0,
class T1>
161 _supplyValue(q, 0, v0);
162 _supplyValue(q, 1, v1);
167 template<
class T0,
class T1,
class T2>
171 _supplyValue(q, 0, v0);
172 _supplyValue(q, 1, v1);
173 _supplyValue(q, 2, v2);
178 template<
class T0,
class T1,
class T2,
class T3>
180 const T2 v2,
const T3 v3)
182 _supplyValue(q, 0, v0);
183 _supplyValue(q, 1, v1);
184 _supplyValue(q, 2, v2);
185 _supplyValue(q, 3, v3);
190 template<
class T0,
class T1,
class T2,
class T3,
class T4>
192 const T2 v2,
const T3 v3,
const T4 v4)
194 _supplyValue(q, 0, v0);
195 _supplyValue(q, 1, v1);
196 _supplyValue(q, 2, v2);
197 _supplyValue(q, 3, v3);
198 _supplyValue(q, 4, v4);
203 template<
class T0,
class T1,
class T2,
class T3,
class T4,
class T5>
205 const T2 v2,
const T3 v3,
const T4 v4,
const T5 v5)
207 _supplyValue(q, 0, v0);
208 _supplyValue(q, 1, v1);
209 _supplyValue(q, 2, v2);
210 _supplyValue(q, 3, v3);
211 _supplyValue(q, 4, v4);
212 _supplyValue(q, 5, v5);
217 template<
class T0,
class T1,
class T2,
class T3,
class T4,
class T5,
class T6>
219 const T2 v2,
const T3 v3,
const T4 v4,
const T5 v5,
222 _supplyValue(q, 0, v0);
223 _supplyValue(q, 1, v1);
224 _supplyValue(q, 2, v2);
225 _supplyValue(q, 3, v3);
226 _supplyValue(q, 4, v4);
227 _supplyValue(q, 5, v5);
228 _supplyValue(q, 6, v6);
233 template<
class T0,
class T1,
class T2,
class T3,
class T4,
class T5,
class T6,
236 const T2 v2,
const T3 v3,
const T4 v4,
const T5 v5,
237 const T6 v6,
const T7 v7)
239 _supplyValue(q, 0, v0);
240 _supplyValue(q, 1, v1);
241 _supplyValue(q, 2, v2);
242 _supplyValue(q, 3, v3);
243 _supplyValue(q, 4, v4);
244 _supplyValue(q, 5, v5);
245 _supplyValue(q, 6, v6);
246 _supplyValue(q, 7, v7);
254 template <
class T0>
activeTable& keyValue(
const T0 kv0)
256 keyValueSetter<T0>::set(table(), table()->keyNum(), kv0);
260 template <
class T0,
class T1>
263 keyValueSetter<T0, T1>::set(table(), table()->keyNum(), kv0, kv1);
267 template <
class T0,
class T1,
class T2>
268 activeTable& keyValue(
const T0 kv0,
const T1 kv1,
const T2 kv2)
270 keyValueSetter<T0, T1, T2>::set(table(), table()->keyNum(), kv0, kv1,
275 template <
class T0,
class T1,
class T2,
class T3>
276 activeTable& keyValue(
const T0 kv0,
const T1 kv1,
const T2 kv2,
279 keyValueSetter<T0, T1, T2, T3>::set(table(), table()->keyNum(), kv0,
284 template <
class T0,
class T1,
class T2,
class T3,
class T4>
285 activeTable& keyValue(
const T0 kv0,
const T1 kv1,
const T2 kv2,
286 const T3 kv3,
const T4 kv4)
288 keyValueSetter<T0, T1, T2, T3, T4>::set(table(), table()->keyNum(), kv0,
293 template <
class T0,
class T1,
class T2,
class T3,
class T4,
class T5>
294 activeTable& keyValue(
const T0 kv0,
const T1 kv1,
const T2 kv2,
295 const T3 kv3,
const T4 kv4,
const T5 kv5)
297 keyValueSetter<T0, T1, T2, T3, T4, T5>::set(
298 table(), table()->keyNum(), kv0, kv1, kv2, kv3, kv4, kv5);
302 template <
class T0,
class T1,
class T2,
class T3,
class T4,
class T5,
304 activeTable& keyValue(
const T0 kv0,
const T1 kv1,
const T2 kv2,
305 const T3 kv3,
const T4 kv4,
const T5 kv5,
308 keyValueSetter<T0, T1, T2, T3, T4, T5, T6>::set(
309 table(), table()->keyNum(), kv0, kv1, kv2, kv3, kv4, kv5, kv6);
315 template <
class T0,
class T1,
class T2,
class T3,
class T4,
class T5,
318 const T3 kv3,
const T4 kv4,
const T5 kv5,
319 const T6 kv6,
const T7 kv7)
321 keyValueSetter<T0, T1, T2, T3, T4, T5, T6, T7>::set(
322 table(), table()->keyNum(), kv0, kv1, kv2, kv3, kv4, kv5, kv6, kv7);
329 short mode = TD_OPEN_NORMAL);
331 short mode = TD_OPEN_NORMAL);
333 short mode = TD_OPEN_NORMAL);
335 short mode = TD_OPEN_NORMAL);
347 #endif // BZS_DB_PROTOCOL_TDAP_CLIENT_ACTIVETABLE_H
activeTableの読み取りクエリー 結果セットクラス
Definition: recordset.h:38
pq_handle prepare(table_ptr &tb, const queryBase &q, bool serverPrepare=false)
Definition: trdboostapi.h:580
bool supplyValue(int index, const _TCHAR *v)
Definition: activeTable.h:43
クエリー(フィルター)作成の補助をするためのベースクラス
Definition: table.h:354
boost::shared_ptr< idatabaseManager > dbmanager_ptr
Definition: trdboostapi.h:1260
boost::shared_ptr< table > table_ptr
Definition: fields.h:251
boost::function< int(const fields &)> validationFunc
Definition: trdboostapi.h:251
boost::shared_ptr< database > database_ptr
Definition: fields.h:250
bool supplyValue(int index, double v)
Definition: activeTable.h:53
テーブルアクセスクラス (nocopyable)
Definition: table.h:91
void resetAddIndex()
Definition: activeTable.h:73
プリペアードクエリークラス
Definition: activeTable.h:36
データベースとテーブルを管理するインタフェース
Definition: trdboostapi.h:172
bool DLLLIB supplyValue(pq_handle &filter, int index, const _TCHAR *v)
bool supplyValue(int index, __int64 v)
Definition: activeTable.h:48
preparedQuery(pq_handle filter)
Definition: activeTable.h:41
activeTable & keyValue(const T0 kv0, const T1 kv1, const T2 kv2, const T3 kv3, const T4 kv4, const T5 kv5, const T6 kv6, const T7 kv7)
Definition: activeTable.h:317
データベースアクセスクラス
Definition: database.h:59
void releaseTable(table *p)
Definition: trdboostapi.h:812
bool addValue(const _TCHAR *v)
Definition: activeTable.h:58
書き込み可能な行のクラスです。
Definition: memRecord.h:170
bool addValue(__int64 v)
Definition: activeTable.h:63
recordset 用テーブルアクセスクラス
Definition: activeTable.h:80
bool addValue(double v)
Definition: activeTable.h:68