While working with Ruby on Rails (RoR), I am familiar with the MVC (Model-View-Controller) concept. In this framework, the controller is responsible for receiving data from the model, processing it, and rendering the view. An example of this structure looks like:
def index
@movies = Movie.all
if params[:title] || params[:director]
@movies = Movie.search(params)
end
Now, I am exploring Express server and trying to implement a similar MVC pattern using PostgreSQL with pg-promise and jade templating engine.
In my current setup, I have a controller file with the following code snippet:
//Get home page
var router = express.Router();
router.get('/', function(req, res, next) {
Movies.all(res);
});
Within my model, there is an 'all' function to handle database queries:
exports.all = function(res){
var result = db.query('select * from movies').
then(function (data) {
// success;
res.render('index',{title: 'Rotten Mango', movies: data} );
})
.catch(function (error) {
// error;
console.log('error !')
});
};
What I aim to achieve is to return the query result from 'Movies.all' back to the controller in a way that resembles the traditional MVC approach in RoR. A hypothetical scenario could look something like this:
//Get home page
var router = express.Router();
router.get('/', function(req, res, next) {
// This code should return the JSON result and render it into the view page
res.render('index', Movies.all);
});
However, due to potential promises or asynchronous behavior, achieving this functionality poses some challenges. How can I effectively make this happen?