module export usage error in node

Question

I'm having db.js file which consist of

var mysql      = require('mysql2');
var mysqlModel = require('mysql-model');
    var appModel = mysqlModel.createConnection({
      host     : 'localhost',
      user     : 'root',
      password : 'root',
      database : 'tabio',
    }); 

var User = appModel.extend({
    first: "table_first",
});
var Message = appModel.extend({
    second: "table_second",
});

module.exports = {
  first : first,
  second : second
};

I am requesting the db.js in another file main.js like

var connection = require('./db.js');
test = new connection.first({ 
    column1: 12, 
    column2: 34,  
});
test.save();

it successfully saves the recored. But how can i run select, delete, update query here.

while using var test = connection.first.find(1);, i get the error TypeError: connection.User.find is not a function. how to use the select & update query using db-migrate?

BlackMamba · Accepted Answer · 2016-08-09 00:56:16Z

1

test = new connection.first();

then you can use test.query, test.find.

query Runs custom query

Usage:

movie.query(query); movie.query(query, callback); Parameters:

string query: Your custom sql query to run function callback: returns errors and results Example:

movie.query("SELECT name FROM movies WHERE director = 'James Cameron' ORDER BY year", function(err, rows, fields) { // Do something... });

answered Aug 9, 2016 at 0:56

BlackMamba

10.3k8 gold badges47 silver badges71 bronze badges

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

Collectives™ on Stack Overflow

module export usage error in node

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related