Inheritance diagram for TraceableDB:

Collaboration diagram for TraceableDB:

Public Member Functions
	__construct ($db)
	Constructor.

	ifsql ($test, $resok, $resko)
	Format a SQL IF.

	regexpsql ($subject, $pattern, $sqlstring=0)
	format a sql regexp

	fetch_row ($resultset)
	Return datas as an array.

	idate ($param, $gm='tzserver')
	Convert (by PHP) a GM Timestamp date into a string date with PHP server TZ to insert into a date field.

	lasterrno ()
	Return last error code.

	begin ($textinlog='')
	Start transaction.

	DDLCreateDb ($database, $charset='', $collation='', $owner='')
	Create a new database Do not use function xxx_create_db (xxx=mysql, ...) as they are deprecated We force to create database with charset this->forcecharset and collate this->forcecollate.

	getVersionArray ()
	Return version of database server into an array.

	convertSQLFromMysql ($line, $type='ddl')
	Convert a SQL request in Mysql syntax to native syntax.

	affected_rows ($resultset)
	Return the number of lines into the result of a request INSERT, DELETE or UPDATE.

	error ()
	Return description of last error.

	DDLListTables ($database, $table='')
	List tables into a database.

	DDLListTablesFull ($database, $table='')
	List tables into a database with table info.

	lastquery ()
	Return last request executed with query()

	order ($sortfield=null, $sortorder=null)
	Define sort criteria of request.

	decrypt ($value)
	Decrypt sensitive data in database.

	fetch_array ($resultset)
	Return datas as an array.

	lasterror ()
	Return last error label.

	escape ($stringtoencode)
	Escape a string to insert data.

	escapeforlike ($stringtoencode)
	Escape a string to insert data into a like.

	last_insert_id ($tab, $fieldid='rowid')
	Get last ID after an insert INSERT.

	getPathOfRestore ()
	Return full path of restore program.

	rollback ($log='')
	Cancel a transaction and go back to initial data values.

	query ($query, $usesavepoint=0, $type='auto', $result_mode=0)
	Execute a SQL request and return the resultset.

	connect ($host, $login, $passwd, $name, $port=0, $forcenew=false)
	Connection to server.

	plimit ($limit=0, $offset=0)
	Define limits and offset of request.

	getServerParametersValues ($filter='')
	Return value of server parameters.

	getServerStatusValues ($filter='')
	Return value of server status.

	getDefaultCollationDatabase ()
	Return collation used in database.

	num_rows ($resultset)
	Return number of lines for result of a SELECT.

	getPathOfDump ()
	Return full path of dump program.

	getDriverInfo ()
	Return version of database client driver.

	errno ()
	Return generic error code of last operation.

	DDLCreateTable ($table, $fields, $primary_key, $type, $unique_keys=null, $fulltext_keys=null, $keys=null)
	Create a table into database.

	DDLDropTable ($table)
	Drop a table into database.

	getListOfCharacterSet ()
	Return list of available charset that can be used to store data in database.

	DDLAddField ($table, $field_name, $field_desc, $field_position="")
	Create a new field into table.

	DDLDropField ($table, $field_name)
	Drop a field from table.

	DDLUpdateField ($table, $field_name, $field_desc)
	Update format of a field into a table.

	getListOfCollation ()
	Return list of available collation that can be used for database.

	DDLDescTable ($table, $field="")
	Return a pointer of line with description of a table or field.

	getVersion ()
	Return version of database server.

	getDefaultCharacterSetDatabase ()
	Return charset used to store data in database.

	DDLCreateUser ($dolibarr_main_db_host, $dolibarr_main_db_user, $dolibarr_main_db_pass, $dolibarr_main_db_name)
	Create a user and privileges to connect to database (even if database does not exists yet)

	jdate ($string, $gm=false)
	Convert (by PHP) a PHP server TZ string date into a Timestamps date (GMT if gm=true) 19700101020000 -> 3600 with TZ+1 and gmt=0 19700101020000 -> 7200 whatever is TZ if gmt=1.

	encrypt ($fieldorvalue, $withQuotes=1)
	Encrypt sensitive data in database Warning: This function includes the escape and add the SQL simple quotes on strings.

	commit ($log='')
	Validate a database transaction.

	DDLInfoTable ($table)
	List information of columns into a table.

	free ($resultset=null)
	Free last resultset used.

	close ()
	Close database connection.

	lastqueryerror ()
	Return last query in error.

	DDLGetConnectId ()
	Return connection ID.

	fetch_object ($resultset)
	Returns the current line (as an object) for the resultset cursor.

	select_db ($database)
	Select a database.

