mysql_dbserver Class Reference

implements the dbserver interface for MYSQL More...

#include <mysqlsrv.h>

Inheritance diagram for mysql_dbserver:

List of all members.

Public Member Functions
	mysql_dbserver (size_t ident)
	constructor
virtual	~mysql_dbserver ()
	destructor
Protected Member Functions
virtual void	v_connect (bool trusted_connection, const char *connection_string)
	database specific
virtual void	v_disconnect ()
	closes connection
virtual void	v_start_transaction ()
	starts transaction
virtual void	v_commit ()
	commits transaction
virtual void	v_rollback ()
	rolls back transaction
virtual bool	v_is_connect_alive ()
	checks if the connection is alive
virtual void	v_before_execute ()
	pure virtual functions
virtual void	v_after_execute ()
	calls additional function after executing the sql statement
virtual void	v_before_bind_columns ()
	before bind columns sometimes we got db specific
virtual void	v_execute ()
	executes SQL expression
virtual void	v_close ()
	closes opened query
virtual void	v_fetch ()
	fetches block of rows
virtual void	v_replace_quote ()
	replaces quote to the available sign for native drive
virtual void	v_bind_one_param (size_t index)
	binds one param by index
virtual void	v_bind_one_column (size_t index)
	binds one column by index
virtual size_t	v_get_number_columns ()
	gets number columns in query
virtual void	v_convert_one_value (size_t row, size_t index, terimber_db_value &val)
	converts one field value to variant buffer
virtual void	v_get_one_column_info (size_t index)
	gets one column info from native driver
virtual void	v_form_sql_string ()
	forms SQL expression depending on type selected and native driver
virtual void	v_rebind_one_param (size_t index)
	rebinds one param for input/output or output params
virtual void	v_interrupt_async ()
	terminates asynchronous action
virtual dbtypes	v_native_type_to_client_type (size_t native_type)
	converts types
Private Member Functions
void	parse_connection_string (const char *connection_string, string_t &user, string_t &password, string_t &host, unsigned short &port, string_t &database)
	parser connection string
Private Attributes
MYSQL *	_desc
	descriptor pointer
MYSQL_STMT *	_stmt
	statement pointer
_vector< MYSQL_BIND >	_param_binders
	parameter binders
_vector< MYSQL_BIND >	_column_binders
	column binders

---

Detailed Description

implements the dbserver interface for MYSQL

Definition at line 39 of file mysqlsrv.h.

---

Constructor & Destructor Documentation

mysql_dbserver::mysql_dbserver

(

size_t

ident

)

constructor

Parameters:

ident

server ident

Definition at line 53 of file mysqlsrv.cpp.

mysql_dbserver::~mysql_dbserver

(

)

[virtual]

destructor

Definition at line 58 of file mysqlsrv.cpp.

References dbserver_impl::_is_connect(), dbserver_impl::_is_open_sql(), dbserver_impl::close_sql(), and dbserver_impl::disconnect().

---

Member Function Documentation

void mysql_dbserver::v_connect	(	bool	trusted_connection,
		const char *	connection_string
	)			[protected, virtual]

database specific

Implements dbserver_impl.

Definition at line 69 of file mysqlsrv.cpp.

References _desc, check_retcode_db, base_string< T >::length(), and parse_connection_string().

void mysql_dbserver::v_disconnect

(

)

[protected, virtual]

closes connection

Implements dbserver_impl.

Definition at line 103 of file mysqlsrv.cpp.

References _desc, dbserver_impl::_temp_allocator, byte_allocator::clear_extra(), and v_close().

void mysql_dbserver::v_start_transaction

(

)

[protected, virtual]

starts transaction

Implements dbserver_impl.

Definition at line 118 of file mysqlsrv.cpp.

References _desc, and check_retcode_db.

void mysql_dbserver::v_commit

(

)

[protected, virtual]

commits transaction

Implements dbserver_impl.

Definition at line 125 of file mysqlsrv.cpp.

References _desc, and check_retcode_db.

void mysql_dbserver::v_rollback

(

)

[protected, virtual]

rolls back transaction

Implements dbserver_impl.

Definition at line 132 of file mysqlsrv.cpp.

References _desc, and check_retcode_db.

bool mysql_dbserver::v_is_connect_alive

