8 #include <vrfMsgTransport/vrfDatabaseEventParam.inl>
57 #include <vrfMsgTransport/vrfDatabaseSqlUtils.inl>
std::string sqlCreationString(const DtVrfDatabaseEventParam &p)
Creates a string to be used by sqlCreateTableQuery() when constructing a table to specify the correct...
std::vector< DtVrfDatabaseEventUniquePtr > DtVrfDatabaseEventVector
Definition: vrfDatabaseEvent.h:183
std::string sqlUpdateQuery(const DtVrfDatabaseEvent &event)
Creates an SQL query to update an existing database event in the appropriate table. Requires the event to have at least one parameter designated as a primary key.
std::string sqlName(const DtVrfDatabaseEventParam &p)
Creates a string to be used by an insert query when inserting an event to specify the correct name fo...
std::string sqliteInsertUpdateQuery(const DtVrfDatabaseEventVector &event)
Creates an SQLite query to insert multiple database events into the appropriate table, updating the existing entry on conflicts. NOTE: Only works if all events have the same event type!
std::string sqliteInsertIgnoreQuery(const DtVrfDatabaseEventVector &events)
Creates an SQLite query to insert multiple database events into the appropriate table, ignoring errors on conflicts. NOTE: Only works if all events have the same event type!
Abstract base class to store the parameter for a DtVrfDatabaseEvent.
Definition: vrfDatabaseEventParam.h:11
std::string mySqlInsertIgnoreQuery(const DtVrfDatabaseEventVector &event)
Creates a MySQL query to insert multiple database events into the appropriate table, ignoring errors on conflicts. NOTE: Only works if all events have the same event type!
std::string sqlExcludedSet(const DtVrfDatabaseEventParam &p)
Creates a string to be used by an insert query needs to update a parameter when a duplicate entry is ...
std::string mySqlInsertUpdateQuery(const DtVrfDatabaseEventVector &event)
Creates a MySQL query to insert multiple database events into the appropriate table, updating the existing entry on conflicts. NOTE: Only works if all events have the same event type!
std::string sqlValue(const DtVrfDatabaseEventParam &p)
Creates a string to be used by an insert query when inserting an event to specify the correct value f...
Represents a single event to be recorded in the database. Anytime something occurs that requires data...
Definition: vrfDatabaseEvent.h:22
std::string sqlCreateTableQuery(const DtVrfDatabaseEvent &event)
Provides functions to turn a DtVrfDatabaseEvent and it's parameters into an SQL query.
