vrfDatabaseSqlUtils.h

Go to the documentation of this file.

/*******************************************************************************
** Copyright (c) 2024 MAK Technologies, Inc.
** All rights reserved.
*******************************************************************************/
#pragma once

#include <vrfMsgTransport/vrfMsgTransportDefines.h>
#include <vrfMsgTransport/vrfDatabaseEventParam.inl>
#include <vrfMsgTransport/vrfDatabaseEvent.h>

class DT_DLL_vrfMsgTransport DtSqlUtils
{
public:
   static inline std::string createTableStatement(const DtVrfDatabaseEvent& event);

   static inline std::string sqliteInsertIgnoreStatement(const DtVrfDatabaseEventVector& events);

   static inline std::string mySqlInsertIgnoreStatement(const DtVrfDatabaseEventVector& event);

   static inline std::string sqliteInsertUpdateStatement(const DtVrfDatabaseEventVector& event);

   static inline std::string mySqlInsertUpdateStatement(const DtVrfDatabaseEventVector& event);

   static inline std::string updateStatement(const DtVrfDatabaseEvent& event);

protected:

   static inline std::string creationString(const DtVrfDatabaseEventParam& p);

   static inline std::string parameterNameString(const DtVrfDatabaseEventParam& p);

   static inline std::string parameterValueString(const DtVrfDatabaseEventParam& p);

   static inline std::string excludedSetString(const DtVrfDatabaseEventParam& p);

   static inline bool appendTableName(DtVrfDatabaseEvent::EventType et, std::string& qry);
   static inline bool appendParameterNames(const DtVrfDatabaseEvent::ParamVector& params, std::string& qry);
   static inline bool appendParameterValues(const DtVrfDatabaseEvent::ParamVector& params, std::string& qry);
   static inline bool appendParameterSetExcluded(const DtVrfDatabaseEvent::ParamVector& params, std::string& qry);

};




#include <vrfMsgTransport/vrfDatabaseSqlUtils.inl>