Electroneum
Loading...
Searching...
No Matches
epee::ado_db_helper Namespace Reference

Classes

struct  profile_entry
class  profiler_manager
class  timing_guard
struct  adapter_zero
struct  adapter_single
struct  adapter_double
struct  adapter_triple
struct  adapter_quad
struct  adapter_quanto
struct  adapter_sixto
struct  adapter_sevento
struct  adapter_nine
class  per_thread_connection_pool

Typedefs

typedef std::vector< std::vector< _variant_t > > table

Functions

profiler_managerget_set_profiler (bool need_to_set=false, profiler_manager **pprofiler=NULL)
bool init ()
bool deinit ()
bool push_timing (const std::string sql, DWORD time)
bool flush_profiler (const std::string path)
bool add_parametr (ADODB::_CommandPtr cmd, const std::string &parametr)
bool add_parametr (ADODB::_CommandPtr cmd, const std::wstring &parametr)
bool add_parametr (ADODB::_CommandPtr cmd, const __int64 parametr)
bool add_parametr (ADODB::_CommandPtr cmd, const unsigned __int64 parametr)
bool add_parametr (ADODB::_CommandPtr cmd, const int parametr)
bool add_parametr (ADODB::_CommandPtr cmd, const unsigned int parametr)
bool add_parametr (ADODB::_CommandPtr cmd, float parametr)
bool add_parametr (ADODB::_CommandPtr cmd, bool parametr)
bool add_parametr (ADODB::_CommandPtr cmd, _variant_t parametr)
bool add_parametr_as_double (ADODB::_CommandPtr cmd, const DATE parametr)
template<typename TParam>
bool add_parametr (ADODB::_CommandPtr cmd, const std::list< TParam > params)
bool add_parametr (ADODB::_CommandPtr cmd, const DATE parametr)
bool execute_helper (ADODB::_CommandPtr cmd, _variant_t *pcount_processed=NULL)
bool select_helper (ADODB::_CommandPtr cmd, table &result_vector)
template<typename TParam1>
bool add_parametrs_multi (ADODB::_CommandPtr cmd, const adapter_zero< TParam1 > &params)
template<typename TParam1>
bool add_parametrs_multi (ADODB::_CommandPtr cmd, const adapter_single< TParam1 > &params)
template<typename TParam1, typename TParam2>
bool add_parametrs_multi (ADODB::_CommandPtr cmd, const adapter_double< TParam1, TParam2 > &params)
template<typename TParam1, typename TParam2, typename TParam3>
bool add_parametrs_multi (ADODB::_CommandPtr cmd, const adapter_triple< TParam1, TParam2, TParam3 > &params)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4>
bool add_parametrs_multi (ADODB::_CommandPtr cmd, const adapter_quad< TParam1, TParam2, TParam3, TParam4 > &params)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5>
bool add_parametrs_multi (ADODB::_CommandPtr cmd, const adapter_quanto< TParam1, TParam2, TParam3, TParam4, TParam5 > &params)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6>
bool add_parametrs_multi (ADODB::_CommandPtr cmd, const adapter_sixto< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6 > &params)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7>
bool add_parametrs_multi (ADODB::_CommandPtr cmd, const adapter_sevento< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7 > &params)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7, typename TParam8, typename TParam9>
bool add_parametrs_multi (ADODB::_CommandPtr cmd, const adapter_nine< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7, TParam8, TParam9 > &params)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7>
std::string print_parameters_multi (const adapter_sevento< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7 > &params)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7, typename TParam8, typename TParam9>
std::string print_parameters_multi (const adapter_nine< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7, TParam8, TParam9 > &params)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6>
std::string print_parameters_multi (const adapter_sixto< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6 > &params)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5>
std::string print_parameters_multi (const adapter_quanto< TParam1, TParam2, TParam3, TParam4, TParam5 > &params)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4>
std::string print_parameters_multi (const adapter_quad< TParam1, TParam2, TParam3, TParam4 > &params)
template<typename TParam1, typename TParam2, typename TParam3>
std::string print_parameters_multi (const adapter_triple< TParam1, TParam2, TParam3 > &params)
template<typename TParam>
std::string get_str_param (const TParam &prm)
template<typename TParam>
std::string get_str_param (const std::list< TParam > &prm_lst)
template<typename TParam1, typename TParam2>
std::string print_parameters_multi (const adapter_double< TParam1, TParam2 > &params)
template<typename TParam1>
std::string print_parameters_multi (const adapter_single< TParam1 > &params)
template<typename TParam1>
std::string print_parameters_multi (const adapter_zero< TParam1 > &params)
template<typename TParams>
bool execute_helper_multiparam (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, _variant_t *pcount_processed=NULL)
template<typename TParams>
bool select_helper_multiparam (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
template<typename TParams>
bool select_helper_param_container (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
bool execute_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, _variant_t *pvt=NULL)
template<typename TParam>
bool execute_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam &parametr)
template<typename TParam1, typename TParam2>
bool execute_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 &parametr1, const TParam2 &parametr2)
template<typename TParam1, typename TParam2, typename TParam3>
bool execute_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 &parametr1, const TParam2 &parametr2, const TParam3 &parametr3)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4>
bool execute_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 &parametr1, const TParam2 &parametr2, const TParam3 &parametr3, const TParam4 &parametr4)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5>
bool execute_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 &parametr1, const TParam2 &parametr2, const TParam3 &parametr3, const TParam4 &parametr4, const TParam5 &parametr5)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6>
bool execute_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 &parametr1, const TParam2 &parametr2, const TParam3 &parametr3, const TParam4 &parametr4, const TParam5 &parametr5, const TParam6 &parametr6)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7>
bool execute_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 &parametr1, const TParam2 &parametr2, const TParam3 &parametr3, const TParam4 &parametr4, const TParam5 &parametr5, const TParam6 &parametr6, const TParam7 &parametr7)
bool select_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, table &result_vector)
template<typename TParam>
bool select_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam &parametr, table &result_vector)
template<typename TParam1, typename TParam2>
bool select_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 parametr1, const TParam2 parametr2, table &result_vector)
template<typename TParam1, typename TParam2, typename TParam3>
bool select_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 parametr1, const TParam2 parametr2, const TParam3 parametr3, table &result_vector)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4>
bool select_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 parametr1, const TParam2 parametr2, const TParam3 parametr3, const TParam4 parametr4, table &result_vector)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5>
bool select_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 parametr1, const TParam2 parametr2, const TParam3 parametr3, const TParam4 parametr4, const TParam5 parametr5, table &result_vector)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6>
bool select_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 parametr1, const TParam2 parametr2, const TParam3 parametr3, const TParam4 parametr4, const TParam5 parametr5, const TParam6 parametr6, table &result_vector)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7>
bool select_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 parametr1, const TParam2 parametr2, const TParam3 parametr3, const TParam4 parametr4, const TParam5 parametr5, const TParam6 parametr6, const TParam7 parametr7, table &result_vector)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7, typename TParam8, typename TParam9>
bool select_helper (ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParam1 parametr1, const TParam2 parametr2, const TParam3 parametr3, const TParam4 parametr4, const TParam5 parametr5, const TParam6 parametr6, const TParam7 parametr7, const TParam8 parametr8, const TParam9 parametr9, table &result_vector)
template<typename TParam1, typename default_id_type, typename t_conn>
bool find_or_add_t (const std::string &sql_select_statment, const std::string &sql_insert_statment, OUT default_id_type &id, OUT bool &new_object_added, TParam1 parametr_1, t_conn &c)
template<typename TParam1, typename TParam2, typename default_id_type, typename t_conn>
bool find_or_add_t (const std::string &sql_select_statment, const std::string &sql_insert_statment, OUT default_id_type &id, OUT bool &new_object_added, TParam1 parametr_1, TParam2 parametr_2, t_conn &c)
template<typename TParam1, typename TParam2, typename TParam3, typename default_id_type, typename t_conn>
bool find_or_add_t (const std::string &sql_select_statment, const std::string &sql_insert_statment, OUT default_id_type &id, OUT bool &new_object_added, TParam1 parametr_1, TParam2 parametr_2, TParam3 parametr_3, t_conn &c)
template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename default_id_type, typename t_conn>
bool find_or_add_t (const std::string &sql_select_statment, const std::string &sql_insert_statment, OUT default_id_type &id, OUT bool &new_object_added, TParam1 parametr_1, TParam2 parametr_2, TParam3 parametr_3, TParam4 parametr_4, t_conn &c)
template<typename TParams, typename default_id_type, typename t_conn>
bool find_or_add_t_multiparametred (const std::string &sql_select_statment, const std::string &sql_insert_statment, OUT default_id_type &id, OUT bool &new_object_added, TParams params, t_conn &c)

