1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 

<?php

/**
 * MvcCore
 *
 * This source file is subject to the BSD 3 License
 * For the full copyright and license information, please view
 * the LICENSE.md file that are distributed with this source code.
 *
 * @copyright   Copyright (c) 2016 Tom Flidr (https://github.com/mvccore)
 * @license  https://mvccore.github.io/docs/mvccore/5.0.0/LICENCE.md
 */

namespace MvcCore\Ext\Models\Db\Providers\Connections;

class       SqlSrv 
extends     \MvcCore\Ext\Models\Db\Connection
implements  \MvcCore\Ext\Models\Db\Model\IConstants,
            \MvcCore\Ext\Models\Db\Models\SqlSrvs\IConstants {

    /**
     * MS SQL Server connection is always multistatement.
     * @var bool
     */
    protected $multiStatements = TRUE;

    /**
     * Enabled/disabled multiple batches on a single connection.
     * @var bool
     */
    protected $multipleActiveResultSets = FALSE;

    /**
     * @inheritDocs
     * @param string $identifierName
     * @return string
     */
    public function QuoteName ($identifierName) {
        return "[{$identifierName}]";
    }
    
    /**
     * Get `TRUE` if enabled multiple batches on a single connection,
     * `FALSE` by default.
     * @return bool
     */
    public function GetMultipleActiveResultSets () {
        return $this->multipleActiveResultSets;
    }

    /**
     * @inheritDocs
     * @param int $flags Transaction isolation, read/write mode and consistent snapshot option.
     * @param string $name String without spaces to identify transaction in logs.
     * @throws \PDOException|\RuntimeException
     * @return bool
     */
    public function BeginTransaction ($flags = 0, $name = NULL) {
        
        if ($this->inTransaction) {
            $cfg = $this->GetConfig();
            unset($cfg['password']);
            $toolClass = \MvcCore\Application::GetInstance()->GetToolClass();
            throw new \RuntimeException(
                'Connection has opened transaction already ('.($toolClass::EncodeJson($cfg)).').'
            );
        }

        $sqlItems = [];

        if (($flags & self::TRANS_ISOLATION_REPEATABLE_READ) > 0) {
            $sqlItems[] = "SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;";
        } else if (($flags & self::TRANS_ISOLATION_READ_COMMITTED) > 0) {
            $sqlItems[] = "SET TRANSACTION ISOLATION LEVEL READ COMMITTED;";
        } else if (($flags & self::TRANS_ISOLATION_READ_UNCOMMITTED) > 0) {
            $sqlItems[] = "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;";
        } else if (($flags & self::TRANS_ISOLATION_SHAPSHOT) > 0) {
            $sqlItems[] = "SET TRANSACTION ISOLATION LEVEL SNAPSHOT;";
        } else if (($flags & self::TRANS_ISOLATION_SERIALIZABLE) > 0) {
            $sqlItems[] = "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;";
        }

        if ($name !== NULL) {
            $toolClass = \MvcCore\Application::GetInstance()->GetToolClass();
            $this->transactionName = $toolClass::GetUnderscoredFromPascalCase($name);
            $sqlItems[] = "/* trans_start:{$this->transactionName} */";
        }
        $sqlItems[] = "BEGIN TRANSACTION;";
        
        if ($this->multiStatements) {
            $this->provider->exec(implode("\n", $sqlItems));
        } else {
            foreach ($sqlItems as $sqlItem)
                $this->provider->exec($sqlItem);
        }

        $this->inTransaction = TRUE;

        return TRUE;
    }

    /**
     * @inheritDocs
     * @param int $flags Transaction chaininig.
     * @throws \PDOException
     * @return bool
     */
    public function Commit ($flags = 0) {
        if (!$this->inTransaction) 
            return FALSE;
        $sqlItems = [];

        if ($this->transactionName !== NULL) 
            $sqlItems[] = "/* trans_commit:{$this->transactionName} */";

        $sqlItems[] = "COMMIT TRANSACTION;";

        $this->provider->exec(implode("\n", $sqlItems));
        
        $this->inTransaction  = FALSE;
        $this->transactionName = NULL;
        
        return TRUE;
    }

    /**
     * Rolls back a transaction.
     * @param int $flags Transaction chaininig.
     * @throws \PDOException
     * @return bool
     */
    public function RollBack ($flags = NULL) {
        if (!$this->inTransaction) 
            return FALSE;
        
        $sqlItems = [];
        
        if ($this->transactionName !== NULL) 
            $sqlItems[] = "/* trans_rollback:{$this->transactionName} */";

        $sqlItems[] = "ROLLBACK TRANSACTION;";

        $this->provider->exec(implode("\n", $sqlItems));

        $this->inTransaction  = FALSE;
        $this->transactionName = NULL;
        
        return TRUE;
    }



    /**
     * @inheritDocs
     * @param \Throwable $e 
     * @return bool
     */
    protected function isConnectionLost (\Throwable $e) {
        return FALSE;
        // TODO: try to simulate lost connection error...
        /*
        $prevError = $e->getPrevious();
        $error = $prevError instanceof \PDOException
            ? $prevError
            : $e;
        return (
            $error instanceof \PDOException &&
            mb_strpos(mb_strtolower($e->getMessage()), 'server has gone away') !== FALSE
        );
        */
    }

    /**
     * Set up connection specific properties depends on this driver.
     * @return void
     */
    protected function setUpConnectionSpecifics () {
        parent::setUpConnectionSpecifics();
        
        $dsnLower = ';' . trim(mb_strtolower($this->dsn), ';') . ';';
        $this->multipleActiveResultSets = (
            mb_strpos($dsnLower, ';multipleactiveresultsets=true;') !== FALSE ||
            mb_strpos($dsnLower, ';multipleactiveresultsets=1;') !== FALSE
        );
    }
}