Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.