Typedef Documentation

◆ table

typedef std::vector<std::vector<_variant_t> > epee::ado_db_helper::table

Definition at line 209 of file ado_db_helper.h.

Function Documentation

◆ add_parametr() [1/11]

bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
_variant_t parametr )
inline

Definition at line 286 of file ado_db_helper.h.

287 {
288 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("parametr", ADODB::adDBTimeStamp, ADODB::adParamInput, sizeof(parametr), parametr);
289 cmd->Parameters->Append(param_obj);
290 return true;
291 }

◆ add_parametr() [2/11]

bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
bool parametr )
inline

Definition at line 276 of file ado_db_helper.h.

277 {
278 _variant_t param;
279 param = parametr;
280 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("parametr", ADODB::adBoolean, ADODB::adParamInput, sizeof(parametr), param);
281 cmd->Parameters->Append(param_obj);
282 return true;
283 }

◆ add_parametr() [3/11]

bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
const __int64 parametr )
inline

Definition at line 229 of file ado_db_helper.h.

230 {
231 _variant_t param(parametr);
232 ADODB::ADO_LONGPTR size = static_cast<long>(sizeof(parametr));
233 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("parametr", ADODB::adBigInt, ADODB::adParamInput, static_cast<long>(size), param);
234 cmd->Parameters->Append(param_obj);
235 return true;
236 }

◆ add_parametr() [4/11]

bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
const DATE parametr )
inline

Definition at line 325 of file ado_db_helper.h.

326 {
327 /*_variant_t param;
328 param.ChangeType(VT_R8);
329 param.dblVal = parametr;
330 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("parametr", ADODB::adDouble, ADODB::adParamInput, sizeof(float), param);
331 cmd->Parameters->Append(param_obj);*/
332
333 _variant_t param;
334 param.ChangeType(VT_DATE);
335 param.date = parametr;
336 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("parametr", ADODB::adDBDate, ADODB::adParamInput, sizeof(parametr), param);
337 cmd->Parameters->Append(param_obj);
338
339 return true;
340 }

◆ add_parametr() [5/11]

bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
const int parametr )
inline

Definition at line 248 of file ado_db_helper.h.

249 {
250 _variant_t param(parametr);
251 ADODB::ADO_LONGPTR size = static_cast<long>(sizeof(parametr));
252 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("parametr", ADODB::adInteger, ADODB::adParamInput, static_cast<long>(size), param);
253 cmd->Parameters->Append(param_obj);
254 return true;
255 }

◆ add_parametr() [6/11]

template<typename TParam>
bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
const std::list< TParam > params )
inline

Definition at line 305 of file ado_db_helper.h.

306 {
307 for(std::list<TParam>::const_iterator it = params.begin(); it!=params.end(); it++)
308 if(!add_parametr(cmd, *it))
309 return false;
310 return true;
311 }
bool add_parametr(ADODB::_CommandPtr cmd, const std::string &parametr)
Here is the call graph for this function:

