1 files changed, 32 insertions, 0 deletions
diff --git a/test/QueryBuilderMssqlTest.php b/test/QueryBuilderMssqlTest.php
new file mode 100644
index 0000000..be67b33
--- /dev/null
+++ b/test/QueryBuilderMssqlTest.php
@@ -0,0 +1,32 @@
+<?php
+
+class QueryBuilderMssqlTest extends PHPUnit_Framework_TestCase {
+
+    public function setUp() {
+        // Enable logging
+        ORM::configure('logging', true);
+
+        // Set up the dummy database connection
+        $db = new MockMsSqlPDO('sqlite::memory:');
+        ORM::set_db($db);
+    }
+
+    public function tearDown() {
+        ORM::reset_config();
+        ORM::reset_db();
+    }
+
+    public function testFindOne() {
+        ORM::for_table('widget')->find_one();
+        $expected = 'SELECT TOP 1 * FROM "widget"';
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+
+    public function testLimit() {
+        ORM::for_table('widget')->limit(5)->find_many();
+        $expected = 'SELECT TOP 5 * FROM "widget"';
+        $this->assertEquals($expected, ORM::get_last_query());
+    }
+    
+}
+