12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 |
- <?php
- /**
- * @link http://www.yiiframework.com/
- * @copyright Copyright (c) 2008 Yii Software LLC
- * @license http://www.yiiframework.com/license/
- */
- namespace yii\db\mssql;
- /**
- * This is an extension of the default PDO class of MSSQL and DBLIB drivers.
- * It provides workarounds for improperly implemented functionalities of the MSSQL and DBLIB drivers.
- *
- * @author Timur Ruziev <[email protected]>
- * @since 2.0
- */
- class PDO extends \PDO
- {
- /**
- * Returns value of the last inserted ID.
- * @param string|null $sequence the sequence name. Defaults to null.
- * @return integer last inserted ID value.
- */
- public function lastInsertId($sequence = null)
- {
- return $this->query('SELECT CAST(COALESCE(SCOPE_IDENTITY(), @@IDENTITY) AS bigint)')->fetchColumn();
- }
- /**
- * Starts a transaction. It is necessary to override PDO's method as MSSQL PDO driver does not
- * natively support transactions.
- * @return boolean the result of a transaction start.
- */
- public function beginTransaction()
- {
- $this->exec('BEGIN TRANSACTION');
- return true;
- }
- /**
- * Commits a transaction. It is necessary to override PDO's method as MSSQL PDO driver does not
- * natively support transactions.
- * @return boolean the result of a transaction commit.
- */
- public function commit()
- {
- $this->exec('COMMIT TRANSACTION');
- return true;
- }
- /**
- * Rollbacks a transaction. It is necessary to override PDO's method as MSSQL PDO driver does not
- * natively support transactions.
- * @return boolean the result of a transaction rollback.
- */
- public function rollBack()
- {
- $this->exec('ROLLBACK TRANSACTION');
- return true;
- }
- }
|