Public Member Functions inherited from DoliDB
	prefix ()
	Return the DB prefix found into prefix_db (if it was set manually by doing $dbhandler->prefix_db=...).

	stddevpop ($nameoffield)
	Return SQL string to aggregate using the Standard Deviation of population.

	hintindex ($nameofindex, $mode=1)
	Return SQL string to force an index.

	sanitize ($stringtosanitize, $allowsimplequote=0, $allowsequals=0, $allowsspace=0, $allowschars=1)
	Sanitize a string for SQL forging.

	getRow ($sql)
	Return first result from query as object Note : This method executes a given SQL query and retrieves the first row of results as an object.

	getRows ($sql)
	Return all results from query as an array of objects.

	getNextAutoIncrementId ($table)
	Get the last ID of an auto-increment field of a table.

	prepare ($sql)
	Prepare a SQL statement for execution.

	execute ($stmt, $params=array())
	Execute a statement previously created with prepare().

Public Member Functions inherited from Database
	sanitize ($stringtosanitize)
	Sanitize a string for SQL forging.

Public Attributes
const	LABEL = ''
	@const Database label

const	VERSIONMIN = ''
	@const Version min database

Public Attributes inherited from DoliDB
const	VERSIONMIN = self::VERSIONMIN
	Force subclass to implement VERSIONMIN - required DB version.

const	LABEL = self::LABEL
	Force subclass to implement LABEL - description of DB type.

Protected Member Functions
	startTracing ()
	Start query tracing.

	isFullTracingEnabled ()
	Check if full query tracing is enabled.

	endTracing ($sql, $resql)
	End query tracing.

Detailed Description

TraceableDB class.

Used to log queries into DebugBar

Definition at line 33 of file TraceableDB.php.

Constructor & Destructor Documentation

◆ __construct()

TraceableDB::__construct ( $db )

Constructor.

Parameters

DoliDB $db Database handler

Definition at line 69 of file TraceableDB.php.

References type.

Member Function Documentation

◆ affected_rows()

TraceableDB::affected_rows ( $resultset )

Return the number of lines into the result of a request INSERT, DELETE or UPDATE.

Parameters

resource $resultset Curseur de la requete voulue

Returns: int Number of lines

See also: num_rows()

Implements Database.

Definition at line 195 of file TraceableDB.php.

◆ begin()

TraceableDB::begin ( $textinlog = '' )

Start transaction.

Parameters

string $textinlog Add a small text into log. '' by default.

Returns: int 1 if transaction successfully opened or already opened, 0 if error

Reimplemented from DoliDB.

Definition at line 144 of file TraceableDB.php.

◆ close()

TraceableDB::close ( )

Close database connection.

Returns: boolean True if disconnect successful, false otherwise

See also: connect()

Implements Database.

Definition at line 733 of file TraceableDB.php.

◆ commit()

TraceableDB::commit ( $log = '' )

Validate a database transaction.

Parameters

string $log Add more log to default log line

Returns: int 1 if validation is OK or transaction level no started, 0 if ERROR

Reimplemented from DoliDB.

Definition at line 700 of file TraceableDB.php.

◆ connect()

TraceableDB::connect	(	$host,
		$login,
		$passwd,
		$name,
		$port = 0,
		$forcenew = false )

Connection to server.

Parameters

string	$host	database server host
string	$login	login
string	$passwd	password
string	$name	name of database (not used for mysql, used for pgsql)
int	$port	Port of database server
bool	$forcenew	Force opening of a genuinely new connection instead of reusing one already opened to the same server/database in this process (relevant for pgsql only)

