You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
54 lines
1.2 KiB
54 lines
1.2 KiB
1 year ago
|
<?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 never
|
||
|
|
*/
|
||
|
|
public function _backup(?array $prefs = null)
|
||
|
|
{
|
||
|
|
throw new DatabaseException('Unsupported feature of the database platform you are using.');
|
||
|
|
}
|
||
|
|
}
|