#include <dataset.h>

Inheritance diagram for dbiplus::Dataset:

Public Member Functions
	Dataset ()

	Dataset (Database *newDb)

virtual	~Dataset ()

void	setDatabase (Database *newDb)

Database *	getDatabase ()

void	setExecSql (const char *newSql)

const char *	getExecSql () const

virtual bool	isActive ()

virtual void	setSqlParams (sqlType t, const char *sqlFrmt,...)

virtual int64_t	lastinsertid ()=0

virtual long	nextid (const char *seq_name)=0

virtual int	num_rows ()=0

virtual void	open (const std::string &sql)=0

virtual void	open ()=0

virtual int	exec (const std::string &sql)=0

virtual int	exec ()=0

virtual const void *	getExecRes ()=0

virtual bool	query (const std::string &sql)=0

virtual void	close ()

virtual void	refresh ()

virtual bool	dropIndex (const char table, const char index)
	Drop an index from the database table, provided it exists.

virtual bool	seek (int pos=0)

virtual bool	goto_rec (int pos=1)

virtual void	first ()

virtual void	next ()

virtual void	prev ()

virtual void	last ()

virtual bool	eof ()

virtual bool	bof ()

virtual void	insert ()

virtual void	append ()

virtual void	edit ()

virtual void	del ()

virtual void	post ()

virtual void	deletion ()

virtual void	cancel ()

virtual void	interrupt ()

virtual void	setParamList (const ParamList &params)

virtual bool	locate ()

virtual bool	locate (const ParamList &params)

virtual bool	findNext ()

virtual int	field_count ()

virtual int	fieldCount ()

virtual const char *	fieldName (int n)

virtual int	fieldIndex (const char *fn)

virtual bool	set_field_value (const char *f_name, const field_value &value)

virtual bool	sf (const char *f, const field_value &v)

virtual const field_value &	get_field_value (const char *f_name)

virtual const field_value &	get_field_value (int index)

const field_value &	fv (const char *f)

const field_value &	fv (int index)

void	set_autocommit (bool v)

bool	get_autocommit () const

Fields &	get_fields_object ()

Fields &	get_edit_object ()

const result_set &	get_result_set () const

const sql_record *	get_sql_record ()

dsStates	get_state () const

void	set_select_sql (std::string_view select_sql)

void	add_update_sql (const std::string &upd_sql)

void	add_insert_sql (const std::string &ins_sql)

void	add_delete_sql (const std::string &del_sql)

void	clear_update_sql ()

void	clear_insert_sql ()

void	clear_delete_sql ()

size_t	insert_sql_count () const

size_t	delete_sql_count () const

const char *	get_select_sql ()

Protected Member Functions
virtual void	make_insert ()=0

virtual void	make_edit ()=0

virtual void	make_deletion ()=0

virtual void	fill_fields ()=0

void	parse_sql (std::string &sql) const

virtual field_value	f_old (const char *f)

Protected Attributes
Database *	db {nullptr}

dsStates	ds_state {dsStates::dsInactive}

std::unique_ptr< Fields >	fields_object {std::make_unique<Fields>()}

std::unique_ptr< Fields >	edit_object {std::make_unique<Fields>()}

std::unordered_map< std::string, unsigned int >	name2indexMap

result_set	result

result_set	exec_res

bool	autorefresh {false}

bool	active {false}

bool	haveError {false}

int	frecno {0}

std::string	sql

ParamList	plist

bool	fbof {true}

bool	feof {true}

bool	autocommit {true}

std::string	empty_sql

std::string	select_sql

StringList	update_sql

StringList	insert_sql

StringList	delete_sql

Constructor & Destructor Documentation

◆ Dataset() [1/2]

dbiplus::Dataset::Dataset ( )

default

◆ Dataset() [2/2]

dbiplus::Dataset::Dataset ( Database * newDb )

explicit

◆ ~Dataset()

dbiplus::Dataset::~Dataset ( )

virtual

Member Function Documentation

◆ add_delete_sql()

void dbiplus::Dataset::add_delete_sql ( const std::string & del_sql )

◆ add_insert_sql()

void dbiplus::Dataset::add_insert_sql ( const std::string & ins_sql )

◆ add_update_sql()

void dbiplus::Dataset::add_update_sql ( const std::string & upd_sql )

◆ append()

virtual void dbiplus::Dataset::append ( )

inlinevirtual

◆ bof()

virtual bool dbiplus::Dataset::bof ( )

inlinevirtual

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ cancel()

virtual void dbiplus::Dataset::cancel ( )

inlinevirtual

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ clear_delete_sql()

void dbiplus::Dataset::clear_delete_sql ( )

◆ clear_insert_sql()

void dbiplus::Dataset::clear_insert_sql ( )

◆ clear_update_sql()

void dbiplus::Dataset::clear_update_sql ( )

◆ close()

void dbiplus::Dataset::close ( )

virtual

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ del()

