<?php
require_once 'include/database/DBManagerFactory.php';

class DBManagerFactoryTest extends Sugar_PHPUnit_Framework_TestCase
{
    private $_oldSugarConfig;
    
    public function setUp()
    {
        $this->_oldSugarConfig = $GLOBALS['sugar_config'];
    }
    
    public function tearDown() 
    {
        $GLOBALS['sugar_config'] = $this->_oldSugarConfig;
    }
    
    public function testGetInstance()
    {
        $db = &DBManagerFactory::getInstance();
        
        $this->assertTrue($db instanceOf DBManager,"Should return a DBManger object");
    }
    
    public function testGetInstanceCheckMysqlDriverChoosen()
    {
        if ( $GLOBALS['db']->dbType != 'mysql' )
            $this->markTestSkipped('Only applies to SQL Server');
        
        $db = &DBManagerFactory::getInstance();
        
        if ( function_exists('mysqli_connect') )
            $this->assertTrue($db instanceOf MysqliManager,"Should return a MysqliManager object");
        else
            $this->assertTrue($db instanceOf MysqlManager,"Should return a MysqlManager object");
    }
    
    /**
     * @group bug27781
     */
    public function testGetInstanceMssqlDefaultSelection()
    {
        if ( $GLOBALS['db']->dbType != 'mssql' )
            $this->markTestSkipped('Only applies to SQL Server');
        
        $GLOBALS['sugar_config']['db_mssql_force_driver'] = '';
        
        $db = &DBManagerFactory::getInstance();
        
        if ( function_exists('sqlsrv_connect') )
            $this->assertTrue($db instanceOf SqlsrvManager,"Should return a SqlsrvManager object");
        elseif ( is_freetds() )
            $this->assertTrue($db instanceOf FreeTDSManager,"Should return a FreeTDSManager object");
        else
            $this->assertTrue($db instanceOf MssqlManager,"Should return a MssqlManager object");
    }
    
    /**
     * @group bug27781
     */
    public function testGetInstanceMssqlForceFreetdsSelection()
    {
        if ( $GLOBALS['db']->dbType != 'mssql' || !is_freetds() )
            $this->markTestSkipped('Only applies to SQL Server FreeTDS');
        
        $GLOBALS['sugar_config']['db_mssql_force_driver'] = 'freetds';
        
        $db = &DBManagerFactory::getInstance();
        
        $this->assertTrue($db instanceOf FreeTDSManager,"Should return a FreeTDSManager object");
    }
    
    /**
     * @group bug27781
     */
    public function testGetInstanceMssqlForceMssqlSelection()
    {
        if ( $GLOBALS['db']->dbType != 'mssql' || !function_exists('mssql_connect') )
            $this->markTestSkipped('Only applies to SQL Server with the Native PHP mssql Driver');
        
        $GLOBALS['sugar_config']['db_mssql_force_driver'] = 'mssql';
        
        $db = &DBManagerFactory::getInstance();
        
        if ( is_freetds() )
            $this->assertTrue($db instanceOf MssqlManager,"Should return a MssqlManager object");
        elseif ( function_exists('mssql_connect') )
        $this->assertTrue($db instanceOf MssqlManager,"Should return a MssqlManager object");
        else
            $this->assertTrue($db instanceOf SqlsrvManager,"Should return a SqlsrvManager object");
    }
    
    /**
     * @group bug27781
     */
    public function testGetInstanceMssqlForceSqlsrvSelection()
    {
        if ( $GLOBALS['db']->dbType != 'mssql' || !function_exists('sqlsrv_connect') )
            $this->markTestSkipped('Only applies to SQL Server');
        
        $GLOBALS['sugar_config']['db_mssql_force_driver'] = 'sqlsrv';
        
        $db = &DBManagerFactory::getInstance();
        
        if ( is_freetds() && !function_exists('sqlsrv_connect') )
            $this->assertTrue($db instanceOf FreeTDSManager,"Should return a FreeTDSManager object");
        elseif ( function_exists('mssql_connect') && !function_exists('sqlsrv_connect') )
            $this->assertTrue($db instanceOf MssqlManager,"Should return a MssqlManager object");
        else
        $this->assertTrue($db instanceOf SqlsrvManager,"Should return a SqlsrvManager object");
    }
}