-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathserver.js
More file actions
30 lines (24 loc) · 701 Bytes
/
Copy pathserver.js
File metadata and controls
30 lines (24 loc) · 701 Bytes
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
"use strict";
const express = require('express');
const app = express();
const mysql = require('mysql');
const HOST = "0.0.0.0";
const PORT = "8080";
const connection = mysql.createConnection({
host: process.env.DB_HOST,
user: process.env.DB_USERNAME,
password: process.env.DB_PASSWORD,
database: process.env.DB_NAME,
});
connection.connect((err) => {
if (err) throw err;
console.log("Connected to MySQL Server!");
});
app.get("/", (req, result) => {
connection.query("SELECT * from data LIMIT 1", (err, rows) => {
if (err) throw err;
result.send(rows[0]["value"]);
});
});
app.listen(PORT, HOST);
console.log("Running on http://${HOST}:${PORT}");