Class: OracleDatabase

Source Location: /oracle.inc.php

Class Overview

Object
   |
   --Persistent
      |
      --Component
         |
         --CustomConnection
            |
            --OracleDatabase

OracleDatabase provides discrete control over a connection to a single Oracle database in a database application.

Author(s):

Inherited Variables

Inherited Methods

Class: CustomConnection

CustomConnection::__construct()
CustomConnection::BeginTrans(): Begins a new transaction against the database server.
CustomConnection::Close(): Closes the connection.
CustomConnection::CompleteTrans(): Permanently stores updates, insertions, and deletions of data associated with
CustomConnection::DBDate(): Returns a date formatted to be used on this database, depending on the type
CustomConnection::defaultClients()
CustomConnection::defaultConnected()
CustomConnection::defaultDataSets()
CustomConnection::defaultOnAfterConnect()
CustomConnection::defaultOnAfterDisconnect()
CustomConnection::defaultOnBeforeConnect()
CustomConnection::defaultOnBeforeDisconnect()
CustomConnection::defaultOnCustomConnect()
CustomConnection::defaultOnLogin()
CustomConnection::DoConnect(): Provides the interface for a method that opens a connection.
CustomConnection::DoDisconnect(): Provides the interface for a method that terminates the connection.
CustomConnection::getOnCustomConnect()
CustomConnection::loaded()
CustomConnection::MetaFields(): Returns the fieldnames for the table
CustomConnection::Open(): Opens the connection.
CustomConnection::Param(): Returns a parameter formatted depending on the database type
CustomConnection::Prepare(): Sends a query to the server for optimization prior to execution.
CustomConnection::QuoteStr(): Quote a string depending on the database type
CustomConnection::readClients(): Returns the clients of this database
CustomConnection::readConnected(): Determines whether a connection has been established to the remote source of data.
CustomConnection::readDataSets(): Provides an indexed array of all active datasets for a database component.
CustomConnection::readOnAfterConnect(): Occurs after a connection is established.
CustomConnection::readOnAfterDisconnect(): Occurs after the connection closes.
CustomConnection::readOnBeforeConnect(): Occurs immediately before establishing a connection.
CustomConnection::readOnBeforeDisconnect(): Occurs immediately before the connection closes.
CustomConnection::readOnLogin(): Occurs when an application connects to a database.
CustomConnection::SendConnectEvent(): Send a connect event to all the datasets, both for connecting and disconnecting
CustomConnection::setOnCustomConnect()
CustomConnection::writeClients()
CustomConnection::writeConnected()
CustomConnection::writeDataSets()
CustomConnection::writeOnAfterConnect()
CustomConnection::writeOnAfterDisconnect()
CustomConnection::writeOnBeforeConnect()
CustomConnection::writeOnBeforeDisconnect()
CustomConnection::writeOnLogin()

Class: Component

Component::__construct(): Component constructor
Component::ajaxCall(): Dumps the javascript code to make an ajax call to the server.
Component::callEvent(): Calls a server event.
Component::defaultName()
Component::defaultTag()
Component::dumpChildrenFormItems(): This method is called by the page just after dumping the starting form tag.
Component::dumpChildrenHeaderCode(): Dumps the header code for all the children
Component::dumpChildrenJavascript(): Dumps the javascript code for all the children
Component::dumpFormItems(): Dumps code just after the form tag, useful to dump hidden fields for state retrieving for non visible components
Component::dumpHeaderCode(): Dumps header code required
Component::dumpHiddenKeyFields(): Dumps hidden field values for the key record
Component::dumpJavascript(): Dumps the javascript code needed by this component
Component::dumpJSEvent(): Dumps javascript code for an event
Component::fixupProperty(): Resolves the right reference to an object property
Component::generateAjaxEvent(): Returns the javascript code to generate an ajax call.
Component::getName(): Specifies the name for the component. The name is used as an identifier and should be unique.
Component::getTag(): A versatile property of every Component that can be used in any way you want
Component::hasValidDataField(): Returns true if a valid data field is attached to the component
Component::init(): Initializes a component
Component::insertComponent(): Inserts a component into the component's collection
Component::loaded(): Initializes the component after the form file has been read into memory.
Component::loadedChildren(): Calls childrens loaded
Component::loadResource(): Loads this component from a string
Component::preinit(): Method called before init()
Component::readAccessibility(): Provides accessibility info to the embedded RPC engine.
Component::readComponentCount(): Indicates the number of components owned by the component.
Component::readComponents(): Lists all the components owned by this component.
Component::readControlState(): A flag to know the state of the control, csLoading, csDesigning
Component::readDataFieldValue(): This property returns the value of the datafield if any.
Component::readFromResource(): Reads a component from a resource file
Component::readNamePath(): Specifies the path to uniquely identify a component, qualified by the owner when required.
Component::readOwner(): Indicates the component that is responsible for streaming and freeing this component.
Component::removeComponent(): Removes a component from the component's collection
Component::serializeChildren(): Serializes all children
Component::setName()
Component::setTag()
Component::unserializeChildren(): Unserializes all children by calling unserialize for all the components
Component::updateDataField(): Updates the field on the dataset attached, if any
Component::writeControlState()

