How to use mssql and sql server databases in Yii2
This article is to share with you about how to use mssql and sql server databases in Yii2. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article.
1. First find the scheme where yii2 parses mssql:
Vendor/yiisoft/yii2/db/mssql/Schema.php
two。 Change the parsing code:
The function for ⑴ to find findColumns is about 232 lines.
The ⑵ alternative resolution code is as follows:
/ * *
* Collects the metadata of table columns.
* @ param TableSchema $table the table metadata
* @ return boolean whether the table exists in the database
* /
Protected function findColumns ($table)
{
$pdo = $this- > db- > getSlavePdo ()
$version = explode ('.', $pdo- > getAttribute (\ PDO::ATTR_SERVER_VERSION))
/ / var_dump ($version); exit
If (intval ($version [0] catalogName! = = null) {
$columnsTableName = "{$table- > catalogName}. {$columnsTableName}"
$whereSql. = "AND [T1]. [table_catalog] ='{$table- > catalogName}'"
}
If ($table- > schemaName! = = null) {
$whereSql. = "AND [T1]. [table_schema] ='{$table- > schemaName}'"
}
$columnsTableName = $this- > quoteTableName ($columnsTableName)
$sql = db- > createCommand ($sql)-> queryAll ()
If (empty ($columns)) {
Return false
}
} catch (\ Exception $e) {
Return false
}
Foreach ($columns as $column) {
$column = $this- > loadColumnSchema ($column)
Foreach ($table- > primaryKey as $primaryKey) {
If (strcasecmp ($column- > name, $primaryKey) = 0) {
$column- > isPrimaryKey = true
Break
}
}
If ($column- > isPrimaryKey & & $column- > autoIncrement) {
$table- > sequenceName =''
}
$table- > columns [$column- > name] = $column
}
Return true
}
3. Analyze this code:
⑴ gets the version of the database:
$pdo = $this- > db- > getSlavePdo ()
$version = explode ('.', $pdo- > getAttribute (\ PDO::ATTR_SERVER_VERSION))
⑵ resolves according to version:
If (intval ($version [0] true) is fine.
The above is how to use mssql and sql server databases in Yii2. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.
