Virtual fields using getter and setter methods in sequelize

gistfile1.js

var Sequelize = require('sequelize')
var sequelize = new Sequelize('sequelize_test', 'root')

//Note that the model definition does not have "fullName"
var User = sequelize.define('User', {
        email: Sequelize.STRING,
        firstName: Sequelize.STRING,
        lastName: Sequelize.STRING,
},
{       
        getterMethods: {
                fullName:  function() {
                        return this.firstName + '' + this.lastName
                }
        },
        setterMethods: {
                fullName: function(fullname) {
                        var split = fullname.split(''),
                        this.firstName = split[0],
                        this.lastName = split[1]
                }
        }
})

sequelize.sync().success(function() {
  User          
    .create({ email: '[email protected]', fullName: 'John Smith' })
    .success(function(jsmith){ console.log(jsmith.fullName) })
})              

Huge help. Thanks!

Thanks!

Thanks very help full

Thanks :D , but this cannot order , when Model.findAll({order: 'virtualField' DESC'}) ?

Took me too long to figure out why my getter wasn't working on a find query.

var attrs = {
    firstname: Sequelize.STRING,
    lastname: Sequelize.STRING
};

var methods = {
    getterMethods: {
        fullname: function() { return this.firstname + " " + this.lastname; }
    }
};

var Person = sequelize.define("Person", attrs, methods);

And then later....

models.Person.find({
    attributes: ["firstname"],
    where: {id: id}
}).then(function(row) {
    console.log(row.fullname); //returns undefined because you have to specify ["firstname", "lastname"] in your query
});

I was misunderstanding in what context this[attribute] was operating in your getter/setter methods.