Returns: resource Database access handler

See also: close()

Implements Database.

Definition at line 439 of file TraceableDB.php.

◆ convertSQLFromMysql()

TraceableDB::convertSQLFromMysql	(		$line,
			$type = 'ddl' )

Convert a SQL request in Mysql syntax to native syntax.

Parameters

string	$line	SQL request line to convert
string	$type	Type of SQL order ('ddl' for insert, update, select, delete or 'dml' for create, alter...)

Returns: string SQL request line converted

Implements Database.

Definition at line 182 of file TraceableDB.php.

◆ DDLAddField()

TraceableDB::DDLAddField	(	$table,
		$field_name,
		$field_desc,
		$field_position = "" )

Create a new field into table.

Parameters

string	$table	Name of table
string	$field_name	Name of field to add
	array{type:string,label?:string,enabled?:int<0,2>\|string,position?:int,notnull?:int,visible?:int,noteditable?:int,default?:string,extra?:string,null?:string,index?:int,foreignkey?:string,searchall?:int,isameasure?:int,css?:string,csslist?:string,help?:string,showoncombobox?:int,disabled?:int,arrayofkeyval?:array<int,string>,comment?:string}	$field_desc Associative array of description of the field to insert [parameter name][parameter value]
string	$field_position	Optionnel ex.: "after champtruc"

Returns: int Return integer <0 if KO, >0 if OK

Implements Database.

Definition at line 579 of file TraceableDB.php.

◆ DDLCreateDb()

TraceableDB::DDLCreateDb	(	$database,
		$charset = '',
		$collation = '',
		$owner = '' )

Create a new database Do not use function xxx_create_db (xxx=mysql, ...) as they are deprecated We force to create database with charset this->forcecharset and collate this->forcecollate.

Parameters

string	$database	Database name to create
string	$charset	Charset used to store data
string	$collation	Charset used to sort data
string	$owner	Username of database owner

Returns: resource resource defined if OK, null if KO

Implements Database.

Definition at line 160 of file TraceableDB.php.

◆ DDLCreateTable()

TraceableDB::DDLCreateTable	(	$table,
		$fields,
		$primary_key,
		$type,
		$unique_keys = null,
		$fulltext_keys = null,
		$keys = null )

Create a table into database.

Parameters

string	$table	Name of table
	array<string,array{type:string,label?:string,enabled?:int<0,2>\|string,position?:int,notnull?:int,visible?:int<-2,5>\|string,alwayseditable?:int<0,1>,noteditable?:int<0,1>,default?:string,index?:int,foreignkey?:string,searchall?:int<0,1>,isameasure?:int<0,1>,css?:string,csslist?:string,help?:string,showoncombobox?:int<0,2>,disabled?:int<0,1>,arrayofkeyval?:array<int,string>,autofocusoncreate?:int<0,1>,comment?:string,copytoclipboard?:int<1,2>,validate?:int<0,1>}>	$fields Associative table [field name][table of descriptions]
string	$primary_key	Nom du champ qui sera la clef primaire
string	$type	Type de la table
	?array<string,mixed>	$unique_keys Tableau associatifs Nom de champs qui seront clef unique => valeur
string[]	$fulltext_keys	Tableau des Nom de champs qui seront indexes en fulltext
string[]	$keys	Tableau des champs cles noms => valeur

Returns: int Return integer <0 if KO, >=0 if OK

Implements Database.

Definition at line 544 of file TraceableDB.php.

◆ DDLCreateUser()

TraceableDB::DDLCreateUser	(	$dolibarr_main_db_host,
		$dolibarr_main_db_user,
		$dolibarr_main_db_pass,
		$dolibarr_main_db_name )

Create a user and privileges to connect to database (even if database does not exists yet)

Parameters

string	$dolibarr_main_db_host	Ip serveur
string	$dolibarr_main_db_user	Name of user to create
string	$dolibarr_main_db_pass	Password of user to create
string	$dolibarr_main_db_name	Database name where user must be granted

Returns: int Return integer <0 if KO, >=0 if OK

Implements Database.

