Inheritance diagram for tx_dbal_sqlengine:

Collaboration diagram for tx_dbal_sqlengine:

Public Member Functions
	init ($config, $pObj)
	resetStatusVars ()
	exec_INSERTquery ($table, $fields_values)
	exec_UPDATEquery ($table, $where, $fields_values)
	exec_DELETEquery ($table, $where)
	exec_SELECTquery ($select_fields, $from_table, $where_clause, $groupBy, $orderBy, $limit)
	sql_query ($query)
	sql_error ()
	sql_insert_id ()
	sql_affected_rows ()
	quoteStr ($str)
	admin_get_tables ()
	admin_get_fields ($tableName)
	admin_get_keys ($tableName)
	admin_query ($query)
	readDataSource ($table)
	saveDataSource ($table)
	selectFromData ($table, $where)
	select_evalSingle ($table, $config, &$itemKeys)
	getResultSet ($keys, $table, $fieldList)
	debug_printResultSet ($array)
Public Attributes
	$data = array()
	$errorStatus = ''
	$lastInsertedId = 0
	$lastAffectedRows = 0
Private Member Functions
	processAccordingToConfig (&$value, $fInfo)

Detailed Description

Definition at line 100 of file class.tx_dbal_sqlengine.php.

Member Function Documentation

tx_dbal_sqlengine::admin_get_fields ( $ tableName )

(DUMMY) Returns information about each field in the $table

Parameters:

string Table name

Returns:: array Field information in an associative array with fieldname => field row

Reimplemented in tx_dbal_handler_rawmysql, tx_dbal_handler_xmldb, and tx_dbal_handler_openoffice.

Definition at line 482 of file class.tx_dbal_sqlengine.php.

Referenced by exec_INSERTquery(), and exec_UPDATEquery().

tx_dbal_sqlengine::admin_get_keys ( $ tableName )

(DUMMY) Returns information about each index key in the $table

Parameters:

string Table name

Returns:: array Key information in a numeric array

Reimplemented in tx_dbal_handler_xmldb, tx_dbal_handler_rawmysql, and tx_dbal_handler_openoffice.

Definition at line 493 of file class.tx_dbal_sqlengine.php.

tx_dbal_sqlengine::admin_get_tables ( )

(DUMMY) Returns the list of tables from the database

Returns:: array Tables in an array (tablename is in both key and value)

Todo:: Should return table details in value! see t3lib_db::admin_get_tables()

Reimplemented in tx_dbal_handler_rawmysql, tx_dbal_handler_xmldb, and tx_dbal_handler_openoffice.

Definition at line 471 of file class.tx_dbal_sqlengine.php.

tx_dbal_sqlengine::admin_query ( $ query )

(DUMMY) mysql() wrapper function, used by the Install Tool and EM for all queries regarding management of the database!

Parameters:

string Query to execute

Returns:: pointer Result pointer

Reimplemented in tx_dbal_handler_xmldb, tx_dbal_handler_rawmysql, and tx_dbal_handler_openoffice.

Definition at line 504 of file class.tx_dbal_sqlengine.php.

References $query, and sql_query().

tx_dbal_sqlengine::debug_printResultSet ( $ array )

Returns the result set (in array) as HTML table. For debugging.

Parameters:

array Result set array (array of rows)

Returns:: string HTML table

Definition at line 741 of file class.tx_dbal_sqlengine.php.

tx_dbal_sqlengine::exec_DELETEquery	(	$	table,
		$	where
	)

Execute DELETE query

Parameters:

string	Table to delete from
string	WHERE clause

Returns:: boolean TRUE on success and FALSE on failure (error is set internally)

Reimplemented in tx_dbal_handler_rawmysql.

Definition at line 320 of file class.tx_dbal_sqlengine.php.

References t3lib_sqlparser\parseWhereClause(), readDataSource(), resetStatusVars(), saveDataSource(), and selectFromData().

tx_dbal_sqlengine::exec_INSERTquery	(	$	table,
		$	fields_values
	)

Execute an INSERT query

Parameters:

string	Table name
array	Field values as key=>value pairs.

Returns:: boolean TRUE on success and FALSE on failure (error is set internally)

Reimplemented in tx_dbal_handler_rawmysql.

Definition at line 193 of file class.tx_dbal_sqlengine.php.

References admin_get_fields(), processAccordingToConfig(), readDataSource(), resetStatusVars(), and saveDataSource().

tx_dbal_sqlengine::exec_SELECTquery	(	$	select_fields,
		$	from_table,
		$	where_clause,
		$	groupBy,
		$	orderBy,
		$	limit
	)

Execute SELECT query

Parameters:

string	List of fields to select from the table. This is what comes right after "SELECT ...". Required value.
string	Table(s) from which to select. This is what comes right after "FROM ...". Required value.
string	Optional additional WHERE clauses put in the end of the query. NOTICE: You must escape values in this argument with $this->fullQuoteStr() yourself! DO NOT PUT IN GROUP BY, ORDER BY or LIMIT!
string	Optional GROUP BY field(s), if none, supply blank string.
string	Optional ORDER BY field(s), if none, supply blank string.
string	Optional LIMIT value ([begin,]max), if none, supply blank string.