Class: Persistent

Persistent::allowserialize(): This method provides an opportunity for the component developer to prevent the serialization/unserialization of a property.
Persistent::assign(): Assigns the source properties to this object.
Persistent::assignError(): Raises an assignation error.
Persistent::assignTo(): Assigns this object to another object.
Persistent::inSession(): This method determines if this object exists in the current session.
Persistent::readNamePath(): Used to serialize/unserialize. It returns the full path to identify this component.
Persistent::readOwner(): Owner of the component.
Persistent::serialize(): Stores this object into the session.
Persistent::unserialize(): This method uses PHP reflection to iterate through published properties (the ones starting with get) and retrieve the properties stored by a previous serialize() call.

Class: Object

Object::__construct(): Constructs an object and initializes its data before the object is first used.
Object::className(): Returns a string indicating the type of the object instance (as opposed to the type of the variable passed as an argument).
Object::classNameIs(): Determines whether an object is of a specific type.
Object::classParent(): Returns the type of the immediate ancestor of a class.
Object::inheritsFrom(): Determines the relationship of two object types.
Object::methodExists(): Check if a method exists declared on this object instance.
Object::readProperty(): Reads a property from the streams
Object::__get(): To virtualize properties
Object::__set(): To virtualize properties

Class Details

[line 38]
OracleDatabase provides discrete control over a connection to a single Oracle database in a database application.

Use OracleDatabase to specify the connection information so OracleDataset components can connect to the database.

Tags:

link:

http://www.php.net/manual/en/ref.Oracle.php

[ Top ]

Class Variables

$autoCommit = true

[line 77]

Tags:

access:

protected

Type:

mixed

[ Top ]

$autoRollback = false

[line 51]

Type:

mixed

[ Top ]

$connectSID = true

[line 53]

Type:

mixed

[ Top ]

$databaseType = 'oci8'

[line 59]

Type:

mixed

[ Top ]

$firstrows = true

[line 57]

Type:

mixed

[ Top ]

$NLS_DATE_FORMAT = 'YYYY-MM-DD'

[line 55]

Type:

mixed

[ Top ]

$selectOffsetAlg1 = 100

[line 58]

Type:

mixed

[ Top ]

$_charset = ""

[line 62]

Tags:

access:

protected

Type:

mixed

[ Top ]

$_connected = "0"

[line 46]

Tags:

access:

protected

Type:

mixed

[ Top ]

$_connection = null

[line 40]

Tags:

access:

public

Type:

mixed

[ Top ]

$_connectionID = false

[line 50]

Type:

mixed

[ Top ]

$_databasename = ""

[line 42]

Tags:

access:

protected

Type:

mixed

[ Top ]

$_debug = 0

[line 41]

Tags:

access:

protected

Type:

mixed

[ Top ]

$_dialect = 3

[line 227]

Tags:

access:

protected

Type:

mixed

[ Top ]

$_dictionary = ""

[line 47]

Tags:

access:

protected

Type:

mixed

[ Top ]

$_dictionaryproperties = false

[line 48]

Tags:

access:

protected

Type:

mixed

[ Top ]

$_host = ""

[line 43]

Tags:

access:

protected

Type:

mixed

[ Top ]

$_initdate = true

[line 54]

Type:

mixed

[ Top ]

$_username = ""

[line 44]

Tags:

access:

protected

Type:

mixed

[ Top ]

$_userpassword = ""

[line 45]

Tags:

access:

protected

Type:

mixed

[ Top ]

$_usesid = 0

[line 67]

Tags:

access:

protected

Type:

mixed

[ Top ]

Class Methods

constructor __construct [line 292]

OracleDatabase __construct(
[
$aowner = null])

Overrides CustomConnection::__construct() (parent method not documented)

Parameters:

$aowner

[ Top ]

method BeginTrans [line 100]

void BeginTrans(
)

Overrides CustomConnection::BeginTrans() (Begins a new transaction against the database server.)

[ Top ]

method Checkbind [line 298]

void Checkbind(

$sql, 
$params)

Parameters:

	$sql
	$params

[ Top ]

method CompleteTrans [line 105]