Definition at line 660 of file TraceableDB.php.

◆ DDLDescTable()

TraceableDB::DDLDescTable	(		$table,
			$field = "" )

Return a pointer of line with description of a table or field.

Parameters

string	$table	Name of table
string	$field	Optionnel : Name of field if we want description of field

Returns: resource Resource

Implements Database.

Definition at line 626 of file TraceableDB.php.

◆ DDLDropField()

TraceableDB::DDLDropField	(		$table,
			$field_name )

Drop a field from table.

Parameters

string	$table	Name of table
string	$field_name	Name of field to drop

Returns: int Return integer <0 if KO, >0 if OK

Implements Database.

Definition at line 591 of file TraceableDB.php.

◆ DDLDropTable()

TraceableDB::DDLDropTable ( $table )

Drop a table into database.

Parameters

string $table Name of table

Returns: int Return integer <0 if KO, >=0 if OK

Implements Database.

Definition at line 555 of file TraceableDB.php.

◆ DDLGetConnectId()

TraceableDB::DDLGetConnectId ( )

Return connection ID.

Returns: string Id connection

Implements Database.

Definition at line 753 of file TraceableDB.php.

◆ DDLInfoTable()

TraceableDB::DDLInfoTable ( $table )

List information of columns into a table.

Parameters

string $table Name of table

Returns: array<array<string,mixed>> Array with information on table

Implements Database.

Definition at line 711 of file TraceableDB.php.

◆ DDLListTables()

TraceableDB::DDLListTables	(		$database,
			$table = '' )

List tables into a database.

Parameters

string	$database	Name of database
string	$table	Name of table filter ('xxx')

Returns: string[] List of tables in an array

Implements Database.

Definition at line 218 of file TraceableDB.php.

◆ DDLListTablesFull()

TraceableDB::DDLListTablesFull	(		$database,
			$table = '' )

List tables into a database with table info.

Parameters

string	$database	Name of database
string	$table	Name of table filter ('xxx')

Returns: array<array{0:string,1:string}> List of tables in an array

Implements Database.

Definition at line 230 of file TraceableDB.php.

◆ DDLUpdateField()

TraceableDB::DDLUpdateField	(	$table,
		$field_name,
		$field_desc )

Update format of a field into a table.

Parameters

string	$table	Name of table
string	$field_name	Name of field to modify
	array{type:string,label?:string,enabled?:int<0,2>\|string,position?:int,notnull?:int,visible?:int,noteditable?:int,default?:string,index?:int,foreignkey?:string,searchall?:int,isameasure?:int,css?:string,csslist?:string,help?:string,showoncombobox?:int,disabled?:int,arrayofkeyval?:array<int,string>,comment?:string,value?:string,null?:string}	$field_desc Array with description of field format

Returns: int Return integer <0 if KO, >0 if OK

Implements Database.

Definition at line 604 of file TraceableDB.php.

◆ decrypt()

TraceableDB::decrypt ( $value )

Decrypt sensitive data in database.

Parameters

string $value Value to decrypt

Returns: string Decrypted value if used

Implements Database.

Definition at line 263 of file TraceableDB.php.

◆ encrypt()

TraceableDB::encrypt	(		$fieldorvalue,
			$withQuotes = 1 )

Encrypt sensitive data in database Warning: This function includes the escape and add the SQL simple quotes on strings.

Parameters

string	$fieldorvalue	Field name or value to encrypt
int	$withQuotes	Return string including the SQL simple quotes. This param must always be 1 (Value 0 is bugged and deprecated).

Returns: string XXX(field) or XXX('value') or field or 'value'

Implements Database.

Definition at line 689 of file TraceableDB.php.

◆ endTracing()

TraceableDB::endTracing	(		$sql,
			$resql )

protected

End query tracing.

Parameters

string	$sql	query string
mysqli_result \| bool \| resource	$resql	query result

Returns: void

Definition at line 403 of file TraceableDB.php.

References isFullTracingEnabled().

Referenced by query().

◆ errno()

TraceableDB::errno ( )

Return generic error code of last operation.