◆ add_parametr() [7/11]

bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
const std::string & parametr )
inline

Definition at line 211 of file ado_db_helper.h.

212 {
213 _variant_t param(parametr.c_str());
214 ADODB::ADO_LONGPTR size = sizeof(parametr);
215 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("", ADODB::adVarChar, ADODB::adParamInput, static_cast<long>(parametr.size()+1), param);
216 cmd->Parameters->Append(param_obj);
217 return true;
218 }
Here is the caller graph for this function:

◆ add_parametr() [8/11]

bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
const std::wstring & parametr )
inline

Definition at line 220 of file ado_db_helper.h.

221 {
222 _variant_t param(parametr.c_str());
223 ADODB::ADO_LONGPTR size = sizeof(parametr);
224 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("", ADODB::adVarWChar, ADODB::adParamInput, static_cast<long>(parametr.size()+2), param);
225 cmd->Parameters->Append(param_obj);
226 return true;
227 }

◆ add_parametr() [9/11]

bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
const unsigned __int64 parametr )
inline

Definition at line 238 of file ado_db_helper.h.

239 {
240 _variant_t param(parametr);
241 ADODB::ADO_LONGPTR size = static_cast<long>(sizeof(parametr));
242 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("parametr", ADODB::adUnsignedBigInt, ADODB::adParamInput, static_cast<long>(size), param);
243 cmd->Parameters->Append(param_obj);
244 return true;
245 }

◆ add_parametr() [10/11]

bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
const unsigned int parametr )
inline

Definition at line 257 of file ado_db_helper.h.

258 {
259 _variant_t param(parametr);
260 ADODB::ADO_LONGPTR size = static_cast<long>(sizeof(parametr));
261 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("parametr", ADODB::adUnsignedInt, ADODB::adParamInput, static_cast<long>(size), param);
262 cmd->Parameters->Append(param_obj);
263 return true;
264 }

◆ add_parametr() [11/11]

bool epee::ado_db_helper::add_parametr ( ADODB::_CommandPtr cmd,
float parametr )
inline

Definition at line 266 of file ado_db_helper.h.

267 {
268 _variant_t param;
269 param.ChangeType(VT_R4);
270 param.fltVal = parametr;
271 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("parametr", ADODB::adSingle, ADODB::adParamInput, static_cast<long>(sizeof(float)), param);
272 cmd->Parameters->Append(param_obj);
273 return true;
274 }

◆ add_parametr_as_double()

bool epee::ado_db_helper::add_parametr_as_double ( ADODB::_CommandPtr cmd,
const DATE parametr )
inline

Definition at line 294 of file ado_db_helper.h.

295 {
296 _variant_t param;
297 param.ChangeType(VT_R8);
298 param.dblVal = parametr;
299 ADODB::_ParameterPtr param_obj = cmd->CreateParameter("parametr", ADODB::adDouble, ADODB::adParamInput, sizeof(float), param);
300 cmd->Parameters->Append(param_obj);
301 return true;
302 }

◆ add_parametrs_multi() [1/9]

template<typename TParam1, typename TParam2>
bool epee::ado_db_helper::add_parametrs_multi ( ADODB::_CommandPtr cmd,
const adapter_double< TParam1, TParam2 > & params )

Definition at line 502 of file ado_db_helper.h.

503 {
504 if(!add_parametr(cmd, params.tparam1)) return false;
505 return add_parametr(cmd, params.tparam2);
506 }
Here is the call graph for this function:

