zeit now geojson endpoint.js

const auth = require('../../mod/auth/handler')({
  public: true
})

const dbs = require('../../mod/pg/dbs')()

const _layers = require('../../mod/workspace/layers')

const layers = []

module.exports = async (req, res) => {

  await auth(req, res)

  Object.assign(layers, [], await _layers(req, res))

  if (res.finished) return

  const layer = layers[req.params.layer]

  var q = `
  SELECT
    ${layer.qID || null} AS id,
    ST_asGeoJson(${layer.geom}) AS geomj
  FROM ${req.query.table};`

  var rows = await dbs[layer.dbs](q)

  if (rows instanceof Error) return res.status(500).send('Failed to query PostGIS table.')

  res.send(rows.map(row => ({
    type: 'Feature',
    geometry: JSON.parse(row.geomj),
    properties: {
      id: row.id
    }
  })))

}