Returns: string Error code (Examples: DB_ERROR_TABLE_ALREADY_EXISTS, DB_ERROR_RECORD_ALREADY_EXISTS...)

Implements Database.

Definition at line 527 of file TraceableDB.php.

◆ error()

TraceableDB::error ( )

Return description of last error.

Returns: string Error text

Implements Database.

Definition at line 206 of file TraceableDB.php.

◆ escape()

TraceableDB::escape ( $stringtoencode )

Escape a string to insert data.

Parameters

string $stringtoencode String to escape

Returns: string String escaped

Implements Database.

Definition at line 297 of file TraceableDB.php.

◆ escapeforlike()

TraceableDB::escapeforlike ( $stringtoencode )

Escape a string to insert data into a like.

Parameters

string $stringtoencode String to escape

Returns: string String escaped

Implements Database.

Definition at line 308 of file TraceableDB.php.

◆ fetch_array()

TraceableDB::fetch_array ( $resultset )

Return datas as an array.

Parameters

resource $resultset Resultset of request

Returns: array<int|string,mixed>|null|false Result with row

Implements Database.

Definition at line 275 of file TraceableDB.php.

◆ fetch_object()

TraceableDB::fetch_object ( $resultset )

Returns the current line (as an object) for the resultset cursor.

Parameters

resource | PgSql\Connection $resultset Handler of the desired SQL request

Returns: Object Object result line or false if KO or end of cursor

Implements Database.

Definition at line 765 of file TraceableDB.php.

◆ fetch_row()

TraceableDB::fetch_row ( $resultset )

Return datas as an array.

Parameters

resource $resultset Resultset of request

Returns: array<int,mixed>|null|int<0,0> Array

Implements Database.

Definition at line 109 of file TraceableDB.php.

◆ free()

TraceableDB::free ( $resultset = null )

Free last resultset used.

Parameters

resource $resultset Fre cursor

Returns: void

Implements Database.

Definition at line 722 of file TraceableDB.php.

◆ getDefaultCharacterSetDatabase()

TraceableDB::getDefaultCharacterSetDatabase ( )

Return charset used to store data in database.

Returns: string Charset

Implements Database.

Definition at line 646 of file TraceableDB.php.

◆ getDefaultCollationDatabase()

TraceableDB::getDefaultCollationDatabase ( )

Return collation used in database.

Returns: string Collation value

Implements Database.

Definition at line 483 of file TraceableDB.php.

◆ getDriverInfo()

TraceableDB::getDriverInfo ( )

Return version of database client driver.

Returns: string Version string

Implements Database.

Definition at line 517 of file TraceableDB.php.

◆ getListOfCharacterSet()

TraceableDB::getListOfCharacterSet ( )

Return list of available charset that can be used to store data in database.

Returns: ?array<int,array{charset:string,description:string}> List of Charset

Implements Database.

Definition at line 565 of file TraceableDB.php.

◆ getListOfCollation()

TraceableDB::getListOfCollation ( )

Return list of available collation that can be used for database.

Returns: ?array<int,array{collation:string}> List of Collation

Implements Database.

Definition at line 614 of file TraceableDB.php.

◆ getPathOfDump()

TraceableDB::getPathOfDump ( )

Return full path of dump program.

Returns: string Full path of dump program

Implements Database.

Definition at line 507 of file TraceableDB.php.

◆ getPathOfRestore()

TraceableDB::getPathOfRestore ( )

Return full path of restore program.

Returns: string Full path of restore program

Implements Database.

Definition at line 332 of file TraceableDB.php.

◆ getServerParametersValues()

TraceableDB::getServerParametersValues ( $filter = '' )

Return value of server parameters.

Parameters

string $filter Filter list on a particular value

Returns: array<string,string> Array of key-values (key=>value)

Implements Database.

Definition at line 462 of file TraceableDB.php.

◆ getServerStatusValues()

TraceableDB::getServerStatusValues ( $filter = '' )

Return value of server status.

Parameters

string $filter Filter list on a particular value

Returns: array<string,string> Array of key-values (key=>value)

Implements Database.

Definition at line 473 of file TraceableDB.php.

