Thread portable class Gate portable class Timer class Pool class Terimber 2.0 About C++

Downloads Products & Services Support Clients Open Source About Home / Open source / Terimber 2.0 dbaccess.h Go to the documentation of this file. /* * The Software License * ================================================================================= * Copyright (c) 2003-.The Terimber Corporation. All rights reserved. * ================================================================================= * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright notice, * this list of conditions and the following disclaimer in the documentation * and/or other materials provided with the distribution. * The end-user documentation included with the redistribution, if any, * must include the following acknowledgment: * "This product includes software developed by the Terimber Corporation." * ================================================================================= * THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED WARRANTIES, * INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY * AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. * IN NO EVENT SHALL THE TERIMBER CORPORATION OR ITS CONTRIBUTORS BE LIABLE FOR * ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON * ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. * ================================================================================ */ #ifndef _terimber_dbaccess_h_ #define _terimber_dbaccess_h_ #include "ostypes.h" #include "dbtypes.h" #include "log.h" class async_db_notify { public: virtual ~async_db_notify() {} virtual void notify_async( bool noerrors, size_t ident ) = 0; }; class dbserver : public terimber_log_helper { public: virtual ~dbserver() { } virtual size_t get_ident() const = 0; virtual bool is_ready() const = 0; virtual size_t get_code() const = 0; virtual const char* get_error() const = 0; // // // ORACLE syntax: user/password@SID virtual bool connect( bool trusted_connection, const char* connect_string ) = 0; virtual bool disconnect() = 0; virtual bool start_transaction() = 0; virtual bool commit() = 0; virtual bool rollback() = 0; virtual bool is_connect() const = 0; virtual bool is_in_transaction() const = 0; virtual bool is_connect_alive() = 0; // // virtual bool resize_params( size_t size ) = 0; virtual size_t get_param_count() const = 0; virtual dbtypes get_param_type( size_t index ) const = 0; virtual db_param_type get_param_in_out(size_t index ) const = 0; virtual bool get_param_is_null(size_t index ) const = 0; virtual bool get_param_as_bool(size_t index ) const = 0; virtual sb1_t get_param_as_char(size_t index ) const = 0; virtual ub1_t get_param_as_byte(size_t index ) const = 0; virtual sb2_t get_param_as_short(size_t index ) const = 0; virtual ub2_t get_param_as_word(size_t index ) const = 0; virtual sb4_t get_param_as_long(size_t index ) const = 0; virtual ub4_t get_param_as_dword(size_t index ) const = 0; virtual float get_param_as_float(size_t index ) const = 0; virtual double get_param_as_double(size_t index ) const = 0; virtual sb8_t get_param_as_long64(size_t index ) const = 0; virtual ub8_t get_param_as_dword64(size_t index ) const = 0; virtual bool get_param_as_guid(size_t index, guid_t& val ) const = 0; virtual const char* get_param_as_numeric(size_t index, char delimeter ) const = 0; virtual const char* get_param_as_decimal(size_t index, char delimeter ) const = 0; virtual bool get_param_as_date(size_t index, ub4_t& year, ub1_t& month, ub1_t& day, ub1_t& hour, ub1_t& minute, ub1_t& second, ub2_t& millisec, ub1_t& wday, ub2_t& yday ) const = 0; virtual const char* get_param_as_string(size_t index ) const = 0; virtual const wchar_t* get_param_as_wstring(size_t index ) const = 0; virtual const ub1_t* get_param_as_binary(size_t index, size_t& len ) const = 0; virtual const ub1_t* get_param_as_binary_ptr(size_t index ) const = 0; virtual bool set_param_as_null(size_t index, db_param_type in_out, dbtypes type ) = 0; virtual bool set_param_as_bool(size_t index, db_param_type in_out, bool val ) = 0; virtual bool set_param_as_char(size_t index, db_param_type in_out, sb1_t val ) = 0; virtual bool set_param_as_byte(size_t index, db_param_type in_out, ub1_t val ) = 0; virtual bool set_param_as_short(size_t index, db_param_type in_out, sb2_t val ) = 0; virtual bool set_param_as_word(size_t index, db_param_type in_out, ub2_t val ) = 0; virtual bool set_param_as_long(size_t index, db_param_type in_out, sb4_t val ) = 0; virtual bool set_param_as_dword(size_t index, db_param_type in_out, ub4_t val ) = 0; virtual bool set_param_as_float(size_t index, db_param_type in_out, float val ) = 0; virtual bool set_param_as_double(size_t index, db_param_type in_out, double val ) = 0; virtual bool set_param_as_long64(size_t index, db_param_type in_out, sb8_t val ) = 0; virtual bool set_param_as_dword64(size_t index, db_param_type in_out, ub8_t val ) = 0; virtual bool set_param_as_guid(size_t index, db_param_type in_out, const guid_t& val ) = 0; virtual bool set_param_as_numeric(size_t index, db_param_type in_out, const char* val, char delimeter ) = 0; virtual bool set_param_as_decimal(size_t index, db_param_type in_out, const char* val, char delimeter ) = 0; virtual bool set_param_as_date(size_t index, db_param_type in_out, ub4_t year, ub1_t month, ub1_t day, ub1_t hour, ub1_t minute, ub1_t second, ub2_t millisec ) = 0; virtual bool set_param_as_string(size_t index, db_param_type in_out, const char* val, size_t len, size_t max_len = 0 ) = 0; virtual bool set_param_as_string_ptr(size_t index, const char* val ) = 0; virtual bool set_param_as_wstring(size_t index, db_param_type in_out, const wchar_t* val, size_t len, size_t max_len = 0 ) = 0; virtual bool set_param_as_wstring_ptr(size_t index, const wchar_t* val ) = 0; virtual bool set_param_as_binary(size_t index, db_param_type in_out, const ub1_t* val, size_t len, size_t max_len = 0 ) = 0; virtual bool set_param_as_binary_ptr(size_t index, const ub1_t* val ) = 0; virtual size_t get_column_count() const = 0; virtual dbtypes get_column_type(size_t index ) const = 0; virtual const char* get_column_name(size_t index ) const = 0; virtual bool get_column_nullable(size_t index ) const = 0; virtual size_t get_column_scale(size_t index ) const = 0; virtual size_t get_column_precision(size_t index ) const = 0; virtual size_t get_column_max_length(size_t index ) const = 0; // // virtual size_t get_row_count() const = 0; virtual void reset() const = 0; virtual bool next() const = 0; virtual bool prev() const = 0; virtual bool get_value_is_null(size_t index ) const = 0; virtual bool get_value_as_bool(size_t index ) const = 0; virtual sb1_t get_value_as_char(size_t index ) const = 0; virtual ub1_t get_value_as_byte(size_t index ) const = 0; virtual sb2_t get_value_as_short(size_t index ) const = 0; virtual ub2_t get_value_as_word(size_t index ) const = 0; virtual sb4_t get_value_as_long(size_t index ) const = 0; virtual ub4_t get_value_as_dword(size_t index ) const = 0; virtual float get_value_as_float(size_t index ) const = 0; virtual double get_value_as_double(size_t index ) const = 0; virtual sb8_t get_value_as_long64(size_t index ) const = 0; virtual ub8_t get_value_as_dword64(size_t index ) const = 0; virtual bool get_value_as_guid(size_t index, guid_t& val ) const = 0; virtual const char* get_value_as_numeric(size_t index, char delimeter ) const = 0; virtual const char* get_value_as_decimal(size_t index, char delimeter ) const = 0; virtual bool get_value_as_date(size_t index, ub4_t& year, ub1_t& month, ub1_t& day, ub1_t& hour, ub1_t& minute, ub1_t& second, ub2_t& millisec, ub1_t& wday, ub2_t& yday ) const = 0; virtual const char* get_value_as_string(size_t index ) const = 0; virtual const wchar_t* get_value_as_wstring(size_t index ) const = 0; virtual const ub1_t* get_value_as_binary(size_t index, size_t& len ) const = 0; virtual const ub1_t* get_value_as_binary_ptr(size_t index ) const = 0; virtual bool is_open_sql() const = 0; virtual bool open_sql( bool async, const char* sql ) = 0; virtual bool exec_sql( bool async, const char* sql ) = 0; virtual bool open_proc( bool async, const char* name ) = 0; virtual bool exec_proc( bool async, const char* name ) = 0; virtual bool fetch_data( bool async, size_t start_row, size_t num_rows, bool forward ) = 0; virtual bool close_sql() = 0; virtual bool interrupt_request() = 0; virtual bool set_quote( char quote ) = 0; virtual void set_callback( async_db_notify* target ) = 0; virtual void remove_callback(async_db_notify* target ) = 0; virtual bool param_bulk_store() = 0; virtual bool param_bulk_remove() = 0; virtual bool param_bulk_remove_all() = 0; }; #endif // _terimber_dbaccess_h_

© Copyright Terimber 2003-.