(

)

[protected, virtual]

checks if the connection is alive

Implements dbserver_impl.

Definition at line 139 of file mysqlsrv.cpp.

References dbserver_impl::_is_connect().

void mysql_dbserver::v_before_execute

(

)

[protected, virtual]

pure virtual functions

allocates resources before executing sql statement

Implements dbserver_impl.

Definition at line 150 of file mysqlsrv.cpp.

References _desc, dbserver_impl::_sql, _stmt, dbserver_impl::ACTION_EXEC_PROC, dbserver_impl::ACTION_EXEC_PROC_ASYNC, dbserver_impl::ACTION_EXEC_SQL, dbserver_impl::ACTION_EXEC_SQL_ASYNC, dbserver_impl::ACTION_OPEN_PROC, dbserver_impl::ACTION_OPEN_PROC_ASYNC, dbserver_impl::ACTION_OPEN_SQL, dbserver_impl::ACTION_OPEN_SQL_ASYNC, check_retcode, check_retcode_db, dbserver_impl::get_action(), and base_string< T >::length().

void mysql_dbserver::v_after_execute

(

)

[protected, virtual]

calls additional function after executing the sql statement

Implements dbserver_impl.

Definition at line 178 of file mysqlsrv.cpp.

References _desc, dbserver_impl::ACTION_EXEC_PROC, dbserver_impl::ACTION_EXEC_PROC_ASYNC, dbserver_impl::ACTION_EXEC_SQL, dbserver_impl::ACTION_EXEC_SQL_ASYNC, dbserver_impl::ACTION_OPEN_PROC, dbserver_impl::ACTION_OPEN_PROC_ASYNC, dbserver_impl::ACTION_OPEN_SQL, dbserver_impl::ACTION_OPEN_SQL_ASYNC, and dbserver_impl::get_action().

void mysql_dbserver::v_before_bind_columns

(

)

[protected, virtual]

before bind columns sometimes we got db specific

Implements dbserver_impl.

Definition at line 567 of file mysqlsrv.cpp.

References dbserver_impl::_cols, _column_binders, dbserver_impl::_columns_allocator, _vector< T, A >::resize(), and base_vector< T >::size().

void mysql_dbserver::v_execute

(

)

[protected, virtual]

executes SQL expression

Implements dbserver_impl.

Definition at line 204 of file mysqlsrv.cpp.

References _stmt, dbserver_impl::ACTION_EXEC_PROC, dbserver_impl::ACTION_EXEC_PROC_ASYNC, dbserver_impl::ACTION_EXEC_SQL, dbserver_impl::ACTION_EXEC_SQL_ASYNC, check_retcode, and dbserver_impl::get_action().

Referenced by v_fetch().

void mysql_dbserver::v_close

(

)

[protected, virtual]

closes opened query

Implements dbserver_impl.

Definition at line 222 of file mysqlsrv.cpp.

References _column_binders, _param_binders, _stmt, and _vector< T, A >::clear().

Referenced by v_disconnect(), and v_interrupt_async().

void mysql_dbserver::v_fetch

(

)

[protected, virtual]

fetches block of rows

Implements dbserver_impl.

Definition at line 239 of file mysqlsrv.cpp.

References dbserver_impl::_cols, dbserver_impl::_data, dbserver_impl::_data_allocator, dbserver_impl::_fetched_rows, dbserver_impl::_requested_rows, dbserver_impl::_start_row, _stmt, exception::_throw(), check_retcode, base_list< T >::end(), dbserver_impl::get_state(), _list< T, A >::push_back(), base_vector< T >::size(), STATE_INTERRUPTED, v_convert_one_value(), and v_execute().

void mysql_dbserver::v_replace_quote

(

)

[protected, virtual]

replaces quote to the available sign for native drive

Implements dbserver_impl.

Definition at line 288 of file mysqlsrv.cpp.

References dbserver_impl::_columns_allocator, _param_binders, dbserver_impl::_params, dbserver_impl::_quote, dbserver_impl::_sql, dbserver_impl::_temp_allocator, exception::_throw(), byte_allocator::allocate(), check_pointer(), base_string< T >::length(), os_minus_one, _vector< T, A >::resize(), base_vector< T >::size(), str_template::strcpy(), and valid_delimeters.