◆ getVersion()

TraceableDB::getVersion ( )

Return version of database server.

Returns: string Version string

Implements Database.

Definition at line 636 of file TraceableDB.php.

◆ getVersionArray()

TraceableDB::getVersionArray ( )

Return version of database server into an array.

Returns: string[] Version array

Reimplemented from DoliDB.

Definition at line 170 of file TraceableDB.php.

◆ idate()

TraceableDB::idate	(		$param,
			$gm = 'tzserver' )

Convert (by PHP) a GM Timestamp date into a string date with PHP server TZ to insert into a date field.

Function to use to build INSERT, UPDATE or WHERE predica

Parameters

int\|''	$param Date TMS to convert
'gmt'\|'tzserver'	$gm 'gmt'=Input information are GMT values, 'tzserver'=Local to server TZ

Returns: string Date in a string YYYY-MM-DD HH:MM:SS

Reimplemented from DoliDB.

Definition at line 123 of file TraceableDB.php.

◆ ifsql()

TraceableDB::ifsql	(	$test,
		$resok,
		$resko )

Format a SQL IF.

Parameters

string	$test	Test string (example: 'cd.statut=0', 'field IS NULL')
string	$resok	result if test equal
string	$resko	result if test non equal

Returns: string SQL string

Reimplemented from DoliDB.

Definition at line 84 of file TraceableDB.php.

◆ isFullTracingEnabled()

TraceableDB::isFullTracingEnabled ( )

protected

Check if full query tracing is enabled.

Full tracing captures backtrace for ALL queries, not just failed ones. This is useful for debugging but has performance impact.

Returns: bool True if full tracing is enabled

Definition at line 388 of file TraceableDB.php.

Referenced by endTracing().

◆ jdate()

TraceableDB::jdate	(		$string,
			$gm = false )

Convert (by PHP) a PHP server TZ string date into a Timestamps date (GMT if gm=true) 19700101020000 -> 3600 with TZ+1 and gmt=0 19700101020000 -> 7200 whatever is TZ if gmt=1.

Parameters

?string	$string	Date in a string (YYYYMMDDHHMMSS, YYYYMMDD, YYYY-MM-DD HH:MM:SS)
bool \| int \| string	$gm	1=Input information are GMT values, otherwise local to server TZ

Returns: int|'' Date TMS or ''

Reimplemented from DoliDB.

Definition at line 675 of file TraceableDB.php.

◆ last_insert_id()

TraceableDB::last_insert_id	(		$tab,
			$fieldid = 'rowid' )

Get last ID after an insert INSERT.

Parameters

string	$tab	Table name concerned by insert. Needed for Postgresql compatibility (not useful for MySql)
string	$fieldid	Field name

Returns: int Id of row

Implements Database.

Definition at line 321 of file TraceableDB.php.

◆ lasterrno()

TraceableDB::lasterrno ( )

Return last error code.

Returns: string lasterrno

Reimplemented from DoliDB.

Definition at line 133 of file TraceableDB.php.

◆ lasterror()

TraceableDB::lasterror ( )

Return last error label.

Returns: string lasterror

Reimplemented from DoliDB.

Definition at line 286 of file TraceableDB.php.

◆ lastquery()

TraceableDB::lastquery ( )

Return last request executed with query()

Returns: string Last query

Reimplemented from DoliDB.

Definition at line 240 of file TraceableDB.php.

◆ lastqueryerror()

TraceableDB::lastqueryerror ( )

Return last query in error.

Returns: string lastqueryerror

Reimplemented from DoliDB.

Definition at line 743 of file TraceableDB.php.

◆ num_rows()

TraceableDB::num_rows ( $resultset )

Return number of lines for result of a SELECT.

Parameters

resource $resultset Resulset of requests

Returns: int Nb of lines

See also: affected_rows()

Implements Database.

Definition at line 496 of file TraceableDB.php.

◆ order()

TraceableDB::order	(		$sortfield = null,
			$sortorder = null )

Define sort criteria of request.

Parameters

string	$sortfield	List of sort fields
string	$sortorder	Sort order

