用cypress连接SQL数据库

Question

我想知道是否有人能帮我解决这个问题。我正在尝试使用cypress连接到SQL数据库，但它一直显示错误消息。我正在使用以下代码：

Cypress 3.6.1

NodeJs 12.13.0

npm 6.12.0

Package.json具有以下依赖关系：

 "devDependencies": {
 "cypress": "^3.6.0",
 "cypress-sql-server": "^1.0.0"
  },
 "dependencies": {
 "tedious": "^6.6.2"
  }

Cypress.json具有以下格式的DB凭据：

"env": {
"db": { 
"username": "", "password": "", "server": "localhost",
"options": { "database": "", "encrypt": true, "rowCollectionOnRequestCompletion": true } 
 }
}

插件在cypress\plugins\index.js文件中初始化：

const sqlServer = require('cypress-sql-server');    
module.exports = (on, config) => {
tasks = sqlServer.loadDBPlugin(config.env.db);
on('task', tasks); 
}

在cypress\support\index.js文件中导入的命令：

import sqlServer from 'cypress-sql-server';
sqlServer.loadDBCommands();

等级库文件有以下测试：

cy.sqlServer('SELECT * FROM test');

Cypress显示以下错误：

CypressError: cy.task('sqlServer:execute') failed with the following error:

> ConnectionError: Failed to connect to localhost\MSSQLSERVER:1433 - getaddrinfo ENOTFOUND 
localhost\MSSQLSERVER
at ConnectionError (C:\CypressTest\node_modules\cypress-sql- 
server\node_modules\tedious\lib\errors.js:13:12)
at Connection.socketError (C:\CypressTest\node_modules\cypress-sql- 
server\node_modules\tedious\lib\connection.js:1008:28)
at C:\CypressTest\node_modules\cypress-sql-server\node_modules\tedious\lib\connection.js:874:21
at GetAddrInfoReqWrap.callback (C:\CypressTest\node_modules\cypress-sql- 
server\node_modules\tedious\lib\connector.js:48:16)
at GetAddrInfoReqWrap.onlookupall [as oncomplete] (dns.js:70:17)

Answer 1

尝试将"localhost\MSSQLSERVER“解析为IPv4或IPv6地址失败。

打开SQL Server Management Studio，窗口标题将告诉您确切的计算机名称。假设它是"DEV123"，然后在您的服务器设置中，而不是：

"server":"localhost"

使用：

"server":"localhost\\DEV123"