MySQLPreparedStatement Class Reference

#include <PreparedStatement.h>

Public Member Functions
	MySQLPreparedStatement (MYSQL_STMT *stmt)
	~MySQLPreparedStatement ()
void	setBool (const uint8 index, const bool value)
void	setUInt8 (const uint8 index, const uint8 value)
void	setUInt16 (const uint8 index, const uint16 value)
void	setUInt32 (const uint8 index, const uint32 value)
void	setUInt64 (const uint8 index, const uint64 value)
void	setInt8 (const uint8 index, const int8 value)
void	setInt16 (const uint8 index, const int16 value)
void	setInt32 (const uint8 index, const int32 value)
void	setInt64 (const uint8 index, const int64 value)
void	setFloat (const uint8 index, const float value)
void	setDouble (const uint8 index, const double value)
void	setBinary (const uint8 index, const std::vector< uint8 > &value, bool isString)
void	setNull (const uint8 index)

Protected Member Functions
MYSQL_STMT *	GetSTMT ()
MYSQL_BIND *	GetBind ()
void	ClearParameters ()
bool	CheckValidIndex (uint8 index)
std::string	getQueryString (std::string const &sqlPattern) const

Protected Attributes
PreparedStatement *	m_stmt

Private Member Functions
void	setValue (MYSQL_BIND *param, enum_field_types type, const void *value, uint32 len, bool isUnsigned)
	MySQLPreparedStatement (MySQLPreparedStatement const &right)=delete
MySQLPreparedStatement &	operator= (MySQLPreparedStatement const &right)=delete

Private Attributes
MYSQL_STMT *	m_Mstmt
uint32	m_paramCount
std::vector< bool >	m_paramsSet
MYSQL_BIND *	m_bind

Friends
class	MySQLConnection
class	PreparedStatement

Constructor & Destructor Documentation

MySQLPreparedStatement::MySQLPreparedStatement

(

MYSQL_STMT *

stmt

)

Initialize variable parameters

"If set to 1, causes mysql_stmt_store_result() to update the metadata MYSQL_FIELD->max_length value."

 :
m_stmt(NULL),
m_Mstmt(stmt),
m_bind(NULL)
{
 m_paramCount = mysql_stmt_param_count(stmt);
 m_paramsSet.assign(m_paramCount, false);
 m_bind = new MYSQL_BIND[m_paramCount];
 memset(m_bind, 0, sizeof(MYSQL_BIND)*m_paramCount);

 my_bool bool_tmp = 1;
 mysql_stmt_attr_set(stmt, STMT_ATTR_UPDATE_MAX_LENGTH, &bool_tmp);
}

MySQLPreparedStatement::~MySQLPreparedStatement

(

)

{
 ClearParameters();
 if (m_Mstmt->bind_result_done)
 {
 delete[] m_Mstmt->bind->length;
 delete[] m_Mstmt->bind->is_null;
 }
 mysql_stmt_close(m_Mstmt);
 delete[] m_bind;
}

Here is the call graph for this function:

MySQLPreparedStatement::MySQLPreparedStatement ( MySQLPreparedStatement const &  right )

privatedelete

Member Function Documentation

bool MySQLPreparedStatement::CheckValidIndex ( uint8  index )

protected