Returns: string String to provide syntax of a sort sql string

Reimplemented from DoliDB.

Definition at line 252 of file TraceableDB.php.

◆ plimit()

TraceableDB::plimit	(		$limit = 0,
			$offset = 0 )

Define limits and offset of request.

Parameters

int	$limit	Maximum number of lines returned (-1=conf->liste_limit, 0=no limit)
int	$offset	Numero of line from where starting fetch

Returns: string String with SQL syntax to add a limit and offset

Reimplemented from DoliDB.

Definition at line 451 of file TraceableDB.php.

◆ query()

TraceableDB::query	(	$query,
		$usesavepoint = 0,
		$type = 'auto',
		$result_mode = 0 )

Execute a SQL request and return the resultset.

Parameters

string	$query	SQL query string
int	$usesavepoint	0=Default mode, 1=Run a savepoint before and a rollback to savepoint if error (this allow to have some request with errors inside global transactions). Note that with Mysql, this parameter is not used as Myssql can already commit a transaction even if one request is in error, without using savepoints.
string	$type	Type of SQL order ('ddl' for insert, update, select, delete or 'dml' for create, alter...)
int	$result_mode	Result mode

Returns: resource Resultset of answer

Implements Database.

Definition at line 358 of file TraceableDB.php.

References endTracing(), and startTracing().

◆ regexpsql()

TraceableDB::regexpsql	(	$subject,
		$pattern,
		$sqlstring = 0 )

format a sql regexp

Parameters

string	$subject	field name to test
string	$pattern	sql pattern to match
int	$sqlstring	0=the string being tested is a hard coded string, 1=the string is a field

Returns: string sql string

Reimplemented from DoliDB.

Definition at line 97 of file TraceableDB.php.

◆ rollback()

TraceableDB::rollback ( $log = '' )

Cancel a transaction and go back to initial data values.

Parameters

string $log Add more log to default log line

Returns: resource|int 1 if cancellation is ok or transaction not open, 0 if error

Reimplemented from DoliDB.

Definition at line 343 of file TraceableDB.php.

◆ select_db()

TraceableDB::select_db ( $database )

Select a database.

Parameters

string $database Name of database

Returns: boolean true if OK, false if KO

Implements Database.

Definition at line 778 of file TraceableDB.php.

◆ startTracing()

TraceableDB::startTracing ( )

protected

Start query tracing.

Returns: void

Definition at line 374 of file TraceableDB.php.

Referenced by query().

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

dolibarr_dev/htdocs/debugbar/class/TraceableDB.php

Public Member Functions

Public Attributes

Protected Member Functions

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ affected_rows()

◆ begin()

◆ close()

◆ commit()

◆ connect()

◆ convertSQLFromMysql()

◆ DDLAddField()

◆ DDLCreateDb()

◆ DDLCreateTable()

◆ DDLCreateUser()

◆ DDLDescTable()

◆ DDLDropField()

◆ DDLDropTable()

◆ DDLGetConnectId()

◆ DDLInfoTable()

◆ DDLListTables()

◆ DDLListTablesFull()

◆ DDLUpdateField()

◆ decrypt()

◆ encrypt()

◆ endTracing()

◆ errno()

◆ error()

◆ escape()

◆ escapeforlike()

◆ fetch_array()

◆ fetch_object()

◆ fetch_row()

◆ free()

◆ getDefaultCharacterSetDatabase()

◆ getDefaultCollationDatabase()

◆ getDriverInfo()

◆ getListOfCharacterSet()

◆ getListOfCollation()

◆ getPathOfDump()

◆ getPathOfRestore()

◆ getServerParametersValues()

◆ getServerStatusValues()

◆ getVersion()

◆ getVersionArray()

◆ idate()

◆ ifsql()

◆ isFullTracingEnabled()

◆ jdate()

◆ last_insert_id()

◆ lasterrno()

◆ lasterror()

◆ lastquery()

◆ lastqueryerror()

◆ num_rows()

◆ order()

◆ plimit()

◆ query()

◆ regexpsql()

◆ rollback()

◆ select_db()

◆ startTracing()