void dbiplus::Dataset::del ( )

virtual

◆ delete_sql_count()

size_t dbiplus::Dataset::delete_sql_count ( ) const

◆ deletion()

void dbiplus::Dataset::deletion ( )

virtual

◆ dropIndex()

virtual bool dbiplus::Dataset::dropIndex	(	const char *	table,
		const char *	index )

inlinevirtual

Drop an index from the database table, provided it exists.

Parameters

table	- name of the table the index to be dropped is associated with
index	- name of the index to be dropped

Returns: true when the index is guaranteed to no longer exist in the database.

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ edit()

void dbiplus::Dataset::edit ( )

virtual

◆ eof()

virtual bool dbiplus::Dataset::eof ( )

inlinevirtual

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ exec() [1/2]

virtual int dbiplus::Dataset::exec ( )

pure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ exec() [2/2]

virtual int dbiplus::Dataset::exec ( const std::string & sql )

pure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ f_old()

field_value dbiplus::Dataset::f_old ( const char * f )

protectedvirtual

◆ field_count()

int dbiplus::Dataset::field_count ( )

virtual

◆ fieldCount()

int dbiplus::Dataset::fieldCount ( )

virtual

◆ fieldIndex()

int dbiplus::Dataset::fieldIndex ( const char * fn )

virtual

◆ fieldName()

const char * dbiplus::Dataset::fieldName ( int n )

virtual

◆ fill_fields()

virtual void dbiplus::Dataset::fill_fields ( )

protectedpure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ findNext()

bool dbiplus::Dataset::findNext ( )

virtual

◆ first()

void dbiplus::Dataset::first ( )

virtual

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ fv() [1/2]

const field_value & dbiplus::Dataset::fv ( const char * f )

inline

◆ fv() [2/2]

const field_value & dbiplus::Dataset::fv ( int index )

inline

◆ get_autocommit()

bool dbiplus::Dataset::get_autocommit ( ) const

inline

◆ get_edit_object()

Fields & dbiplus::Dataset::get_edit_object ( )

inline

◆ get_field_value() [1/2]

const field_value & dbiplus::Dataset::get_field_value ( const char * f_name )

virtual

◆ get_field_value() [2/2]

const field_value & dbiplus::Dataset::get_field_value ( int index )

virtual

◆ get_fields_object()

Fields & dbiplus::Dataset::get_fields_object ( )

inline

◆ get_result_set()

const result_set & dbiplus::Dataset::get_result_set ( ) const

inline

◆ get_select_sql()

const char * dbiplus::Dataset::get_select_sql ( )

◆ get_sql_record()

const sql_record * dbiplus::Dataset::get_sql_record ( )

◆ get_state()

dsStates dbiplus::Dataset::get_state ( ) const

inline

◆ getDatabase()

Database * dbiplus::Dataset::getDatabase ( )

inline

◆ getExecRes()

virtual const void * dbiplus::Dataset::getExecRes ( )

pure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ getExecSql()

const char * dbiplus::Dataset::getExecSql ( ) const

inline

◆ goto_rec()

bool dbiplus::Dataset::goto_rec ( int pos = 1 )

virtual

◆ insert()

void dbiplus::Dataset::insert ( )

virtual

◆ insert_sql_count()

size_t dbiplus::Dataset::insert_sql_count ( ) const

◆ interrupt()

virtual void dbiplus::Dataset::interrupt ( )

inlinevirtual

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ isActive()

virtual bool dbiplus::Dataset::isActive ( )

inlinevirtual

◆ last()

void dbiplus::Dataset::last ( )

virtual

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ lastinsertid()

virtual int64_t dbiplus::Dataset::lastinsertid ( )

pure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ locate() [1/2]

bool dbiplus::Dataset::locate ( )

virtual

◆ locate() [2/2]

bool dbiplus::Dataset::locate ( const ParamList & params )

virtual

◆ make_deletion()

virtual void dbiplus::Dataset::make_deletion ( )

protectedpure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ make_edit()

virtual void dbiplus::Dataset::make_edit ( )

protectedpure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ make_insert()

virtual void dbiplus::Dataset::make_insert ( )

protectedpure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ next()

void dbiplus::Dataset::next ( )

virtual

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ nextid()

virtual long dbiplus::Dataset::nextid ( const char * seq_name )

pure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ num_rows()

virtual int dbiplus::Dataset::num_rows ( )

pure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ open() [1/2]

virtual void dbiplus::Dataset::open ( )

pure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ open() [2/2]

virtual void dbiplus::Dataset::open ( const std::string & sql )

pure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ parse_sql()

void dbiplus::Dataset::parse_sql ( std::string & sql ) const

protected

◆ post()

void dbiplus::Dataset::post ( )

virtual

◆ prev()

void dbiplus::Dataset::prev ( )

virtual

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ query()

virtual bool dbiplus::Dataset::query ( const std::string & sql )

pure virtual

Implemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ refresh()