{
 ASSERT(index < m_paramCount || ParamenterIndexAssertFail(m_stmt->m_index, index, m_paramCount));

 if (m_paramsSet[index])
 TC_LOG_WARN("sql.sql", "[WARNING] Prepared Statement (id: %u) trying to bind value on already bound index (%u).", m_stmt->m_index, index);
 return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::ClearParameters ( )

protected

{
 for (uint32 i=0; i < m_paramCount; ++i)
 {
 delete m_bind[i].length;
 m_bind[i].length = NULL;
 delete[] (char*) m_bind[i].buffer;
 m_bind[i].buffer = NULL;
 m_paramsSet[i] = false;
 }
}

Here is the caller graph for this function:

MYSQL_BIND* MySQLPreparedStatement::GetBind ( )

inlineprotected

{ return m_bind; }

std::string MySQLPreparedStatement::getQueryString ( std::string const &  sqlPattern ) const

protected

{
 std::string queryString = sqlPattern;

 size_t pos = 0;
 for (uint32 i = 0; i < m_stmt->statement_data.size(); i++)
 {
 pos = queryString.find('?', pos);
 std::stringstream ss;

 switch (m_stmt->statement_data[i].type)
 {
 case TYPE_BOOL:
 ss << uint16(m_stmt->statement_data[i].data.boolean);
 break;
 case TYPE_UI8:
 ss << uint16(m_stmt->statement_data[i].data.ui8); // stringstream will append a character with that code instead of numeric representation
 break;
 case TYPE_UI16:
 ss << m_stmt->statement_data[i].data.ui16;
 break;
 case TYPE_UI32:
 ss << m_stmt->statement_data[i].data.ui32;
 break;
 case TYPE_I8:
 ss << int16(m_stmt->statement_data[i].data.i8); // stringstream will append a character with that code instead of numeric representation
 break;
 case TYPE_I16:
 ss << m_stmt->statement_data[i].data.i16;
 break;
 case TYPE_I32:
 ss << m_stmt->statement_data[i].data.i32;
 break;
 case TYPE_UI64:
 ss << m_stmt->statement_data[i].data.ui64;
 break;
 case TYPE_I64:
 ss << m_stmt->statement_data[i].data.i64;
 break;
 case TYPE_FLOAT:
 ss << m_stmt->statement_data[i].data.f;
 break;
 case TYPE_DOUBLE:
 ss << m_stmt->statement_data[i].data.d;
 break;
 case TYPE_STRING:
 ss << '\'' << (char const*)m_stmt->statement_data[i].binary.data() << '\'';
 break;
 case TYPE_BINARY:
 ss << "BINARY";
 break;
 case TYPE_NULL:
 ss << "NULL";
 break;
 }

 std::string replaceStr = ss.str();
 queryString.replace(pos, 1, replaceStr);
 pos += replaceStr.length();
 }

 return queryString;
}

MYSQL_STMT* MySQLPreparedStatement::GetSTMT ( )

inlineprotected

{ return m_Mstmt; }

MySQLPreparedStatement& MySQLPreparedStatement::operator= ( MySQLPreparedStatement const &  right )

privatedelete

void MySQLPreparedStatement::setBinary	(	const uint8	index,
		const std::vector< uint8 > &	value,
		bool	isString
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 uint32 len = uint32(value.size());
 param->buffer_type = MYSQL_TYPE_BLOB;
 delete [] static_cast<char *>(param->buffer);
 param->buffer = new char[len];
 param->buffer_length = len;
 param->is_null_value = 0;
 delete param->length;
 param->length = new unsigned long(len);
 if (isString)
 {
 *param->length -= 1;
 param->buffer_type = MYSQL_TYPE_VAR_STRING;
 }

 memcpy(param->buffer, value.data(), len);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setBool	(	const uint8	index,
		const bool	value
	)

{
 setUInt8(index, value ? 1 : 0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setDouble	(	const uint8	index,
		const double	value
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 setValue(param, MYSQL_TYPE_DOUBLE, &value, sizeof(double), (value > 0.0f));
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setFloat	(	const uint8	index,
		const float	value
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 setValue(param, MYSQL_TYPE_FLOAT, &value, sizeof(float), (value > 0.0f));
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setInt16	(	const uint8	index,
		const int16	value
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 setValue(param, MYSQL_TYPE_SHORT, &value, sizeof(int16), false);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setInt32	(	const uint8	index,
		const int32	value
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 setValue(param, MYSQL_TYPE_LONG, &value, sizeof(int32), false);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setInt64	(	const uint8	index,
		const int64	value
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 setValue(param, MYSQL_TYPE_LONGLONG, &value, sizeof(int64), false);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setInt8	(	const uint8	index,
		const int8	value
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 setValue(param, MYSQL_TYPE_TINY, &value, sizeof(int8), false);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setNull

(

const uint8

index

)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 param->buffer_type = MYSQL_TYPE_NULL;
 delete [] static_cast<char *>(param->buffer);
 param->buffer = NULL;
 param->buffer_length = 0;
 param->is_null_value = 1;
 delete param->length;
 param->length = NULL;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setUInt16	(	const uint8	index,
		const uint16	value
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 setValue(param, MYSQL_TYPE_SHORT, &value, sizeof(uint16), true);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setUInt32	(	const uint8	index,
		const uint32	value
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 setValue(param, MYSQL_TYPE_LONG, &value, sizeof(uint32), true);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setUInt64	(	const uint8	index,
		const uint64	value
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 setValue(param, MYSQL_TYPE_LONGLONG, &value, sizeof(uint64), true);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setUInt8	(	const uint8	index,
		const uint8	value
	)

{
 CheckValidIndex(index);
 m_paramsSet[index] = true;
 MYSQL_BIND* param = &m_bind[index];
 setValue(param, MYSQL_TYPE_TINY, &value, sizeof(uint8), true);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MySQLPreparedStatement::setValue ( MYSQL_BIND *  param, enum_field_types  type, const void *  value, uint32  len, bool  isUnsigned  )

private

{
 param->buffer_type = type;
 delete [] static_cast<char *>(param->buffer);
 param->buffer = new char[len];
 param->buffer_length = 0;
 param->is_null_value = 0;
 param->length = NULL; // Only != NULL for strings
 param->is_unsigned = isUnsigned;

 memcpy(param->buffer, value, len);
}

Here is the caller graph for this function:

Friends And Related Function Documentation

friend class MySQLConnection

friend

friend class PreparedStatement

friend

Member Data Documentation

MYSQL_BIND* MySQLPreparedStatement::m_bind

private

MYSQL_STMT* MySQLPreparedStatement::m_Mstmt

private

uint32 MySQLPreparedStatement::m_paramCount

private

std::vector<bool> MySQLPreparedStatement::m_paramsSet

private

PreparedStatement* MySQLPreparedStatement::m_stmt

protected

---

The documentation for this class was generated from the following files:

• src/server/database/Database/PreparedStatement.h
• src/server/database/Database/PreparedStatement.cpp