From f1c27f46100582a1e52a27b616bf468e849068e7 Mon Sep 17 00:00:00 2001
From: rojaro <>
Date: Wed, 15 Jul 2009 07:58:26 +0000
Subject: moved System.Db to System.Testing.Data and updated classes
 accordingly

---
 .../Testing/Data/Schema/mssql/TMssqlPdoAdapter.php | 74 ++++++++++++++++++++++
 1 file changed, 74 insertions(+)
 create mode 100755 framework/Testing/Data/Schema/mssql/TMssqlPdoAdapter.php

(limited to 'framework/Testing/Data/Schema/mssql/TMssqlPdoAdapter.php')

diff --git a/framework/Testing/Data/Schema/mssql/TMssqlPdoAdapter.php b/framework/Testing/Data/Schema/mssql/TMssqlPdoAdapter.php
new file mode 100755
index 00000000..6f8777dd
--- /dev/null
+++ b/framework/Testing/Data/Schema/mssql/TMssqlPdoAdapter.php
@@ -0,0 +1,74 @@
+<?php
+/**
+ * TMssqlPdo class file
+ *
+ * @author Christophe Boulain <Christophe.Boulain@gmail.com>
+ * @link http://www.yiiframework.com/
+ * @copyright Copyright &copy; 2008-2009 Yii Software LLC
+ * @license http://www.yiiframework.com/license/
+ */
+
+/**
+ * This is an extension of default PDO class for mssql driver only
+ * It provides some missing functionalities of pdo driver
+ * @author Christophe Boulain <Christophe.Boulain@gmail.com>
+ * @version $Id: TMssqlPdoAdapter.php 2679 2009-06-15 07:49:42Z Christophe.Boulain $
+ * @package System.Testing.Data.schema.mssql
+ * @since 1.0.4
+ */
+class TMssqlPdoAdapter extends PDO
+{
+	/**
+	 * Get the last inserted id value
+	 * MSSQL doesn't support sequence, so, argument is ignored
+	 *
+	 * @param string sequence name. Defaults to null
+	 * @return int last inserted id
+	 */
+	public function lastInsertId ($sequence=NULL)
+	{
+		return $this->query('SELECT SCOPE_IDENTITY()')->fetchColumn();
+	}
+
+	/**
+	 * Begin a transaction
+	 *
+	 * Is is necessary to override pdo's method, as mssql pdo drivers
+	 * does not support transaction
+	 *
+	 * @return boolean
+	 */
+	public function beginTransaction ()
+	{
+		$this->exec('BEGIN TRANSACTION');
+		return true;
+	}
+
+	/**
+	 * Commit a transaction
+	 *
+	 * Is is necessary to override pdo's method, as mssql pdo drivers
+	 * does not support transaction
+	 *
+	 * @return boolean
+	 */
+	public function commit ()
+	{
+		$this->exec('COMMIT TRANSACTION');
+		return true;
+	}
+
+	/**
+	 * Rollback a transaction
+	 *
+	 * Is is necessary to override pdo's method, ac mssql pdo drivers
+	 * does not support transaction
+	 *
+	 * @return boolean
+	 */
+	public function rollBack ()
+	{
+		$this->exec('ROLLBACK TRANSACTION');
+		return true;
+	}
+}
-- 
cgit v1.2.3