void dbiplus::Dataset::refresh ( )

virtual

◆ seek()

bool dbiplus::Dataset::seek ( int pos = 0 )

virtual

Reimplemented in dbiplus::MysqlDataset, and dbiplus::SqliteDataset.

◆ set_autocommit()

void dbiplus::Dataset::set_autocommit ( bool v )

inline

◆ set_field_value()

bool dbiplus::Dataset::set_field_value	(	const char *	f_name,
		const field_value &	value )

virtual

◆ set_select_sql()

void dbiplus::Dataset::set_select_sql ( std::string_view select_sql )

◆ setDatabase()

void dbiplus::Dataset::setDatabase ( Database * newDb )

inline

◆ setExecSql()

void dbiplus::Dataset::setExecSql ( const char * newSql )

inline

◆ setParamList()

void dbiplus::Dataset::setParamList ( const ParamList & params )

virtual

◆ setSqlParams()

void dbiplus::Dataset::setSqlParams	(	sqlType	t,
		const char *	sqlFrmt,
			... )

virtual

◆ sf()

virtual bool dbiplus::Dataset::sf	(	const char *	f,
		const field_value &	v )

inlinevirtual

Member Data Documentation

◆ active

bool dbiplus::Dataset::active {false}

protected

◆ autocommit

bool dbiplus::Dataset::autocommit {true}

protected

◆ autorefresh

bool dbiplus::Dataset::autorefresh {false}

protected

◆ db

Database* dbiplus::Dataset::db {nullptr}

protected

◆ delete_sql

StringList dbiplus::Dataset::delete_sql

protected

◆ ds_state

dsStates dbiplus::Dataset::ds_state {dsStates::dsInactive}

protected

◆ edit_object

std::unique_ptr<Fields> dbiplus::Dataset::edit_object {std::make_unique<Fields>()}

protected

◆ empty_sql

std::string dbiplus::Dataset::empty_sql

protected

◆ exec_res

result_set dbiplus::Dataset::exec_res

protected

◆ fbof

bool dbiplus::Dataset::fbof {true}

protected

◆ feof

bool dbiplus::Dataset::feof {true}

protected

◆ fields_object

std::unique_ptr<Fields> dbiplus::Dataset::fields_object {std::make_unique<Fields>()}

protected

◆ frecno

int dbiplus::Dataset::frecno {0}

protected

◆ haveError

bool dbiplus::Dataset::haveError {false}

protected

◆ insert_sql

StringList dbiplus::Dataset::insert_sql

protected

◆ name2indexMap

std::unordered_map<std::string, unsigned int> dbiplus::Dataset::name2indexMap

protected

◆ plist

ParamList dbiplus::Dataset::plist

protected

◆ result

result_set dbiplus::Dataset::result

protected

◆ select_sql

std::string dbiplus::Dataset::select_sql

protected

◆ sql

std::string dbiplus::Dataset::sql

protected

◆ update_sql

StringList dbiplus::Dataset::update_sql

protected

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

Public Member Functions

Protected Member Functions

Protected Attributes

Constructor & Destructor Documentation

◆ Dataset() [1/2]

◆ Dataset() [2/2]

◆ ~Dataset()

Member Function Documentation

◆ add_delete_sql()

◆ add_insert_sql()

◆ add_update_sql()

◆ append()

◆ bof()

◆ cancel()

◆ clear_delete_sql()

◆ clear_insert_sql()

◆ clear_update_sql()

◆ close()

◆ del()

◆ delete_sql_count()

◆ deletion()

◆ dropIndex()

◆ edit()

◆ eof()

◆ exec() [1/2]

◆ exec() [2/2]

◆ f_old()

◆ field_count()

◆ fieldCount()

◆ fieldIndex()

◆ fieldName()

◆ fill_fields()

◆ findNext()

◆ first()

◆ fv() [1/2]

◆ fv() [2/2]

◆ get_autocommit()

◆ get_edit_object()

◆ get_field_value() [1/2]

◆ get_field_value() [2/2]

◆ get_fields_object()

◆ get_result_set()

◆ get_select_sql()

◆ get_sql_record()

◆ get_state()

◆ getDatabase()

◆ getExecRes()

◆ getExecSql()

◆ goto_rec()

◆ insert()

◆ insert_sql_count()

◆ interrupt()

◆ isActive()

◆ last()

◆ lastinsertid()

◆ locate() [1/2]

◆ locate() [2/2]

◆ make_deletion()

◆ make_edit()

◆ make_insert()

◆ next()

◆ nextid()

◆ num_rows()

◆ open() [1/2]

◆ open() [2/2]

◆ parse_sql()

◆ post()

◆ prev()

◆ query()

◆ refresh()

◆ seek()

◆ set_autocommit()

◆ set_field_value()

◆ set_select_sql()

◆ setDatabase()

◆ setExecSql()

◆ setParamList()

◆ setSqlParams()

◆ sf()

Member Data Documentation