Electroneum
epee::ado_db_helper Namespace Reference

Classes

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

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, _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/10]

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() [2/10]

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() [3/10]

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/10]

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() [5/10]

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/10]

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() [7/10]

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() [8/10]

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() [9/10]

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 DATE parametr)
Here is the call graph for this function:

◆ add_parametr() [10/10]

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_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 >
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:

◆ add_parametrs_multi() [2/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  }
bool add_parametr(ADODB::_CommandPtr cmd, const DATE parametr)
Here is the call graph for this function:

◆ add_parametrs_multi() [3/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  }
bool add_parametr(ADODB::_CommandPtr cmd, const DATE parametr)
Here is the call graph for this function:

◆ add_parametrs_multi() [4/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  }
bool add_parametr(ADODB::_CommandPtr cmd, const DATE parametr)
Here is the call graph for this function:

◆ add_parametrs_multi() [5/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  }
bool add_parametr(ADODB::_CommandPtr cmd, const DATE parametr)
Here is the call graph for this function:

◆ add_parametrs_multi() [6/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  }
bool add_parametr(ADODB::_CommandPtr cmd, const DATE parametr)
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  }
bool add_parametr(ADODB::_CommandPtr cmd, const DATE parametr)
Here is the call graph for this function:

◆ add_parametrs_multi() [8/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  }
bool add_parametr(ADODB::_CommandPtr cmd, const DATE parametr)
Here is the call graph for this function:

◆ add_parametrs_multi() [9/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  }
bool add_parametr(ADODB::_CommandPtr cmd, const DATE parametr)
Here is the call graph for this function:

◆ deinit()

bool epee::ado_db_helper::deinit ( )
inline

Definition at line 162 of file ado_db_helper.h.

