how to exec sql << support dynamic variable params

[stan1334]

template<class ... Args>
inline void execSql(soci::session & sql, const std::string & strSql, Args &&...args) {
	try {
		if (0 < sizeof...(args))
			//sql << strSql, args...; ？？？
			int a = 10;
		else
			sql << strSql;
	}
	catch (soci_error const& e) {
		VLOG_E("HDCommon", "execSql what is {}", e.what());
	}

	VLOG_D("HDCommon", "execSql {} over", strSql);
}

#define SOCI_EXEC(sql, strSql, ...) execSql(sql, strSql, VA_ARGS)

SOCI_EXEC(sql, SELECT_MAX_EVENTID_SQL, into(maxEventID));
SOCI_EXEC(sql, SELECT_MAX_EVENTID_SQL, into(maxEventID), use(111));
SOCI_EXEC(sql, SELECT_MAX_EVENTID_SQL, into(maxEventID), into(test222), use(test111) );

//sql << strSql, args...; ？？？

// even more sugar
template <typename T>
details::once_temp_type operator<<(T const & t) { return once << t; }

how to support ... Args for session operator <<

@mloskot
@tt4g

[stan1334]

#pragma once
#ifndef EXECSQL_H
#define EXECSQL_H
#include "HDCommon.h"
#include "Public/Macro_Def.h"
#include "HSessionMgr.h"

namespace HDCommon {
HDCOMMON_EXPORT void getTempType(soci::details::once_temp_type& temp);

template <typename T>
void getTempType(soci::details::once_temp_type& temp, const T& t) {
	temp, t;
}

template <typename T, typename...Args>
void getTempType(soci::details::once_temp_type& temp, const T& t, const Args&...rest) {
	temp, t;
	getTempType(temp, rest...);       // 递归调用
}

template <class ...Args>
void execsql(soci::session& sql, const std::string& strSql, Args &&...args) {
	int nlen = sizeof...(args);

	if (0 < nlen) {
		soci::details::once_temp_type temp(sql);
		getTempType(temp, args...);
		sql << strSql, temp;
	}
	else
		sql << strSql;
}

template <class ...Args>
void execsqlByType(const SqlSessionType& sqlSessionType, const std::string& strSql, Args &&...args) {
	SqlSessionPool sqlSessionPool;
	HDCommon::HSessionMgr::instance()->getSessionPool(sqlSessionType, sqlSessionPool);
	connection_pool& pool = *(connection_pool*)sqlSessionPool.pPool;
	session sql(pool);

	try {
		execsql(sql, strSql, args...);
	}
	catch (soci_error const& e) {
		VLOG_E("HDCommon", "execSql Failed sqlStr is {}, what is {}, dbname is {}",
			strSql, e.what(), sqlSessionPool.dbName);
	}

	VLOG_I("HDCommon", "execSql Success sqlStr is {}, dbname is {}",
		strSql, sqlSessionPool.dbName);
}

#define EXEC_SQL(sql, strSql, ...) HDCommon::execsql(sql, strSql, VA_ARGS)
#define EXEC_SQL_BY_SESSIONTYPE(sqlSessionType, strSql, ...) HDCommon::execsqlByType(sqlSessionType, strSql, VA_ARGS)

};
#endif

I think this part can be encapsulated into the soci as a database dao layer, what do you think of the experts。
@mloskot
@tt4g