void mysql_dbserver::v_bind_one_param

(

size_t

index

)

[protected, virtual]

binds one param by index

Implements dbserver_impl.

Definition at line 342 of file mysqlsrv.cpp.

References binder::_bind_buffer, binder::_in_out, binder::_max_length, binder::_native_type, _param_binders, dbserver_impl::_params, binder::_precision, binder::_real_length, binder::_scale, _stmt, dbserver_impl::_temp_allocator, exception::_throw(), binder::_type, binder::_value, byte_allocator::allocate(), _terimber_xml_value_::boolVal, _terimber_xml_value_::bufVal, _terimber_xml_value_::bVal, check_pointer(), check_retcode, date::convert_from(), _terimber_xml_value_::cVal, db_binary, db_bool, db_date, db_decimal, db_double, db_float, db_numeric, db_sb1, db_sb2, db_sb4, db_sb8, db_string, db_ub1, db_ub2, db_ub4, db_ub8, db_wstring, _terimber_xml_value_::dblVal, _terimber_xml_value_::fltVal, numeric::format(), _terimber_xml_value_::intVal, is_param_out(), _terimber_xml_value_::iVal, base_string< T >::length(), _terimber_xml_value_::lVal, terimber_db_value::nullVal, os_minus_one, numeric::parse_orcl(), numeric::precision(), numeric::scale(), base_vector< T >::size(), str_template::strcpy(), str_template::strlen(), _terimber_xml_value_::strVal, _terimber_xml_value_::uintVal, _terimber_xml_value_::uiVal, _terimber_xml_value_::ulVal, str_template::unicode_to_multibyte(), terimber_db_value::val, and _terimber_xml_value_::wstrVal.

void mysql_dbserver::v_bind_one_column

(

size_t

index

)

[protected, virtual]

binds one column by index

Implements dbserver_impl.

Definition at line 575 of file mysqlsrv.cpp.

References binder::_bind_buffer, binder::_bind_type, dbserver_impl::_cols, _column_binders, binder::_max_length, binder::_native_type, binder::_real_length, _stmt, dbserver_impl::_temp_allocator, exception::_throw(), binder::_value, byte_allocator::allocate(), check_pointer(), check_retcode, _terimber_xml_value_::cVal, _terimber_xml_value_::dblVal, _terimber_xml_value_::fltVal, _terimber_xml_value_::iVal, _terimber_xml_value_::lVal, terimber_db_value::nullVal, base_vector< T >::size(), _terimber_xml_value_::uintVal, and terimber_db_value::val.

size_t mysql_dbserver::v_get_number_columns

(

)

[protected, virtual]

gets number columns in query

Implements dbserver_impl.

Definition at line 664 of file mysqlsrv.cpp.

References _stmt.

void mysql_dbserver::v_convert_one_value	(	size_t	row,
		size_t	col,
		terimber_db_value &	val
	)			[protected, virtual]

converts one field value to variant buffer

Implements dbserver_impl.

Definition at line 671 of file mysqlsrv.cpp.

References binder::_bind_buffer, dbserver_impl::_cols, _column_binders, dbserver_impl::_data_allocator, binder::_max_length, binder::_native_type, binder::_real_length, dbserver_impl::_temp_allocator, exception::_throw(), binder::_value, byte_allocator::allocate(), _terimber_xml_value_::bufVal, check_pointer(), date::convert_to(), _terimber_xml_value_::cVal, _terimber_xml_value_::dblVal, _terimber_xml_value_::fltVal, _terimber_xml_value_::intVal, _terimber_xml_value_::iVal, _terimber_xml_value_::lVal, terimber_db_value::nullVal, numeric::orcl_len(), numeric::persist_orcl(), str_template::strlen(), _terimber_xml_value_::strVal, and terimber_db_value::val.

Referenced by v_fetch().

void mysql_dbserver::v_get_one_column_info

(

size_t

index

)

[protected, virtual]

gets one column info from native driver

Implements dbserver_impl.

Definition at line 779 of file mysqlsrv.cpp.

References binder::_bind_type, dbserver_impl::_cols, dbserver_impl::_columns_allocator, binder::_max_length, binder::_native_type, binder::_precision, binder::_real_length, binder::_scale, _stmt, binder::_value, terimber_db_value::nullVal, and binder::set_name().

