Gecko [ tradesense.co.ke ]

Name	Size	Permission
Builder.php	18.42 KB	-rw-r--r--
Connection.php	14.53 KB	-rw-r--r--
Forge.php	12.59 KB	-rw-r--r--
PreparedQuery.php	2.73 KB	-rw-r--r--
Result.php	4.65 KB	-rw-r--r--
Utils.php	1.23 KB	-rw-r--r--

Code Editor : Utils.php

<?php

/**
 * This file is part of CodeIgniter 4 framework.
 *
 * (c) CodeIgniter Foundation <admin@codeigniter.com>
 *
 * For the full copyright and license information, please view
 * the LICENSE file that was distributed with this source code.
 */

namespace CodeIgniter\Database\SQLSRV;

use CodeIgniter\Database\BaseUtils;
use CodeIgniter\Database\ConnectionInterface;
use CodeIgniter\Database\Exceptions\DatabaseException;

/**
 * Utils for SQLSRV
 */
class Utils extends BaseUtils
{
    /**
     * List databases statement
     *
     * @var string
     */
    protected $listDatabases = 'EXEC sp_helpdb'; // Can also be: EXEC sp_databases

/**
     * OPTIMIZE TABLE statement
     *
     * @var string
     */
    protected $optimizeTable = 'ALTER INDEX all ON %s REORGANIZE';

public function __construct(ConnectionInterface &$db)
    {
        parent::__construct($db);

$this->optimizeTable = 'ALTER INDEX all ON  ' . $this->db->schema . '.%s REORGANIZE';
    }

/**
     * Platform dependent version of the backup function.
     *
     * @return mixed
     */
    public function _backup(?array $prefs = null)
    {
        throw new DatabaseException('Unsupported feature of the database platform you are using.');
    }
}

${this.title}

Code Editor : Utils.php