163  {
164  profiler_manager* pmanager = get_set_profiler();
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:
Here is the caller 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  {
743  adapter_single<TParam> params;
744  params.tparam1 = parametr;
745  return execute_helper_multiparam(pconnection, sql_statment, params);
746  }
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() [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  {
752  adapter_double<TParam1, TParam2> params;
753  params.tparam1 = parametr1;
754  params.tparam2 = parametr2;
755  return execute_helper_multiparam(pconnection, sql_statment, params);
756 
757  }
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() [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  {
762  adapter_triple<TParam1, TParam2, typename TParam3> params;
763  params.tparam1 = parametr1;
764  params.tparam2 = parametr2;
765  params.tparam3 = parametr3;
766  return execute_helper_multiparam(pconnection, sql_statment, params);
767  }
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() [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  {
772  adapter_quad<TParam1, TParam2, TParam3, TParam4> params;
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  }
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() [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  {
783  adapter_quanto<TParam1, TParam2, TParam3, TParam4, TParam5> params;
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  }
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() [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  {
795  adapter_sixto<TParam1, TParam2, TParam3, TParam4, TParam5, TParam6> params;
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  }
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() [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  {
809  adapter_sevento<TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7> params;
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  }
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_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  }
const char * res
Definition: hmac_keccak.cpp:41
std::string print_parameters_multi(const adapter_zero< TParam1 > &params)
#define BEGIN_TRY_SECTION()
Definition: ado_db_helper.h:40
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)
#define CATCH_TRY_SECTION_MESS(ret_val, mess_where)
Definition: ado_db_helper.h:44
#define PROFILE_SQL(sql)
bool add_parametrs_multi(ADODB::_CommandPtr cmd, const adapter_nine< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7, TParam8, TParam9 > &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  {
1024  ado_db_helper::adapter_single<TParam1> params;
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  {
1033  ado_db_helper::adapter_double<TParam1, TParam2> params;
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  }
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() [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  {
1043  ado_db_helper::adapter_triple<TParam1, TParam2, TParam3> params;
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  }
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() [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  {
1053  ado_db_helper::adapter_quad<TParam1, TParam2, TParam3, TParam4> params;
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  }
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_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  }
const char * res
Definition: hmac_keccak.cpp:41
std::vector< std::vector< _variant_t > > table
#define CHECK_AND_ASSERT_MES(expr, fail_ret_val, message)
Definition: misc_log_ex.h:181
#define BEGIN_TRY_SECTION()
Definition: ado_db_helper.h:40
return true
#define CATCH_TRY_SECTION_MESS(ret_val, mess_where)
Definition: ado_db_helper.h:44
#define false
Definition: stdbool.h:38
const GenericPointer< typename T::ValueType > T2 value
Definition: pointer.h:1225
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)
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
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  {
181  profiler_manager* pmanager = get_set_profiler();
182  //get_set_profiler(false, &pmanager);
183  if(pmanager)
184  return pmanager->flush_log(path);
185  return true;
186  }
profiler_manager * get_set_profiler(bool need_to_set=false, profiler_manager **pprofiler=NULL)
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 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:

◆ get_str_param() [2/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 std::list< TParam > &prm_lst)
Here is the call 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  }
profiler_manager * get_set_profiler(bool need_to_set=false, profiler_manager **pprofiler=NULL)
Here is the call graph for this function:
Here is the caller graph for this function:

◆ print_parameters_multi() [1/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() [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 , 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() [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 >
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() [6/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() [7/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  }
std::string get_str_param(const std::list< TParam > &prm_lst)
Here is the call graph for this function:

◆ print_parameters_multi() [8/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  }
std::string get_str_param(const std::list< TParam > &prm_lst)
Here is the call graph for this function:

◆ 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  {
172  profiler_manager* pmanager = get_set_profiler();
173  //get_set_profiler(false, &pmanager);
174  if(pmanager)
175  return pmanager->push_entry(sql, time);
176  return true;
177  }
profiler_manager * get_set_profiler(bool need_to_set=false, profiler_manager **pprofiler=NULL)
time_t time
Definition: blockchain.cpp:93
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]

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  }
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
Here is the call graph for this function:

◆ select_helper() [3/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  {
831  adapter_single<TParam> params;
832  params.tparam1 = parametr;
833  return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
834  }
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
Here is the call graph for this function:

◆ select_helper() [4/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  {
839  adapter_double<TParam1, TParam2> params;
840  params.tparam1 = parametr1;
841  params.tparam2 = parametr2;
842  return select_helper_multiparam(pconnection, sql_statment, params, result_vector);
843 
844  }
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
Here is the call graph for this function:

◆ select_helper() [5/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  {
849  adapter_triple<TParam1, TParam2, typename TParam3> params;
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  }
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
Here is the call graph for this function:

◆ select_helper() [6/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  {
860  adapter_quad<TParam1, TParam2, TParam3, TParam4> params;
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  }
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
Here is the call graph for this function:

◆ select_helper() [7/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  {
871  adapter_quanto<TParam1, TParam2, TParam3, TParam4, TParam5> params;
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  }
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
Here is the call graph for this function:

◆ select_helper() [8/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  {
884  adapter_sixto<TParam1, TParam2, TParam3, TParam4, TParam5, TParam6> params;
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  }
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
Here is the call graph for this function:

◆ select_helper() [9/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  {
897  adapter_sevento<TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7> params;
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  }
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
Here is the call graph for this function:

◆ select_helper() [10/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  {
911  adapter_nine<TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7, TParam8, TParam9> params;
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  }
bool select_helper_multiparam(ADODB::_ConnectionPtr pconnection, const std::string &sql_statment, const TParams &parametrs, table &result_vector)
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  }
const char * res
Definition: hmac_keccak.cpp:41
std::string print_parameters_multi(const adapter_zero< TParam1 > &params)
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)
#define BEGIN_TRY_SECTION()
Definition: ado_db_helper.h:40
#define CATCH_TRY_SECTION_MESS(ret_val, mess_where)
Definition: ado_db_helper.h:44
#define PROFILE_SQL(sql)
bool add_parametrs_multi(ADODB::_CommandPtr cmd, const adapter_nine< TParam1, TParam2, TParam3, TParam4, TParam5, TParam6, TParam7, TParam8, TParam9 > &params)
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  }
const char * res
Definition: hmac_keccak.cpp:41
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)
#define BEGIN_TRY_SECTION()
Definition: ado_db_helper.h:40
#define PROFILE_SQL(sql)
bool add_parametr(ADODB::_CommandPtr cmd, const DATE parametr)
#define CATCH_TRY_SECTION(ret_val)
Definition: ado_db_helper.h:42
Here is the call graph for this function: