<?php

require_once 'creole/ConnectionTest.php';

/**
 * MSSQL unit tests.
 * 
 * 
 * @author Hans Lellelid <hide@address.com>
 * @version $Revision: 1.3 $
 */
class MSSQLConnectionTest extends ConnectionTest {
        
     /**
     * Test the applyLimit() method.  By default this method will not modify the values provided.
     * Subclasses must override this method to test for appropriate SQL modifications.
     */
    public function testApplyLimit() {        
        
        $sql = "SELECT * FROM sampletable WHERE category = 5";        
        $offset = 5;
        $limit = 50;
        
        $this->conn->applyLimit($sql, $offset, $limit);
        
        $this->assertEquals("SELECT * FROM sampletable WHERE category = 5", $sql, 0, "Expected unchanged SQL for MS SQL Server.");
    }

}