void CompleteTrans(
[
$ok = true])

Overrides CustomConnection::CompleteTrans() (Permanently stores updates, insertions, and deletions of data associated with)

Parameters:

$ok

[ Top ]

method connect_oci8 [line 508]

void connect_oci8(

$argHostname, 
$argUsername, 
$argPassword, 
$argDatabasename, [
$mode = 0])

Parameters:

	$argHostname
	$argUsername
	$argPassword
	$argDatabasename
	$mode

[ Top ]

method createDictionaryTable [line 741]

boolean createDictionaryTable(
)

Creates the dictionary table on the database

Use this method to create the dictionary table on the database you are connection. This method issues the create table command and creates the table with the right structure. You have to connect to the database before use this method and Dictionary property must be set to the tablename.

[ Top ]

method databases [line 769]

array databases(
)

Return all the databases using the connection information

[ Top ]

method DBDate [line 277]

void DBDate(

$input)

Overrides CustomConnection::DBDate() (Returns a date formatted to be used on this database, depending on the type)

Parameters:

$input

[ Top ]

method defaultCharset [line 65]

void defaultCharset(
)

[ Top ]

method defaultDebug [line 156]

void defaultDebug(
)

[ Top ]

method defaultDialect [line 238]

void defaultDialect(
)

[ Top ]

method defaultUseSID [line 73]

void defaultUseSID(
)

[ Top ]

method Dobind [line 304]

void Dobind(

$rset, 
&$params)

Parameters:

	$rset
	&$params

[ Top ]

method DoConnect [line 494]

void DoConnect(
)

Overrides CustomConnection::DoConnect() (Provides the interface for a method that opens a connection.)

[ Top ]

method DoDisconnect [line 590]

void DoDisconnect(
)

Overrides CustomConnection::DoDisconnect() (Provides the interface for a method that terminates the connection.)

[ Top ]

method execute [line 326]

object execute(
string
$query, [
&$params = array()], array
$params)

Executes a query on the database

Use this method to execute an SQL sentence on the database server

Parameters:

string	$query	Query to execute
array	$params	Not used
	&$params

[ Top ]

method executecursor [line 452]

void executecursor(

$query, [
&$par = array()], 
$cursorname)

Parameters:

	$query
	&$par
	$cursorname

[ Top ]

method executelimit [line 370]

object executelimit(
string
$query, integer
$lmtcount, integer
$lmtstart, [array
$params = array()])

Executes a limited query on the database

Use this method to execute an SQL sentence on the database server using LIMIT clause.

Parameters:

string	$query	Query to execute
integer	$lmtcount	Rows to get
integer	$lmtstart	First row to start counting
array	$params	Parameters to use on the query

[ Top ]

method ExecuteSelectLimit [line 383]

void &ExecuteSelectLimit(

$sql, [
$lmtcount = -1], [
$lmtstart = -1], [
$inputarr = false])

Parameters:

	$sql
	$lmtcount
	$lmtstart
	$inputarr

[ Top ]

method extractIndexes [line 652]

array &extractIndexes(
string
$table, [boolean
$primary = FALSE])

Return indexes for a table

This method extract the indexes from the table and returns an array with that information.

Parameters:

string	$table	Table name to look for
boolean	$primary	If false, only non-primary keys will be returned

[ Top ]

method getCharset [line 63]

void getCharset(
)

[ Top ]

method getConnected [line 143]

void getConnected(
)

[ Top ]

method getDatabaseName [line 180]

string getDatabaseName(
)

Specifies the name of the database to associate with this database component.

Use DatabaseName to specify the name of the database to use with a database component.

Note: Setting DatabaseName when the Connected property is true requires you to close and reopen the database.

[ Top ]

method getDebug [line 154]

boolean getDebug(
)

Sets the debug information provided by the component.

Use this property, when set to true, to get more information about the connection process to address any issue you get.

[ Top ]

method getDialect [line 236]

string getDialect(
)

Specifies the dialect to be used when connecting to the server

Reserved for future use.

[ Top ]

method getDictionary [line 167]

string getDictionary(
)

Specifies the tablename on this database that holds dictionary information

A dictionary is a set of information about each field of each table, which data-aware components use to show information about the table in a human-readable format, for example, the title for each field, the width for a column, etc

[ Top ]

method getHost [line 190]

string getHost(
)

This properties specifies where to find the server to connect to.

Use this property to set the host that runs the server you want to connect to.

[ Top ]

method GetIndexesFromTable [line 659]

void GetIndexesFromTable(

$table, [
$primary = FALSE], [
$owner = false])

Parameters:

	$table
	$primary
	$owner

[ Top ]

method getOnAfterConnect [line 215]

void getOnAfterConnect(
)

[ Top ]

method getOnAfterDisconnect [line 221]

void getOnAfterDisconnect(
)

[ Top ]

method getOnBeforeConnect [line 218]

void getOnBeforeConnect(
)

[ Top ]

method getOnBeforeDisconnect [line 224]

void getOnBeforeDisconnect(
)

[ Top ]

method getUserName [line 201]

string getUserName(
)

The username you want to use to connect to the database server.

Set this property with the name of the user you want to use to connect to the database server.

[ Top ]

method getUserPassword [line 212]

string getUserPassword(
)

The password for the username you want to use to connect to the database server.

Set this property with the password for the user you want to use to connect to the database server.

[ Top ]

method getUseSID [line 68]

void getUseSID(
)

[ Top ]

method MetaFields [line 86]

void MetaFields(

$tablename)

Overrides CustomConnection::MetaFields() (Returns the fieldnames for the table)

Parameters:

$tablename

[ Top ]

method Param [line 282]

void Param(

$input)

Overrides CustomConnection::Param() (Returns a parameter formatted depending on the database type)

Parameters:

$input

[ Top ]

method Prepare [line 249]

void Prepare(

$query, [
$cursor = false])

Prepares a query to be executed and performs parameter optimizations

Example of usage:

$stmt = $this->Prepare('insert into emp (empno, ename) values (:empno, :ename)');

Overrides CustomConnection::Prepare() (Sends a query to the server for optimization prior to execution.)

Parameters:

	$query
	$cursor

[ Top ]

method PrepareSP [line 271]

void PrepareSP(

$query)

Parameters:

$query

[ Top ]

method QuoteStr [line 287]

void QuoteStr(

$input)

Overrides CustomConnection::QuoteStr() (Quote a string depending on the database type)

Parameters:

$input

[ Top ]

method readConnected [line 142]

void readConnected(
)

Overrides CustomConnection::readConnected() (Determines whether a connection has been established to the remote source of data.)

[ Top ]

method readDictionaryProperties [line 727]

array readDictionaryProperties(
)

Array containing all the information in array format about the dictionary

Use this property to provide information about the dictionary but using a PHP array instead a database table.

[ Top ]

method readFieldDictionaryProperties [line 607]

array readFieldDictionaryProperties(
string
$table, string
$field)

Return properties for a field

Parameters:

string	$table
string	$field

[ Top ]

method readUseSID [line 71]

void readUseSID(
)

[ Top ]

method RollbackTrans [line 128]

void RollbackTrans(
)

[ Top ]

method setCharset [line 64]

void setCharset(

$value)

Parameters:

$value

[ Top ]

method setConnected [line 144]

void setConnected(

$value)

Parameters:

$value

[ Top ]

method setDatabaseName [line 181]

void setDatabaseName(

$value)

Parameters:

$value

[ Top ]

method setDebug [line 155]

void setDebug(

$value)

Parameters:

$value

[ Top ]

method setDialect [line 237]

void setDialect(

$value)

Parameters:

$value

[ Top ]

method setDictionary [line 168]

void setDictionary(

$value)

Parameters:

$value

[ Top ]

method setHost [line 191]

void setHost(

$value)

Parameters:

$value

[ Top ]

method setOnAfterConnect [line 216]

void setOnAfterConnect(

$value)

Parameters:

$value

[ Top ]

method setOnAfterDisconnect [line 222]

void setOnAfterDisconnect(

$value)

Parameters:

$value

[ Top ]

method setOnBeforeConnect [line 219]

void setOnBeforeConnect(

$value)

Parameters:

$value

[ Top ]

method setOnBeforeDisconnect [line 225]

void setOnBeforeDisconnect(

$value)

Parameters:

$value

[ Top ]

method setUserName [line 202]

void setUserName(

$value)

Parameters:

$value

[ Top ]

method setUserPassword [line 213]

void setUserPassword(

$value)

Parameters:

$value

[ Top ]

method setUseSID [line 69]

void setUseSID(

$value)

Parameters:

$value

[ Top ]

method tables [line 782]

array tables(
[
$ttype = false], [
$showSchema = false], [
$mask = false])

Return tables on this database

This method returns an array containing all the table names stored in the database.

Parameters:

	$ttype
	$showSchema
	$mask

[ Top ]

method writeDictionaryProperties [line 728]

void writeDictionaryProperties(

$value)

Parameters:

$value

[ Top ]

method writeUseSID [line 72]

void writeUseSID(

$value)

Parameters:

$value

[ Top ]

Documentation generated on Sat, 13 Jun 2009 10:51:54 -0700 by phpDocumentor 1.4.1