vrfDatabaseSqlUtils.h File Reference

Go to the source code of this file.

Functions
std::string	sqlCreateTableQuery (const DtVrfDatabaseEvent &event)
std::string	sqliteInsertIgnoreQuery (const DtVrfDatabaseEventVector &events)
std::string	mySqlInsertIgnoreQuery (const DtVrfDatabaseEventVector &event)
std::string	sqliteInsertUpdateQuery (const DtVrfDatabaseEventVector &event)
std::string	mySqlInsertUpdateQuery (const DtVrfDatabaseEventVector &event)
std::string	sqlUpdateQuery (const DtVrfDatabaseEvent &event)
std::string	sqlCreationString (const DtVrfDatabaseEventParam &p)
std::string	sqlName (const DtVrfDatabaseEventParam &p)
std::string	sqlValue (const DtVrfDatabaseEventParam &p)
std::string	sqlExcludedSet (const DtVrfDatabaseEventParam &p)

Function Documentation

std::string sqlCreateTableQuery ( const DtVrfDatabaseEvent &  event )

inline

Provides functions to turn a DtVrfDatabaseEvent and it's parameters into an SQL query.

Creates an SQL query to create a table to hold events of this type.

std::string sqliteInsertIgnoreQuery ( const DtVrfDatabaseEventVector &  events )

inline

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!

std::string mySqlInsertIgnoreQuery ( const DtVrfDatabaseEventVector &  event )

inline

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 sqliteInsertUpdateQuery ( const DtVrfDatabaseEventVector &  event )

inline

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 mySqlInsertUpdateQuery ( const DtVrfDatabaseEventVector &  event )

inline

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 sqlUpdateQuery ( const DtVrfDatabaseEvent &  event )

inline

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 sqlCreationString ( const DtVrfDatabaseEventParam &  p )

inline

Creates a string to be used by sqlCreateTableQuery() when constructing a table to specify the correct name and type for the given parameter.

std::string sqlName ( const DtVrfDatabaseEventParam &  p )

inline

Creates a string to be used by an insert query when inserting an event to specify the correct name for the given parameter.

std::string sqlValue ( const DtVrfDatabaseEventParam &  p )

inline

Creates a string to be used by an insert query when inserting an event to specify the correct value for the given parameter.

std::string sqlExcludedSet ( const DtVrfDatabaseEventParam &  p )

inline

Creates a string to be used by an insert query needs to update a parameter when a duplicate entry is found.