◆ add_parametrs_multi() [2/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7, typename TParam8, typename TParam9>
bool epee::ado_db_helper::add_parametrs_multi ( ADODB::_CommandPtr cmd,
const adapter_nine< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7, TParam8, TParam9 > & params )

Definition at line 559 of file ado_db_helper.h.

560 {
561 if(!add_parametr(cmd, params.tparam1)) return false;
562 if(!add_parametr(cmd, params.tparam2)) return false;
563 if(!add_parametr(cmd, params.tparam3)) return false;
564 if(!add_parametr(cmd, params.tparam4)) return false;
565 if(!add_parametr(cmd, params.tparam5)) return false;
566 if(!add_parametr(cmd, params.tparam6)) return false;
567 if(!add_parametr(cmd, params.tparam7)) return false;
568 if(!add_parametr(cmd, params.tparam8)) return false;
569 return add_parametr(cmd, params.tparam9);
570 }
Here is the call graph for this function:

◆ add_parametrs_multi() [3/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4>
bool epee::ado_db_helper::add_parametrs_multi ( ADODB::_CommandPtr cmd,
const adapter_quad< TParam1, TParam2, TParam3, TParam4 > & params )

Definition at line 517 of file ado_db_helper.h.

518 {
519 if(!add_parametr(cmd, params.tparam1)) return false;
520 if(!add_parametr(cmd, params.tparam2)) return false;
521 if(!add_parametr(cmd, params.tparam3)) return false;
522 return add_parametr(cmd, params.tparam4);
523 }
Here is the call graph for this function:

◆ add_parametrs_multi() [4/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5>
bool epee::ado_db_helper::add_parametrs_multi ( ADODB::_CommandPtr cmd,
const adapter_quanto< TParam1, TParam2, TParam3, TParam4, TParam5 > & params )

Definition at line 526 of file ado_db_helper.h.

527 {
528 if(!add_parametr(cmd, params.tparam1)) return false;
529 if(!add_parametr(cmd, params.tparam2)) return false;
530 if(!add_parametr(cmd, params.tparam3)) return false;
531 if(!add_parametr(cmd, params.tparam4)) return false;
532 return add_parametr(cmd, params.tparam5);
533 }
Here is the call graph for this function:

◆ add_parametrs_multi() [5/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7>
bool epee::ado_db_helper::add_parametrs_multi ( ADODB::_CommandPtr cmd,
const adapter_sevento< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7 > & params )

Definition at line 547 of file ado_db_helper.h.

548 {
549 if(!add_parametr(cmd, params.tparam1)) return false;
550 if(!add_parametr(cmd, params.tparam2)) return false;
551 if(!add_parametr(cmd, params.tparam3)) return false;
552 if(!add_parametr(cmd, params.tparam4)) return false;
553 if(!add_parametr(cmd, params.tparam5)) return false;
554 if(!add_parametr(cmd, params.tparam6)) return false;
555 return add_parametr(cmd, params.tparam7);
556 }
Here is the call graph for this function:

◆ add_parametrs_multi() [6/9]

template<typename TParam1>
bool epee::ado_db_helper::add_parametrs_multi ( ADODB::_CommandPtr cmd,
const adapter_single< TParam1 > & params )

Definition at line 496 of file ado_db_helper.h.

497 {
498 return add_parametr(cmd, params.tparam1);
499 }
Here is the call graph for this function:

◆ add_parametrs_multi() [7/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6>
bool epee::ado_db_helper::add_parametrs_multi ( ADODB::_CommandPtr cmd,
const adapter_sixto< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6 > & params )

Definition at line 536 of file ado_db_helper.h.

537 {
538 if(!add_parametr(cmd, params.tparam1)) return false;
539 if(!add_parametr(cmd, params.tparam2)) return false;
540 if(!add_parametr(cmd, params.tparam3)) return false;
541 if(!add_parametr(cmd, params.tparam4)) return false;
542 if(!add_parametr(cmd, params.tparam5)) return false;
543 return add_parametr(cmd, params.tparam6);
544 }
Here is the call graph for this function:

◆ add_parametrs_multi() [8/9]

template<typename TParam1, typename TParam2, typename TParam3>
bool epee::ado_db_helper::add_parametrs_multi ( ADODB::_CommandPtr cmd,
const adapter_triple< TParam1, TParam2, TParam3 > & params )

Definition at line 509 of file ado_db_helper.h.

510 {
511 if(!add_parametr(cmd, params.tparam1)) return false;
512 if(!add_parametr(cmd, params.tparam2)) return false;
513 return add_parametr(cmd, params.tparam3);
514 }
Here is the call graph for this function:

◆ add_parametrs_multi() [9/9]

template<typename TParam1>
bool epee::ado_db_helper::add_parametrs_multi ( ADODB::_CommandPtr cmd,
const adapter_zero< TParam1 > & params )

Definition at line 490 of file ado_db_helper.h.

491 {
492 return true;
493 }
Here is the caller graph for this function:

◆ deinit()

bool epee::ado_db_helper::deinit ( )
inline

Definition at line 162 of file ado_db_helper.h.

163 {
165 //get_set_profiler(false, &pmanager);
166 if(pmanager)
167 delete pmanager;
168 return true;
169 }
profiler_manager * get_set_profiler(bool need_to_set=false, profiler_manager **pprofiler=NULL)
Here is the call graph for this function:

◆ execute_helper() [1/9]

bool epee::ado_db_helper::execute_helper ( ADODB::_CommandPtr cmd,
_variant_t * pcount_processed = NULL )
inline

Definition at line 343 of file ado_db_helper.h.

344 {
345 //BEGIN_TRY_SECTION();
346
347 cmd->Execute(pcount_processed, NULL, ADODB::adExecuteNoRecords);
348
349
350 //CATCH_TRY_SECTION(false);
351
352 return true;
353 }
Here is the caller graph for this function:

◆ execute_helper() [2/9]

bool epee::ado_db_helper::execute_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
_variant_t * pvt = NULL )
inline

Definition at line 734 of file ado_db_helper.h.

735 {
736 adapter_zero<int> params;
737 return execute_helper_multiparam(pconnection, sql_statment, params, pvt);
738 }
bool execute_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, _variant_t *pcount_processed=NULL)
Here is the call graph for this function:

◆ execute_helper() [3/9]

template<typename TParam>
bool epee::ado_db_helper::execute_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam & parametr )

Definition at line 741 of file ado_db_helper.h.

742 {
744 params.tparam1 = parametr;
745 return execute_helper_multiparam(pconnection, sql_statment, params);
746 }
Here is the call graph for this function:

◆ execute_helper() [4/9]

template<typename TParam1, typename TParam2>
bool epee::ado_db_helper::execute_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 & parametr1,
const TParam2 & parametr2 )

Definition at line 750 of file ado_db_helper.h.

751 {
753 params.tparam1 = parametr1;
754 params.tparam2 = parametr2;
755 return execute_helper_multiparam(pconnection, sql_statment, params);
756
757 }
Here is the call graph for this function:

◆ execute_helper() [5/9]

template<typename TParam1, typename TParam2, typename TParam3>
bool epee::ado_db_helper::execute_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 & parametr1,
const TParam2 & parametr2,
const TParam3 & parametr3 )

Definition at line 760 of file ado_db_helper.h.

761 {
763 params.tparam1 = parametr1;
764 params.tparam2 = parametr2;
765 params.tparam3 = parametr3;
766 return execute_helper_multiparam(pconnection, sql_statment, params);
767 }
Here is the call graph for this function:

◆ execute_helper() [6/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4>
bool epee::ado_db_helper::execute_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 & parametr1,
const TParam2 & parametr2,
const TParam3 & parametr3,
const TParam4 & parametr4 )

Definition at line 770 of file ado_db_helper.h.

771 {
773 params.tparam1 = parametr1;
774 params.tparam2 = parametr2;
775 params.tparam3 = parametr3;
776 params.tparam4 = parametr4;
777 return execute_helper_multiparam(pconnection, sql_statment, params);
778 }
Here is the call graph for this function:

