Utils
extends BaseUtils
in package
Utils for SQLSRV
Table of Contents
- $db : object
- Database object
- $listDatabases : string
- List databases statement
- $optimizeTable : string
- OPTIMIZE TABLE statement
- $repairTable : string|bool
- REPAIR TABLE statement
- __construct() : mixed
- Class constructor
- _backup() : mixed
- Platform dependent version of the backup function.
- backup() : mixed
- Database Backup
- databaseExists() : bool
- Determine if a particular database exists
- getCSVFromResult() : string
- Generate CSV from a query result object
- getXMLFromResult() : string
- Generate XML data from a query result object
- listDatabases() : array<string|int, mixed>|bool
- List databases
- optimizeDatabase() : mixed
- Optimize Database
- optimizeTable() : bool
- Optimize Table
- repairTable() : mixed
- Repair Table
Properties
$db
Database object
protected
object
$db
$listDatabases
List databases statement
protected
string
$listDatabases
= 'EXEC sp_helpdb'
$optimizeTable
OPTIMIZE TABLE statement
protected
string
$optimizeTable
= 'ALTER INDEX all ON %s REORGANIZE'
$repairTable
REPAIR TABLE statement
protected
string|bool
$repairTable
= false
Methods
__construct()
Class constructor
public
__construct(ConnectionInterface &$db) : mixed
Parameters
- $db : ConnectionInterface
Return values
mixed —_backup()
Platform dependent version of the backup function.
public
_backup([array<string|int, mixed>|null $prefs = null ]) : mixed
Parameters
- $prefs : array<string|int, mixed>|null = null
Return values
mixed —backup()
Database Backup
public
backup([array<string|int, mixed>|string $params = [] ]) : mixed
Parameters
- $params : array<string|int, mixed>|string = []
Tags
Return values
mixed —databaseExists()
Determine if a particular database exists
public
databaseExists(string $databaseName) : bool
Parameters
- $databaseName : string
Return values
bool —getCSVFromResult()
Generate CSV from a query result object
public
getCSVFromResult(ResultInterface $query[, string $delim = ',' ][, string $newline = "
" ][, string $enclosure = '"' ]) : string
Parameters
- $query : ResultInterface
-
Query result object
- $delim : string = ','
-
Delimiter (default: ,)
- $newline : string = " "
-
Newline character (default: \n)
- $enclosure : string = '"'
-
Enclosure (default: ")
Return values
string —getXMLFromResult()
Generate XML data from a query result object
public
getXMLFromResult(ResultInterface $query[, array<string|int, mixed> $params = [] ]) : string
Parameters
- $query : ResultInterface
-
Query result object
- $params : array<string|int, mixed> = []
-
Any preferences
Return values
string —listDatabases()
List databases
public
listDatabases() : array<string|int, mixed>|bool
Tags
Return values
array<string|int, mixed>|bool —optimizeDatabase()
Optimize Database
public
optimizeDatabase() : mixed
Tags
Return values
mixed —optimizeTable()
Optimize Table
public
optimizeTable(string $tableName) : bool
Parameters
- $tableName : string
Tags
Return values
bool —repairTable()
Repair Table
public
repairTable(string $tableName) : mixed
Parameters
- $tableName : string