propel-adapter-MSSQL
[ class tree: propel-adapter-MSSQL ] [ index: propel-adapter-MSSQL ] [ all elements ]

Class: MssqlDebugPDO

Source Location: /adapter/MSSQL/MssqlDebugPDO.php

Class Overview

PDO
   |
   --PropelPDO
      |
      --DebugPDO
         |
         --MssqlDebugPDO

dblib doesn't support transactions so we need to add a workaround for transactions, last insert ID, and quoting


Author(s):

Methods


Inherited Constants

Class: PDO (Internal Class)

ATTR_AUTOCOMMIT = 0
ATTR_CASE = 8
ATTR_CLIENT_VERSION = 5
ATTR_CONNECTION_STATUS = 7
ATTR_CURSOR = 10
ATTR_CURSOR_NAME = 9
ATTR_DEFAULT_FETCH_MODE = 19
ATTR_DRIVER_NAME = 16
ATTR_EMULATE_PREPARES = 20
ATTR_ERRMODE = 3
ATTR_FETCH_CATALOG_NAMES = 15
ATTR_FETCH_TABLE_NAMES = 14
ATTR_MAX_COLUMN_LEN = 18
ATTR_ORACLE_NULLS = 11
ATTR_PERSISTENT = 12
ATTR_PREFETCH = 1
ATTR_SERVER_INFO = 6
ATTR_SERVER_VERSION = 4
ATTR_STATEMENT_CLASS = 13
ATTR_STRINGIFY_FETCHES = 17
ATTR_TIMEOUT = 2
CASE_LOWER = 2
CASE_NATURAL = 0
CASE_UPPER = 1
CURSOR_FWDONLY = 0
CURSOR_SCROLL = 1
ERRMODE_EXCEPTION = 2
ERRMODE_SILENT = 0
ERRMODE_WARNING = 1
ERR_NONE = '00000'
FETCH_ASSOC = 2
FETCH_BOTH = 4
FETCH_BOUND = 6
FETCH_CLASS = 8
FETCH_CLASSTYPE = 262144
FETCH_COLUMN = 7
FETCH_FUNC = 10
FETCH_GROUP = 65536
FETCH_INTO = 9
FETCH_KEY_PAIR = 12
FETCH_LAZY = 1
FETCH_NAMED = 11
FETCH_NUM = 3
FETCH_OBJ = 5
FETCH_ORI_ABS = 4
FETCH_ORI_FIRST = 2
FETCH_ORI_LAST = 3
FETCH_ORI_NEXT = 0
FETCH_ORI_PRIOR = 1
FETCH_ORI_REL = 5
FETCH_PROPS_LATE = 1048576
FETCH_SERIALIZE = 524288
FETCH_UNIQUE = 196608
NULL_EMPTY_STRING = 1
NULL_NATURAL = 0
NULL_TO_STRING = 2
PARAM_BOOL = 5
PARAM_EVT_ALLOC = 0
PARAM_EVT_EXEC_POST = 3
PARAM_EVT_EXEC_PRE = 2
PARAM_EVT_FETCH_POST = 5
PARAM_EVT_FETCH_PRE = 4
PARAM_EVT_FREE = 1
PARAM_EVT_NORMALIZE = 6
PARAM_INPUT_OUTPUT = -2147483648
PARAM_INT = 1
PARAM_LOB = 3
PARAM_NULL = 0
PARAM_STMT = 4
PARAM_STR = 2
PGSQL_ATTR_DISABLE_NATIVE_PREPARED_STATEMENT = 1000

Inherited Variables

Inherited Methods

Class: DebugPDO

DebugPDO::__construct()
Creates a DebugPDO instance representing a connection to a database.
DebugPDO::configureStatementClass()
Configures the PDOStatement class for this connection.
DebugPDO::exec()
Execute an SQL statement and return the number of affected rows.
DebugPDO::getDebugSnapshot()
Returns a snapshot of the current values of some functions useful in debugging.
DebugPDO::getLastExecutedQuery()
Get the SQL code for the latest query executed by Propel
DebugPDO::getLoggingConfig()
Returns a named configuration item from the Propel runtime configuration, from under the 'debugpdo.logging' prefix. If such a configuration setting hasn't been set, the given default value will be returned.
DebugPDO::getLogPrefix()
Returns a prefix that may be prepended to a log line, containing debug information according to the current configuration.
DebugPDO::getQueryCount()
Returns the number of queries this DebugPDO instance has performed on the database connection.
DebugPDO::getReadableBytes()
Returns a human-readable representation of the given byte count.
DebugPDO::getStatementClass()
Gets the custom classname to use for PDOStatement.
DebugPDO::incrementQueryCount()
Increments the number of queries performed by this DebugPDO instance.
DebugPDO::log()
Logs the method call or SQL using the Propel::log() method or a registered logger class.
DebugPDO::prepare()
Prepares a statement for execution and returns a statement object.
DebugPDO::query()
Executes an SQL statement, returning a result set as a PDOStatement object. Despite its signature here, this method takes a variety of parameters.
DebugPDO::setLastExecutedQuery()
Set the SQL code for the latest query executed by Propel
DebugPDO::setLogger()
Sets a logger to use.
DebugPDO::setLogLevel()
Sets the logging level to use for logging method calls and SQL statements.
DebugPDO::setStatementClass()
Sets the custom classname to use for PDOStatement.
DebugPDO::__destruct()
If so configured, makes an entry to the log of the state of this DebugPDO instance just prior to its destruction.

