Issue including js file in Node application

Question

I want to create a manager to interact with mysql, but I'm not able to bring it into the main program. I'm mainly just trying to get the hang of javascript for this stuff (java, c background).

I have two files called main.js and MSYQLConnector.js. I want to use MYSQLConnector from

main.js

var root = __dirname, express = require('express');
var app = express();
var sql = require('./DBConnectors/MYSQLConnector.js');
var a = sql.sqlTest;//????? fail....

MYSQLConnector.js

var sqlTest = function (){
    var mysql      = require('mysql');
    var connection = mysql.createConnection({
        host     : 'localhost',
        user     : 'root',
        password : 'xxxx'
    });

    connection.connect();

    connection.query('SELECT * from asset', function(err, rows, fields) {
        if (err) throw err;

        console.log('The solution is: ', rows[0].solution);
    });

    connection.end();
};

How can I do the import? Thanks

Chris Tavares · Accepted Answer · 2014-07-13 04:03:31Z

2

You need to export the function from your module. Add:

exports.sqlTest = sqlTest;

to the bottom of your MYSQLConnector.js file.

Also, see the nodejs api documentation for more details.

answered Jul 13, 2014 at 4:03

Chris Tavares

30.6k4 gold badges49 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ben · Accepted Answer · 2014-07-13 04:05:43Z

1

you're almost there, add "exports" in front of it:

exports.sqlTest = function (){
  var mysql      = require('mysql');
  var connection = mysql.createConnection({
    host     : 'localhost',
    user     : 'root',
    password : 'xxxx'
  });

  connection.connect();

  connection.query('SELECT * from asset', function(err, rows, fields) {
    if (err) throw err;

    console.log('The solution is: ', rows[0].solution);
  });

  connection.end();
};

answered Jul 13, 2014 at 4:05

Ben

5,0842 gold badges21 silver badges23 bronze badges

Collectives™ on Stack Overflow

Issue including js file in Node application

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related