void mysql_dbserver::v_form_sql_string

(

)

[protected, virtual]

forms SQL expression depending on type selected and native driver

Implements dbserver_impl.

Definition at line 796 of file mysqlsrv.cpp.

References dbserver_impl::_params, dbserver_impl::_quote, dbserver_impl::_sql, dbserver_impl::_temp_allocator, dbserver_impl::ACTION_EXEC_PROC, dbserver_impl::ACTION_EXEC_PROC_ASYNC, dbserver_impl::ACTION_EXEC_SQL, dbserver_impl::ACTION_EXEC_SQL_ASYNC, dbserver_impl::ACTION_FETCH, dbserver_impl::ACTION_FETCH_ASYNC, dbserver_impl::ACTION_NONE, dbserver_impl::ACTION_OPEN_PROC, dbserver_impl::ACTION_OPEN_PROC_ASYNC, dbserver_impl::ACTION_OPEN_SQL, dbserver_impl::ACTION_OPEN_SQL_ASYNC, dbserver_impl::get_action(), and base_vector< T >::size().

void mysql_dbserver::v_rebind_one_param

(

size_t

index

)

[protected, virtual]

rebinds one param for input/output or output params

Implements dbserver_impl.

Definition at line 840 of file mysqlsrv.cpp.

References binder::_bind_buffer, binder::_in_out, binder::_max_length, binder::_native_type, dbserver_impl::_params, binder::_real_length, dbserver_impl::_temp_allocator, exception::_throw(), binder::_value, binder::allocate_value(), _terimber_xml_value_::bufVal, check_pointer(), date::convert_to(), _terimber_xml_value_::dblVal, _terimber_xml_value_::intVal, is_param_out(), terimber_db_value::nullVal, numeric::orcl_len(), os_minus_one, numeric::persist_orcl(), str_template::strlen(), and terimber_db_value::val.

void mysql_dbserver::v_interrupt_async

(

)

[protected, virtual]

terminates asynchronous action

Implements dbserver_impl.

Definition at line 937 of file mysqlsrv.cpp.

References v_close().

dbtypes mysql_dbserver::v_native_type_to_client_type

(

size_t

native_type

)

[protected, virtual]

converts types

Implements dbserver_impl.

Definition at line 945 of file mysqlsrv.cpp.

References db_binary, db_date, db_decimal, db_double, db_float, db_sb1, db_sb2, db_sb4, db_sb8, db_string, and db_unknown.

void mysql_dbserver::parse_connection_string	(	const char *	connection_string,
		string_t &	user,
		string_t &	password,
		string_t &	host,
		unsigned short &	port,
		string_t &	database
	)			[private]

parser connection string

Parameters:

connection_string	input connection string
user	[out] user
password	[out] password
host	[out] host
port	[out] port
database	[out] database

Definition at line 991 of file mysqlsrv.cpp.

References base_string< T >::assign(), base_string< T >::length(), os_minus_one, str_template::strlen(), and str_template::strscan().

Referenced by v_connect().

---

Member Data Documentation

MYSQL* mysql_dbserver::_desc [private]

descriptor pointer

Definition at line 86 of file mysqlsrv.h.

Referenced by v_after_execute(), v_before_execute(), v_commit(), v_connect(), v_disconnect(), v_rollback(), and v_start_transaction().

MYSQL_STMT* mysql_dbserver::_stmt [private]

statement pointer

Definition at line 87 of file mysqlsrv.h.

Referenced by v_before_execute(), v_bind_one_column(), v_bind_one_param(), v_close(), v_execute(), v_fetch(), v_get_number_columns(), and v_get_one_column_info().

_vector< MYSQL_BIND > mysql_dbserver::_param_binders [private]

parameter binders

Definition at line 88 of file mysqlsrv.h.

Referenced by v_bind_one_param(), v_close(), and v_replace_quote().

_vector< MYSQL_BIND > mysql_dbserver::_column_binders [private]

column binders

Definition at line 89 of file mysqlsrv.h.

Referenced by v_before_bind_columns(), v_bind_one_column(), v_close(), and v_convert_one_value().

---

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

• mysqlsrv.h
• mysqlsrv.cpp