BACK/image_test.js at main · AIMdevdog/BACK · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
const mysql = require('mysql');
const express = require("express");
const http = require("http");

const app = express();
const server = http.createServer(app);
const PORT = 3000;

// db session store options
const options = {
    host: "db-aim.cv48si1lach8.us-east-2.rds.amazonaws.com",
    port: 3306,
    user: "admin",
    password: "aimjungle!2345",
    database: "aim_production",
};
// mysql 연결
let db = mysql.createConnection(options);
db.connect();

function HTML (title, list, body, control) {
    return `
    <!doctype html>
    <html>
    <head>
    <title>WEB2 - ${title}</title>
    <meta charset="utf-8">
    </head>
    <body>
    <h1><a href="/">WEB</a></h1>
    <a href="/author">author</a>
    ${list}
    ${control}
    ${body}
    </body>
    </html>
    `;
}

app.get('/', function (request, response) {
    db.query('SELECT * FROM map_images WHERE id=?', [1], function (error, results) {
        if (error) {
            console.log(error);
        }

        var title = 'Welcome';
        var description = 'Hello, Node.js';
        var html = HTML(title, ``,
            `<h2>${title}</h2><p>${description}</p>
            <img src="${results[0].map_s3_addr}" width="800px">
            `,
            ``
        );
        response.send(html);
    });

    db.end();

});

app.listen(PORT, () => {
    console.log(`Example app listening on port ${PORT}`)
})