Functions
template<typename ValueType >
bool	extractValue (ValueType , sqlite3_stmt , int)
	Extracts a specific value from an SQL column. More...

template<>
bool	extractValue< double > (double dst, sqlite3_stmt stmt, int pos)

template<>
bool	extractValue< int > (int dst, sqlite3_stmt stmt, int pos)

template<>
bool	extractValue< String > (String dst, sqlite3_stmt stmt, int pos)

template<>
bool	extractValue< std::string > (std::string dst, sqlite3_stmt stmt, int pos)

bool	extractValueIntStr (String dst, sqlite3_stmt stmt, int pos)
	Special case where an integer should be stored in a String field. More...

Function Documentation

◆ extractValue()

bool OpenMS::Internal::SqliteHelper::extractValue	(	ValueType *	,
		sqlite3_stmt *	,
		int
	)

Extracts a specific value from an SQL column.

dst Destination (where to store the value) stmt Sqlite statement object pos Column position

For example, to extract a specific integer from column 5 of an SQL statement, one can use:

sqlite3_stmt* stmt; sqlite3* db; SqliteConnector::prepareStatement(db, &stmt, select_sql); sqlite3_step(stmt);

double target; while (sqlite3_column_type(stmt, 0) != SQLITE_NULL) { extractValue<double>(&target, stmt, 5); sqlite3_step( stmt ); } sqlite3_finalize(stmt);

◆ extractValue< double >()

bool OpenMS::Internal::SqliteHelper::extractValue< double >	(	double *	dst,
		sqlite3_stmt *	stmt,
		int	pos
	)

◆ extractValue< int >()

bool OpenMS::Internal::SqliteHelper::extractValue< int >	(	int *	dst,
		sqlite3_stmt *	stmt,
		int	pos
	)

◆ extractValue< std::string >()

bool OpenMS::Internal::SqliteHelper::extractValue< std::string >	(	std::string *	dst,
		sqlite3_stmt *	stmt,
		int	pos
	)

◆ extractValue< String >()

bool OpenMS::Internal::SqliteHelper::extractValue< String >	(	String *	dst,
		sqlite3_stmt *	stmt,
		int	pos
	)

◆ extractValueIntStr()

bool OpenMS::Internal::SqliteHelper::extractValueIntStr	(	String *	dst,
		sqlite3_stmt *	stmt,
		int	pos
	)

Special case where an integer should be stored in a String field.