<?php
/**
 * Pimf_Pdo
 *
 * PHP Version 5
 *
 * LICENSE
 *
 * This source file is subject to the new BSD license that is bundled
 * with this package in the file LICENSE.
 * It is also available through the world-wide-web at this URL:
 * http://krsteski.de/new-bsd-license/
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to hide@address.com so we can send you a copy immediately.
 *
 * @copyright Copyright (c) 2010-2011 Gjero Krsteski (http://krsteski.de)
 * @license http://krsteski.de/new-bsd-license New BSD License
 */

/**
 * Connection management to SQL Server
 *
 * @package Pimf_Pdo
 * @author Gjero Krsteski <hide@address.com>
 */
class Pimf_Pdo_Sqlserver extends Pimf_Pdo_Connector
{
  protected $options = array(
    PDO::ATTR_CASE              => PDO::CASE_LOWER,
    PDO::ATTR_ERRMODE           => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_ORACLE_NULLS      => PDO::NULL_NATURAL,
    PDO::ATTR_STRINGIFY_FETCHES => false,
  );

  /**
   * @param array $config
   * @return Pimf_Pdo
   */
  public function connect(array $config)
  {
    // This connection string format can also be used to connect 
    // to Azure SQL Server databases. 
    $port = (isset($config['port'])) ? ','.$config['port'] : '';

    //check for dblib for mac users connecting to mssql
    if (isset($config['dsn_type']) && !empty($config['dsn_type']) and $config['dsn_type'] == 'dblib') {
      $dsn = "dblib:host={$config['host']}{$port};dbname={$config['database']}";
    } else {
      $dsn = "sqlsrv:Server={$config['host']}{$port};Database={$config['database']}";
    }

    return new Pimf_Pdo($dsn, $config['username'], $config['password'], $this->options($config));
  }
}