1 files changed, 48 insertions, 0 deletions
diff --git a/tests/simple_unit/DbCommon/MssqlColumnTest.php b/tests/simple_unit/DbCommon/MssqlColumnTest.php
new file mode 100644
index 00000000..db2df03b
--- /dev/null
+++ b/tests/simple_unit/DbCommon/MssqlColumnTest.php
@@ -0,0 +1,48 @@
+<?php
+
+Prado::using('System.Data.*');
+Prado::using('System.Data.Common.Mssql.TMssqlMetaData');
+Prado::using('System.Data.DataGateway.TTableGateway');
+
+class MssqlColumnTest extends UnitTestCase
+{
+	function get_conn()
+	{
+		return new TDbConnection('mssql:host=localhost\\sqlexpress', 'test', 'test01');
+	}
+
+	/**
+	 * @return TMssqlMetaData
+	 */
+	function meta_data()
+	{
+		return new TMssqlMetaData($this->get_conn());
+	}
+
+	function test_insert()
+	{
+		$table = new TTableGateway('table1', $this->get_conn());
+		$this->assertTrue(is_int($table->insert(array('name'=>'cool'))));
+	}
+
+/*	function test_meta()
+	{
+		$result = $this->meta_data()->getTableInfo("bar");
+		var_dump($result);
+	}
+*/
+	/*function test_insert()
+	{
+		$table = new TTableGateway('table1', $this->get_conn());
+		//var_dump($table->insert(array('name'=>'cool')));
+		//var_dump($table->getLastInsertId());
+		$criteria = new TSqlCriteria();
+		$criteria->Limit = 5;
+		$criteria->Offset = 2;
+
+		$result = $table->findAll($criteria)->readAll();
+		var_dump($result);
+	}*/
+}
+
+?>
+\ No newline at end of file