我有一个docker-compose.yml文件:
version: "3.7"
services:
app:
build: .
ports:
- 3000:3000
working_dir: /app
volumes:
- ./:/app
depends_on:
- db
db:
image: "mcr.microsoft.com/mssql/server:2019-latest"
ports:
- 1433:1433
environment:
SA_PASSWORD: "Thieu@098551298"
ACCEPT_EULA: "Y"
volumes:
- mssql-data:/var/opt/mssql
volumes:
mssql-data:
文件 Dockerfile:
FROM node:12-alpine
ENV NODE_ENV=production
WORKDIR /app
COPY ["package.json", "package-lock.json*", "./"]
RUN npm install --production
COPY . .
CMD [ "node", "server.js" ]
文件 server.js:
var express = require("express");
var app = express();
var { ExecuteSQL } = require("./sql");
app.get("/", async (req, res) => {
var s = await ExecuteSQL("select *from post");
res.send(s.recordset);
});
app.listen(3000, () => console.log("listening on port 3000"));
还有 sql.js:
var sql = require("mssql");
var config = {
user: "sa",
password: "Thieu@098551298",
server: "localhost",
database: "blog",
options: {
enableArithAbort: true,
trustServerCertificate: true,
},
};
function ExecuteSQL(query) {
return new Promise((resolve, reject) => {
sql.connect(config, (err, db) => {
if (err) reject(err);
var request = new sql.Request();
request.query(query, (err, db) => {
if (err) reject(err);
resolve(db);
});
});
});
}
async function z() {
var z = await ExecuteSQL("select *from post");
console.log(z.recordsets);
}
z();
module.exports = {
ExecuteSQL: ExecuteSQL,
};
步骤1:我运行了以下命令:docker-compose up -d(这将运行两个容器db和app)。
步骤2:我打开浏览器,转到http://localhost:3000/(我的目标是当我从server.js文件选择* from post时,浏览器将显示记录集),但它会抛出错误:
UnhandledPromiseRejectionWarning: ConnectionError: Failed to connect to localhost:1433 - Could not connect (sequence)
但是,当我运行cmd:node sql时,它可以连接到容器中的SQL Server并显示数据,因为我在sql.js中有测试函数。
async function z() {
var z = await ExecuteSQL("select *from post");
console.log(z.recordsets);
}
z();
数据显示:
[
[
{
id: 1,
title: 'How to learn docker',
content: ' qjweqwn ejqwne qwne nqwje nqwjen qjwne ojqwne jqwn'
},
{
id: 2,
title: 'How to learn english',
content: ' qwen qwen qjen qw'
}
]
]
我已经提供了必要的信息,那么应用程序容器有没有办法连接到数据库容器并获取数据?也许我应该在docker-compose.yml文件中进行更多编辑?