Connect an existing MySQL db for a Node/Express app using Sequelize

Question

Working on a project for a complete rewrite of an RoR to Node/Sequelize/Express/Angular app.

I have executed the old schema on my local machine and can view the db, tables and data OK.

Within my Node code I need to connect the existing DB.

I am following this tutorial: http://redotheweb.com/2013/02/20/sequelize-the-javascript-orm-in-practice.html

My question arrises when using sequelize.import and pointing it a directory.

Should this be my local MySQL directory where the schema was set up? (assuming yes)
Does model refer to the table in the DB?

Advice on how to correctly access the existing relational mapping is helpful.

This if my first question on Stack, thank you in advance.

var express = require('express');
var http = require('http');
var path = require('path');
var config = require('./config/config');

var Sequelize = require('sequelize');

var app = express();

var db = new Sequelize('somedb', 'root', 'password');

var models = [
  'users'
];

models.forEach(function(model){
  module.exports[model] = sequelize.import(__dirname + '/' + )
})

Jan Aagaard Meier · Accepted Answer · 2013-09-12 17:06:54Z

1

Sequelize.import CANNOT import your current SQL schemas. You will need to write javascript code to define your models:

// in models/users.js
module.exports = function(sequelize, DataTypes) {
    return sequelize.define('User', {
        first_name: DataTypes.STRING,
        last_name: DataTypes.STRING,
    });
};

Assuming the script you posted is the root and there is a folder named models with a file users.js in the same directory, then the script will work. The path you pass to .import is the file system path of the javascript file that defines your model

answered Sep 12, 2013 at 17:06

Jan Aagaard Meier

28.9k8 gold badges99 silver badges68 bronze badges

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

1 Comment

glibaudio Over a year ago

This is helpful. Ended up using a more basic pattern of exporting an object. My file is long, but it's quicker. You were right. A npm to do this would be cool. module.exports = { Users: Users, Races: Races, Race_Users: Race_Users };

Collectives™ on Stack Overflow

Connect an existing MySQL db for a Node/Express app using Sequelize

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related