Sequelize Model where value is set using a PostgreSQL/PostGIS function

Question

Is it possible to set up a Sequelize model in such a way that an instance is written to the database using a PostgreSQL (or PostGIS, in my case) function?

My database leverages PostGIS, and I would like for the value for "the_geom" to be written as a function of the latitude and longitude:

var Site = sequelize.define('site', {
  the_geom: 'geometry(Point,4326)',
  latitude: DataTypes.DECIMAL,
  longitude: DataTypes.DECIMAL
});

The value for the_geom would typically be something like this:

ST_SetSRID(ST_MakePoint(-76.622,39.277),4326)

eczajk · Accepted Answer · 2016-01-29 16:42:26Z

3

I was able to achieve my desired result using hooks:

var Site = sequelize.define('site', {
        the_geom: 'geometry(Point,4326)',
        latitude: DataTypes.DECIMAL,
        longitude: DataTypes.DECIMAL
}, {
  hooks: {
      afterValidate: function (site, options) {
        site.the_geom = sequelize.fn('ST_SetSRID', sequelize.fn('ST_MakePoint', site.longitude, site.latitude), '4326');
      }
    }
  });

answered Jan 29, 2016 at 16:42

eczajk

4574 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Sequelize Model where value is set using a PostgreSQL/PostGIS function

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