◆ execute_helper() [7/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5>
bool epee::ado_db_helper::execute_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 & parametr1,
const TParam2 & parametr2,
const TParam3 & parametr3,
const TParam4 & parametr4,
const TParam5 & parametr5 )

Definition at line 781 of file ado_db_helper.h.

782 {
784 params.tparam1 = parametr1;
785 params.tparam2 = parametr2;
786 params.tparam3 = parametr3;
787 params.tparam4 = parametr4;
788 params.tparam5 = parametr5;
789 return execute_helper_multiparam(pconnection, sql_statment, params);
790 }
Here is the call graph for this function:

◆ execute_helper() [8/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6>
bool epee::ado_db_helper::execute_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 & parametr1,
const TParam2 & parametr2,
const TParam3 & parametr3,
const TParam4 & parametr4,
const TParam5 & parametr5,
const TParam6 & parametr6 )

Definition at line 793 of file ado_db_helper.h.

794 {
796 params.tparam1 = parametr1;
797 params.tparam2 = parametr2;
798 params.tparam3 = parametr3;
799 params.tparam4 = parametr4;
800 params.tparam5 = parametr5;
801 params.tparam6 = parametr6;
802 return execute_helper_multiparam(pconnection, sql_statment, params);
803 }
Here is the call graph for this function:

◆ execute_helper() [9/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7>
bool epee::ado_db_helper::execute_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 & parametr1,
const TParam2 & parametr2,
const TParam3 & parametr3,
const TParam4 & parametr4,
const TParam5 & parametr5,
const TParam6 & parametr6,
const TParam7 & parametr7 )

Definition at line 807 of file ado_db_helper.h.

808 {
810 params.tparam1 = parametr1;
811 params.tparam2 = parametr2;
812 params.tparam3 = parametr3;
813 params.tparam4 = parametr4;
814 params.tparam5 = parametr5;
815 params.tparam6 = parametr6;
816 params.tparam7 = parametr7;
817 return execute_helper_multiparam(pconnection, sql_statment, params);
818 }
Here is the call graph for this function:

◆ execute_helper_multiparam()

template<typename TParams>
bool epee::ado_db_helper::execute_helper_multiparam ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParams & parametrs,
_variant_t * pcount_processed = NULL )

Definition at line 665 of file ado_db_helper.h.

666 {
667 PROFILE_SQL(sql_statment);
668 bool res = false;
670
671 ADODB::_CommandPtr cmd;
672 cmd.CreateInstance(__uuidof(ADODB::Command));
673 cmd->CommandText = _bstr_t(sql_statment.c_str());
674
675 if(!add_parametrs_multi(cmd, parametrs))
676 return false;
677
678 cmd->ActiveConnection = pconnection;
679 res = execute_helper(cmd, pcount_processed);
680
681 CATCH_TRY_SECTION_MESS(false, "while statment: " << sql_statment << " [params]: " << print_parameters_multi(parametrs));
682 return res;
683 }
#define PROFILE_SQL(sql)
#define CATCH_TRY_SECTION_MESS(ret_val, mess_where)
#define BEGIN_TRY_SECTION()
const char * res
std::string print_parameters_multi(const adapter_sevento< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7 > &params)
bool execute_helper(ADODB::_CommandPtr cmd, _variant_t *pcount_processed=NULL)
bool add_parametrs_multi(ADODB::_CommandPtr cmd, const adapter_zero< TParam1 > &params)
Here is the call graph for this function:
Here is the caller graph for this function:

◆ find_or_add_t() [1/4]

template<typename TParam1, typename default_id_type, typename t_conn>
bool epee::ado_db_helper::find_or_add_t ( const std::string & sql_select_statment,
const std::string & sql_insert_statment,
OUT default_id_type & id,
OUT bool & new_object_added,
TParam1 parametr_1,
t_conn & c )

Definition at line 1022 of file ado_db_helper.h.

1023 {
1025 params.tparam1 = parametr_1;
1026 return find_or_add_t_multiparametred(sql_select_statment, sql_insert_statment, id, new_object_added, params, c);
1027 }
bool find_or_add_t_multiparametred(const std::string &sql_select_statment, const std::string &sql_insert_statment, OUT default_id_type &id, OUT bool &new_object_added, TParams params, t_conn &c)
Here is the call graph for this function:

◆ find_or_add_t() [2/4]

template<typename TParam1, typename TParam2, typename default_id_type, typename t_conn>
bool epee::ado_db_helper::find_or_add_t ( const std::string & sql_select_statment,
const std::string & sql_insert_statment,
OUT default_id_type & id,
OUT bool & new_object_added,
TParam1 parametr_1,
TParam2 parametr_2,
t_conn & c )

Definition at line 1031 of file ado_db_helper.h.

1032 {
1034 params.tparam1 = parametr_1;
1035 params.tparam2 = parametr_2;
1036 return find_or_add_t_multiparametred(sql_select_statment, sql_insert_statment, id, new_object_added, params, c);
1037 }
Here is the call graph for this function:

◆ find_or_add_t() [3/4]

template<typename TParam1, typename TParam2, typename TParam3, typename default_id_type, typename t_conn>
bool epee::ado_db_helper::find_or_add_t ( const std::string & sql_select_statment,
const std::string & sql_insert_statment,
OUT default_id_type & id,
OUT bool & new_object_added,
TParam1 parametr_1,
TParam2 parametr_2,
TParam3 parametr_3,
t_conn & c )

Definition at line 1041 of file ado_db_helper.h.

1042 {
1044 params.tparam1 = parametr_1;
1045 params.tparam2 = parametr_2;
1046 params.tparam3 = parametr_3;
1047 return find_or_add_t_multiparametred(sql_select_statment, sql_insert_statment, id, new_object_added, params, c);
1048 }
Here is the call graph for this function:

