Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- exports.helloGET = (req, res) => {
- console.log(req.body.message);
- var con = mysql.createConnection({
- //socketPath: '/cloudsql/' + 'project-id:region-name:instance',
- host: 'xxx.xxx.xxx.xxx',
- user: 'user',
- password: 'root',
- database: 'test'
- });
- con.connect(function(err) {
- console.log("Connection Error - " + err)
- if (err) throw err;
- console.log("Connected to Cloud SQL");
- });
- con.query(`SELECT now()`, null, function (err, result) {
- //made reply here
- console.log("Query Error - " + err)
- if (err) throw err;
- console.log("Result: " + result);
- });
- con.end();
- res.status(200).send('Acknowledgement : ' + req.body.message);
- };
- var con = mysql.createConnection({
- socketPath: '/cloudsql/' + 'project-id:region-name:instance',
- //host: 'xxx.xxx.xxx.xxx',
- user: 'user',
- password: 'root',
- database: 'test'
- });
Add Comment
Please, Sign In to add comment