Class: PropelPDO

PropelPDO::beginTransaction()
Overrides PDO::beginTransaction() to prevent errors due to already-in-progress transaction.
PropelPDO::clearStatementCache()
Clears any stored prepared statements for this connection.
PropelPDO::commit()
Overrides PDO::commit() to only commit the transaction if we are in the outermost transaction nesting level.
PropelPDO::decrementNestedTransactionCount()
Decrements the current transaction depth by one.
PropelPDO::forceRollBack()
Rollback the whole transaction, even if this is a nested rollback and reset the nested transaction count to 0.
PropelPDO::getAttribute()
Gets a connection attribute.
PropelPDO::getNestedTransactionCount()
Gets the current transaction depth.
PropelPDO::incrementNestedTransactionCount()
Increments the current transaction depth by one.
PropelPDO::isInTransaction()
Is this PDO connection currently in-transaction? This is equivalent to asking whether the current nested transaction count is greater than 0.
PropelPDO::prepare()
Overrides PDO::prepare() to add query caching support if the PropelPDO::PROPEL_ATTR_CACHE_PREPARES was set to true.
PropelPDO::rollBack()
Overrides PDO::rollBack() to only rollback the transaction if we are in the outermost
PropelPDO::setAttribute()
Sets a connection attribute.
PropelPDO::setNestedTransactionCount()
Set the current transaction depth.

Class: PDO (Internal Class)

constructor __construct ( $dsn, $username, $passwd, [$options = ] )
beginTransaction ( )
commit ( )
errorCode ( )
errorInfo ( )
exec ( $query )
getAttribute ( $attribute )
getAvailableDrivers ( )
lastInsertId ( [$seqname = ] )
prepare ( $statment, [$options = ] )
query ( )
quote ( $string, [$paramtype = ] )
rollBack ( )
setAttribute ( $attribute, $value )
__sleep ( )
__wakeup ( )

Class Details

[line 8]
dblib doesn't support transactions so we need to add a workaround for transactions, last insert ID, and quoting



Tags:

author:  Francois Zaninotto
author:  Cameron Brunner <cameron.brunner@gmail.com>
author:  Hans Lellelid <hans@xmpl.org>
author:  Christian Abegg <abegg.ch@gmail.com>
author:  Jarno Rantanen <jarno.rantanen@tkk.fi>


[ Top ]


Class Methods


method beginTransaction [line 16]

void beginTransaction( )

Begin a transaction.

It is necessary to override the abstract PDO transaction functions here, as the PDO driver for MSSQL does not support transactions.




Tags:

access:  public


Overrides PropelPDO::beginTransaction() (Overrides PDO::beginTransaction() to prevent errors due to already-in-progress transaction.)

[ Top ]

method commit [line 34]

void commit( )

Commit a transaction.

It is necessary to override the abstract PDO transaction functions here, as the PDO driver for MSSQL does not support transactions.




Tags:

access:  public


Overrides PropelPDO::commit() (Overrides PDO::commit() to only commit the transaction if we are in the outermost transaction nesting level.)

[ Top ]

method forceRollBack [line 79]

void forceRollBack( )

Rollback the whole transaction, even if this is a nested rollback and reset the nested transaction count to 0.

It is necessary to override the abstract PDO transaction functions here, as the PDO driver for MSSQL does not support transactions.




Tags:

access:  public


Overrides PropelPDO::forceRollBack() (Rollback the whole transaction, even if this is a nested rollback and reset the nested transaction count to 0.)

[ Top ]

method lastInsertId [line 95]

void lastInsertId( [ $seqname = null])



Tags:

access:  public


Parameters:

   $seqname  

[ Top ]

method quoteIdentifier [line 101]

void quoteIdentifier( $text)



Tags:

access:  public


Parameters:

   $text  

[ Top ]

method rollBack [line 57]

void rollBack( )

Roll-back a transaction.

It is necessary to override the abstract PDO transaction functions here, as the PDO driver for MSSQL does not support transactions.




Tags:

access:  public


Overrides PropelPDO::rollBack() (Overrides PDO::rollBack() to only rollback the transaction if we are in the outermost)

[ Top ]

method useQuoteIdentifier [line 106]

void useQuoteIdentifier( )



Tags:

access:  public


[ Top ]


Documentation generated on Tue, 12 Jan 2010 23:08:10 +0000 by phpDocumentor 1.4.3