◆ find_or_add_t() [4/4]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename default_id_type, typename t_conn>
bool epee::ado_db_helper::find_or_add_t ( const std::string & sql_select_statment,
const std::string & sql_insert_statment,
OUT default_id_type & id,
OUT bool & new_object_added,
TParam1 parametr_1,
TParam2 parametr_2,
TParam3 parametr_3,
TParam4 parametr_4,
t_conn & c )

Definition at line 1051 of file ado_db_helper.h.

1052 {
1054 params.tparam1 = parametr_1;
1055 params.tparam2 = parametr_2;
1056 params.tparam3 = parametr_3;
1057 params.tparam4 = parametr_4;
1058 return find_or_add_t_multiparametred(sql_select_statment, sql_insert_statment, id, new_object_added, params, c);
1059 }
Here is the call graph for this function:

◆ find_or_add_t_multiparametred()

template<typename TParams, typename default_id_type, typename t_conn>
bool epee::ado_db_helper::find_or_add_t_multiparametred ( const std::string & sql_select_statment,
const std::string & sql_insert_statment,
OUT default_id_type & id,
OUT bool & new_object_added,
TParams params,
t_conn & c )

Definition at line 1062 of file ado_db_helper.h.

1063 {
1064
1065 //CHECK_CONNECTION(false);
1066
1067 new_object_added = false;
1068 ado_db_helper::table result_table;
1069
1070 bool res = select_helper_multiparam(c.get_db_connection(), sql_select_statment, params, result_table);
1071 if(!result_table.size())
1072 {
1073 res = select_helper_multiparam(c.get_db_connection(), sql_insert_statment, params, result_table);
1074 if(!res || !result_table.size())
1075 {
1076 //last time try to select
1077 res = select_helper_multiparam(c.get_db_connection(), sql_select_statment, params, result_table);
1078 CHECK_AND_ASSERT_MES(res, false, "Failed to execute statment: " << sql_select_statment);
1079 CHECK_AND_ASSERT_MES(result_table.size(), false, "No records returned from statment: " << sql_select_statment);
1080 }else
1081 {
1082 new_object_added = true;
1083 }
1084 }
1085
1087 id = result_table[0][0];
1088 CATCH_TRY_SECTION_MESS(false, "while converting returned value [find_or_add_t_multiparametred()]");
1089
1090 return true;
1091 }
#define CHECK_AND_ASSERT_MES(expr, fail_ret_val, message)
std::vector< std::vector< _variant_t > > table
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
#define true
#define false
Here is the call graph for this function:
Here is the caller graph for this function:

◆ flush_profiler()

bool epee::ado_db_helper::flush_profiler ( const std::string path)
inline

Definition at line 179 of file ado_db_helper.h.

180 {
182 //get_set_profiler(false, &pmanager);
183 if(pmanager)
184 return pmanager->flush_log(path);
185 return true;
186 }
bool flush_log(const std::string &path)
Here is the call graph for this function:

◆ get_set_profiler()

profiler_manager * epee::ado_db_helper::get_set_profiler ( bool need_to_set = false,
profiler_manager ** pprofiler = NULL )
inline

Definition at line 144 of file ado_db_helper.h.

145 {
146 static profiler_manager* pmanager = NULL;
147 if(need_to_set)
148 pmanager = *pprofiler;
149 //else
150 // *pprofiler = pmanager;
151
152 return pmanager;
153 }
Here is the caller graph for this function:

◆ get_str_param() [1/2]

template<typename TParam>
std::string epee::ado_db_helper::get_str_param ( const std::list< TParam > & prm_lst)

Definition at line 630 of file ado_db_helper.h.

631 {
632 std::stringstream strm;
633 for(std::list<TParam>::const_iterator it = prm_lst.begin();it!=prm_lst.end();it++)
634 strm << get_str_param(*it) << ", ";
635 return strm.str();
636 }
std::string get_str_param(const TParam &prm)
Here is the call graph for this function:

◆ get_str_param() [2/2]

template<typename TParam>
std::string epee::ado_db_helper::get_str_param ( const TParam & prm)

Definition at line 622 of file ado_db_helper.h.

623 {
624 std::stringstream strm;
625 strm << prm;
626 return strm.str();
627 }
Here is the caller graph for this function:

◆ init()

bool epee::ado_db_helper::init ( )
inline

Definition at line 155 of file ado_db_helper.h.

156 {
157 profiler_manager* pmanager = new profiler_manager();
158 get_set_profiler(true, &pmanager);
159 return true;
160 }
Here is the call graph for this function:

◆ print_parameters_multi() [1/9]

template<typename TParam1, typename TParam2>
std::string epee::ado_db_helper::print_parameters_multi ( const adapter_double< TParam1, TParam2 > & params)

Definition at line 640 of file ado_db_helper.h.

641 {
642 std::stringstream strm;
643 strm << get_str_param(params.tparam1) << ", " << get_str_param(params.tparam2);
644 return strm.str();
645 }
Here is the call graph for this function:

