custom_geo_datatype.js

'use strict'

const WKX = require('wkx')
const Sequelize = require('sequelize')

// Workaround for the missing JSON-C (ST_GeomFromGeoJSON) dep in CloudSQL
// Issue: https://issuetracker.google.com/issues/37302950
class CloudSQLGeo extends Sequelize.DataTypes.GEOGRAPHY {
  constructor() {
    super()
    this.key = 'CustomGeo'
  }

  _stringify(value, options) {
    var wkt = WKX.Geometry.parseGeoJSON(value).toWkt()
    return `ST_GeomFromText('${wkt}', 4326)`
  }
}

module.exports = {
  CloudSQLGeo
}