CMssqlPdoAdapter

Package system.db.schema.mssql
Inheritance class CMssqlPdoAdapter » PDO
Source Code framework/db/schema/mssql/CMssqlPdoAdapter.php
This is an extension of default PDO class for mssql driver only It provides some missing functionalities of pdo driver

Public Methods

Method Description Defined By
__construct() PDO
__sleep() PDO
__wakeup() PDO
beginTransaction() Begin a transaction CMssqlPdoAdapter
commit() Commit a transaction CMssqlPdoAdapter
errorCode() PDO
errorInfo() PDO
exec() PDO
getAttribute() PDO
getAvailableDrivers() PDO
inTransaction() PDO
lastInsertId() Get the last inserted id value CMssqlPdoAdapter
prepare() PDO
query() PDO
quote() PDO
rollBack() Rollback a transaction CMssqlPdoAdapter
setAttribute() PDO

Method Details

beginTransaction() method

public boolean beginTransaction()
{return} boolean
Source Code: framework/db/schema/mssql/CMssqlPdoAdapter.php#39 (show)
public function beginTransaction ()
{
    
$this->exec('BEGIN TRANSACTION');
    return 
true;
}

Begin a transaction

Is is necessary to override pdo's method, as mssql pdo drivers does not support transaction

commit() method

public boolean commit()
{return} boolean
Source Code: framework/db/schema/mssql/CMssqlPdoAdapter.php#53 (show)
public function commit ()
{
    
$this->exec('COMMIT TRANSACTION');
    return 
true;
}

Commit a transaction

Is is necessary to override pdo's method, as mssql pdo drivers does not support transaction

lastInsertId() method

public integer lastInsertId(string|null $sequence=NULL)
$sequence string|null sequence name. Defaults to null
{return} integer last inserted id
Source Code: framework/db/schema/mssql/CMssqlPdoAdapter.php#26 (show)
public function lastInsertId ($sequence=NULL)
{
    return 
$this->query('SELECT CAST(COALESCE(SCOPE_IDENTITY(), @@IDENTITY) AS bigint)')->fetchColumn();
}

Get the last inserted id value MSSQL doesn't support sequence, so, argument is ignored

rollBack() method

public boolean rollBack()
{return} boolean
Source Code: framework/db/schema/mssql/CMssqlPdoAdapter.php#67 (show)
public function rollBack ()
{
    
$this->exec('ROLLBACK TRANSACTION');
    return 
true;
}

Rollback a transaction

Is is necessary to override pdo's method, ac mssql pdo drivers does not support transaction

© 2008–2017 by Yii Software LLC
Licensed under the three clause BSD license.
http://www.yiiframework.com/doc/api/1.1/CMssqlPdoAdapter