◆ print_parameters_multi() [2/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7, typename TParam8, typename TParam9>
std::string epee::ado_db_helper::print_parameters_multi ( const adapter_nine< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7, TParam8, TParam9 > & params)

Definition at line 581 of file ado_db_helper.h.

582 {
583 std::stringstream strm;
584 strm << params.tparam1 << ", " << params.tparam2 << ", " << params.tparam3 << ", " << params.tparam4 << ", " << params.tparam5 << ", " << params.tparam6 << ", " << params.tparam7 << ", " << params.tparam8 << ", " << params.tparam9;
585 return strm.str();
586 }

◆ print_parameters_multi() [3/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4>
std::string epee::ado_db_helper::print_parameters_multi ( const adapter_quad< TParam1, TParam2, TParam3, TParam4 > & params)

Definition at line 606 of file ado_db_helper.h.

607 {
608 std::stringstream strm;
609 strm << params.tparam1 << ", " << params.tparam2 << ", " << params.tparam3 << ", " << params.tparam4;
610 return strm.str();
611 }

◆ print_parameters_multi() [4/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5>
std::string epee::ado_db_helper::print_parameters_multi ( const adapter_quanto< TParam1, TParam2, TParam3, TParam4, TParam5 > & params)

Definition at line 597 of file ado_db_helper.h.

598 {
599 std::stringstream strm;
600 strm << params.tparam1 << ", " << params.tparam2 << ", " << params.tparam3 << ", " << params.tparam4 << ", " << params.tparam5;
601 return strm.str();
602 }

◆ print_parameters_multi() [5/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7>
std::string epee::ado_db_helper::print_parameters_multi ( const adapter_sevento< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7 > & params)

Definition at line 573 of file ado_db_helper.h.

574 {
575 std::stringstream strm;
576 strm << params.tparam1 << ", " << params.tparam2 << ", " << params.tparam3 << ", " << params.tparam4 << ", " << params.tparam5 << ", " << params.tparam6 << ", " << params.tparam7;
577 return strm.str();
578 }
Here is the caller graph for this function:

◆ print_parameters_multi() [6/9]

template<typename TParam1>
std::string epee::ado_db_helper::print_parameters_multi ( const adapter_single< TParam1 > & params)

Definition at line 648 of file ado_db_helper.h.

649 {
650 std::stringstream strm;
651 strm << get_str_param(params.tparam1);
652 return strm.str();
653 }
Here is the call graph for this function:

◆ print_parameters_multi() [7/9]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6>
std::string epee::ado_db_helper::print_parameters_multi ( const adapter_sixto< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6 > & params)

Definition at line 589 of file ado_db_helper.h.

590 {
591 std::stringstream strm;
592 strm << params.tparam1 << ", " << params.tparam2 << ", " << params.tparam3 << ", " << params.tparam4 << ", " << params.tparam5 << ", " << params.tparam6;
593 return strm.str();
594 }

◆ print_parameters_multi() [8/9]

template<typename TParam1, typename TParam2, typename TParam3>
std::string epee::ado_db_helper::print_parameters_multi ( const adapter_triple< TParam1, TParam2, TParam3 > & params)

Definition at line 614 of file ado_db_helper.h.

615 {
616 std::stringstream strm;
617 strm << params.tparam1 << ", " << params.tparam2 << ", " << params.tparam3;
618 return strm.str();
619 }

◆ print_parameters_multi() [9/9]

template<typename TParam1>
std::string epee::ado_db_helper::print_parameters_multi ( const adapter_zero< TParam1 > & params)

Definition at line 656 of file ado_db_helper.h.

657 {
658 std::stringstream strm;
659 strm << "(no parametrs)";
660 return strm.str();
661 }

◆ push_timing()

bool epee::ado_db_helper::push_timing ( const std::string sql,
DWORD time )
inline

Definition at line 170 of file ado_db_helper.h.

171 {
173 //get_set_profiler(false, &pmanager);
174 if(pmanager)
175 return pmanager->push_entry(sql, time);
176 return true;
177 }
time_t time
bool push_entry(const std::string sql, DWORD time)
Here is the call graph for this function:
Here is the caller graph for this function:

◆ select_helper() [1/10]

bool epee::ado_db_helper::select_helper ( ADODB::_CommandPtr cmd,
table & result_vector )
inline

Definition at line 356 of file ado_db_helper.h.

357 {
358 result_vector.clear();
359 //BEGIN_TRY_SECTION();
360
361 ADODB::_RecordsetPtr precordset = cmd->Execute(NULL, NULL, NULL);
362 if(!precordset)
363 {
364 LOG_ERROR("DB_ERROR: cmd->Execute returned NULL!!!");
365 return false;
366 }
367
368 //if(precordset->EndOfFile == EOF)
369 //{
370 // return true;
371 //}
372 /*try
373 {
374 if(precordset->MoveFirst()!= S_OK)
375 {
376 LOG_ERROR("DB_ERROR: Filed to move first!!!");
377 return false;
378 }
379 }
380 catch (...)
381 {
382 return true;
383 }*/
384
385 size_t current_record_index = 0;
386 while(precordset->EndOfFile != EOF)
387 {
388 result_vector.push_back(table::value_type());
389 size_t fields_count = precordset->Fields->Count;
390 result_vector[current_record_index].resize(fields_count);
391 for(size_t current_field_index = 0; current_field_index < fields_count; current_field_index++)
392 {
393 _variant_t var;
394 var.ChangeType(VT_I2);
395 var.intVal = static_cast<INT>(current_field_index);
396 result_vector[current_record_index][current_field_index] = precordset->Fields->GetItem(var)->Value;
397 }
398 precordset->MoveNext();
399 current_record_index++;
400 }
401 //CATCH_TRY_SECTION(false);
402 return true;
403 }
#define LOG_ERROR(x)
Definition misc_log_ex.h:98
Here is the caller graph for this function:

◆ select_helper() [2/10]

template<typename TParam>
bool epee::ado_db_helper::select_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam & parametr,
table & result_vector )

Definition at line 829 of file ado_db_helper.h.

830 {
832 params.tparam1 = parametr;
833 return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
834 }
Here is the call graph for this function:

◆ select_helper() [3/10]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7, typename TParam8, typename TParam9>
bool epee::ado_db_helper::select_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 parametr1,
const TParam2 parametr2,
const TParam3 parametr3,
const TParam4 parametr4,
const TParam5 parametr5,
const TParam6 parametr6,
const TParam7 parametr7,
const TParam8 parametr8,
const TParam9 parametr9,
table & result_vector )

Definition at line 909 of file ado_db_helper.h.

910 {
912 params.tparam1 = parametr1;
913 params.tparam2 = parametr2;
914 params.tparam3 = parametr3;
915 params.tparam4 = parametr4;
916 params.tparam5 = parametr5;
917 params.tparam6 = parametr6;
918 params.tparam7 = parametr7;
919 params.tparam8 = parametr8;
920 params.tparam9 = parametr9;
921 return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
922 }
Here is the call graph for this function:

◆ select_helper() [4/10]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6, typename TParam7>
bool epee::ado_db_helper::select_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 parametr1,
const TParam2 parametr2,
const TParam3 parametr3,
const TParam4 parametr4,
const TParam5 parametr5,
const TParam6 parametr6,
const TParam7 parametr7,
table & result_vector )

Definition at line 895 of file ado_db_helper.h.

896 {
898 params.tparam1 = parametr1;
899 params.tparam2 = parametr2;
900 params.tparam3 = parametr3;
901 params.tparam4 = parametr4;
902 params.tparam5 = parametr5;
903 params.tparam6 = parametr6;
904 params.tparam7 = parametr7;
905 return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
906 }
Here is the call graph for this function:

◆ select_helper() [5/10]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5, typename TParam6>
bool epee::ado_db_helper::select_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 parametr1,
const TParam2 parametr2,
const TParam3 parametr3,
const TParam4 parametr4,
const TParam5 parametr5,
const TParam6 parametr6,
table & result_vector )

Definition at line 882 of file ado_db_helper.h.

883 {
885 params.tparam1 = parametr1;
886 params.tparam2 = parametr2;
887 params.tparam3 = parametr3;
888 params.tparam4 = parametr4;
889 params.tparam5 = parametr5;
890 params.tparam6 = parametr6;
891 return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
892 }
Here is the call graph for this function:

◆ select_helper() [6/10]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4, typename TParam5>
bool epee::ado_db_helper::select_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 parametr1,
const TParam2 parametr2,
const TParam3 parametr3,
const TParam4 parametr4,
const TParam5 parametr5,
table & result_vector )

Definition at line 869 of file ado_db_helper.h.

870 {
872 params.tparam1 = parametr1;
873 params.tparam2 = parametr2;
874 params.tparam3 = parametr3;
875 params.tparam4 = parametr4;
876 params.tparam5 = parametr5;
877 return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
878 }
Here is the call graph for this function:

◆ select_helper() [7/10]

template<typename TParam1, typename TParam2, typename TParam3, typename TParam4>
bool epee::ado_db_helper::select_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 parametr1,
const TParam2 parametr2,
const TParam3 parametr3,
const TParam4 parametr4,
table & result_vector )

Definition at line 858 of file ado_db_helper.h.

859 {
861 params.tparam1 = parametr1;
862 params.tparam2 = parametr2;
863 params.tparam3 = parametr3;
864 params.tparam4 = parametr4;
865 return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
866 }
Here is the call graph for this function:

◆ select_helper() [8/10]

template<typename TParam1, typename TParam2, typename TParam3>
bool epee::ado_db_helper::select_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 parametr1,
const TParam2 parametr2,
const TParam3 parametr3,
table & result_vector )

Definition at line 847 of file ado_db_helper.h.

848 {
850 params.tparam1 = parametr1;
851 params.tparam2 = parametr2;
852 params.tparam3 = parametr3;
853 return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
854
855 }
Here is the call graph for this function:

◆ select_helper() [9/10]

template<typename TParam1, typename TParam2>
bool epee::ado_db_helper::select_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParam1 parametr1,
const TParam2 parametr2,
table & result_vector )

Definition at line 837 of file ado_db_helper.h.

838 {
840 params.tparam1 = parametr1;
841 params.tparam2 = parametr2;
842 return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
843
844 }
Here is the call graph for this function:

◆ select_helper() [10/10]

bool epee::ado_db_helper::select_helper ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
table & result_vector )
inline

Definition at line 821 of file ado_db_helper.h.

822 {
823 adapter_zero<int> params;
824 return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
825 }
Here is the call graph for this function:

◆ select_helper_multiparam()

template<typename TParams>
bool epee::ado_db_helper::select_helper_multiparam ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParams & parametrs,
table & result_vector )
inline

Definition at line 688 of file ado_db_helper.h.

689 {
690 PROFILE_SQL(sql_statment);
691 bool res = false;
693 ADODB::_CommandPtr cmd;
694 cmd.CreateInstance(__uuidof(ADODB::Command));
695 cmd->CommandText = _bstr_t(sql_statment.c_str());
696
697
698 if(!add_parametrs_multi(cmd, parametrs))
699 return false;
700
701 cmd->ActiveConnection = pconnection;
702 res = select_helper(cmd, result_vector);
703 CATCH_TRY_SECTION_MESS(false, "while statment: " << sql_statment << " [params]: " << print_parameters_multi(parametrs));
704 return res;
705 }
bool select_helper(ADODB::_CommandPtr cmd, table &result_vector)
Here is the call graph for this function:
Here is the caller graph for this function:

◆ select_helper_param_container()

template<typename TParams>
bool epee::ado_db_helper::select_helper_param_container ( ADODB::_ConnectionPtr pconnection,
const std::string & sql_statment,
const TParams & parametrs,
table & result_vector )
inline

Definition at line 710 of file ado_db_helper.h.

711 {
712 PROFILE_SQL(sql_statment);
713 bool res = false;
715 ADODB::_CommandPtr cmd;
716 cmd.CreateInstance(__uuidof(ADODB::Command));
717 cmd->CommandText = _bstr_t(sql_statment.c_str());
718
719
720 for(TParams::const_iterator it = parametrs.begin(); it!=parametrs.end(); it++)
721 {
722 add_parametr(cmd, *it);
723 }
724
725 cmd->ActiveConnection = pconnection;
726 res = select_helper(cmd, result_vector);
727
728 CATCH_TRY_SECTION(false);
729 return res;
730 }
#define CATCH_TRY_SECTION(ret_val)
Here is the call graph for this function: