firebase cloud function can i establish connection to mysql

1,395 views

Skip to first unread message

research 837

unread,

Apr 14, 2017, 4:23:24 AM4/14/17

to Firebase Google Group

how to write firebase cloud function to establish connection to remote mysql server. i have installed mysql module and dependencies for the function. But i cant establish connection to remote mysql server.

code:

var functions = require('firebase-functions');

const admin = require('firebase-admin');

admin.initializeApp(functions.config().firebase);

exports.mysql= functions.https.onRequest((request, response) => {

var mysql = require('mysql');

var connection = mysql.createConnection({

host : '131.85.86.208',

user : 'root',

password : 'abc123',

database : 'management',

port :'113'

});

connection.connect(function(err) {

if(err){

console.log("not connected");

}

else{

connection.query('SELECT * from employee', function(err, rows, fields) {

console.log(rows);

response.send(rows);

});

connection.end();

}

});

Galdino Manzanero Morales

unread,

Apr 27, 2017, 12:34:52 AM4/27/17

to Firebase Google Group

Check the functions/package.json

Like this

"dependencies": {

"firebase-admin": "~4.1.2",

"firebase-functions": "^0.5",

"mysql": "^2.13.0"

and be carefull of the returned promise

return connection.connect(function(err) {
        if (err) throw err
            console.log('You are now connected...')

            return connection.query('INSERT INTO sales (ticketno, total) values ("' + _v.ticketno+ '","78");', function(err, result) {
                if (err) throw err
                console.log('done...')

            }) 
        });