knex postgis

[ymarcon]

Hi,

I would like to use the postgis flavor of postgres to make geo-aware queries, like finding entries within a bounding box. There is the knex-postgis extension that would do the job on the knex side. For feathers, I am wondering how I can extend/configure the built-in KnexAdapter to handle geo operations. I cannot figure out how the query schema can be used to add a new operator (such as for instance $within) and to add its translation into knex function calls. Also the KnexAdapter.knexify() seems to rely only on hard coded METHODS and OPERATORS.

Should I develop my own db adapter or there is a more elegant solution?

Thx

[daffl]

You can still extend the createQuery or knexify methods and add your own functionality.

knexify(knexQuery: Knex.QueryBuilder, query: Query = {}, parentKey?: string): Knex.QueryBuilder {
  const q = super.knexify(knexQuery, query)

  return Object.keys(query).reduce((currentQuery, key) => {
    if (key === '$within') {
      const [lat, lon] = query[key]
      currentQuery.within(lat, lon)
    }
    return currentQuery
  })
}

[ymarcon]

Great, thanks, will try this.