Sequelize database field mapping not working

[ChrisCrank211]

I’m having a problem in Sequelize that causes the column names and JSON object properties to not match up. This mostly manifests on create and update.

First, here’s how my data model looks:
https://www.dropbox.com/s/9yfiqvl69v57hyk/Screenshot%202014-11-21%2010.24.16.png?dl=0

When I do a create, it stores the data object but returns both the aliased JSON properties and the actual database column names:
https://www.dropbox.com/s/w3i1rycav6pfib0/Screenshot%202014-11-21%2010.22.29.png?dl=0

When I do an update, it breaks because it doesn’t translate the column names at all and can’t find the aliased JSON properties in the database:
https://www.dropbox.com/s/ah3vmibj0ooo1ly/Screenshot%202014-11-21%2010.23.22.png?dl=0

This is in Sequelize 2.0.0 with both Postgres and MySql.

If you have any idea or suggestion around this, please let me know, otherwise we have to resort to 1-to-1 mapping of JSON object property names and database column names.

Thanks

[mickhansen]

Hi @ChrisCrank211 it would be easier if you just included the relevant code in the issue (markdown allows you to format it).

[mickhansen]

Which version of Sequelize are you using?
field support is a relatively new feature so there might be something we've missed.

[extronics]

I ran into the same problem i think. My data model uses the field feature in some cases. But i can't use these properties with custom field names for bulk updates. If using the javascript property name, it's inserted into the generated query, resulting in a "column not found" error. If using the field alias, the column is ommitted from the SET .... but not from WHERE ... clause.

Sample code (2.0.0 RC2 with PostgreSQL):

var Sequelize = require('sequelize');
var sequelize = new Sequelize('db', 'user', 'pass', {dialect: 'postgres'});

var Entity = sequelize.define('Entity', {
    strField: {type: Sequelize.STRING, field: 'str_field'},
});

sequelize
.sync()
.then(function() {
    return Entity.create({strField: 'foo'});
})
.then(function() {
    return Entity.update(
            {str_field: 'bar'},
            {where: {str_field: 'foo'}}
    );
});

I'm falling back to using a raw query for now.

[mickhansen]

.field support for Model.update() was added in 9e78d78, please test and verify.

[extronics]

Works, thanks for your fast response!

[mickhansen]

@extronics original issue was 12 days ago so not really :D