问将Server和nodejs与坞-组合连接起来

EN

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:

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" ]

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"));

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,
};

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'
    }
  ]
]