Skip to content

Instantly share code, notes, and snippets.

@maishsk
Created January 10, 2019 20:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save maishsk/88303dc3b1b0feb960b0c86aa8696399 to your computer and use it in GitHub Desktop.
Save maishsk/88303dc3b1b0feb960b0c86aa8696399 to your computer and use it in GitHub Desktop.
server retrieve value from database
const express = require('express')
mysql = require('mysql')
const app = express()
const port = 3000
let winston = require('winston');
let logger = winston.createLogger({
level: 'info',
format: winston.format.combine(
winston.format.timestamp(),
winston.format.printf(info => {
return `${info.timestamp} ${info.level}: ${info.message}`;
})
),
transports: [
new winston.transports.Console(),
new winston.transports.File({filename: 'app.log'})
]
});
var connection = mysql.createConnection(
{
host : '192.168.106.130',
user : 'root',
password : 'my-secret-pw',
database : 'maishsk',
}
);
app.get('/hello', (request, response) => {
connection.query('SELECT name FROM mytable WHERE id=1 LIMIT 1', (error, results, fields) => {
if (error) {
return console.error(error.message);
}
response.send(results[0].name);
logger.log('info', results[0].name);
console.log(results[0].name)
});
});
app.listen(port, (err) => {
if (err) {
return console.log('something bad happened', err)
}
console.log(`server is listening on ${port}`)
})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment