Skip to content

lewisjared/postgrest-request

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

postgres-request

Travis build status

Providing a node interface to query a postgrest instance.

Installation

npm install postgrest-request

Usage

postgrest-request wraps the functionality of superagent and provides the same chaining syntax. Full documentation for building queries is available from superagent.

The following code segment queries https://postgrest.herokuapp.com/festival

var config = {
  host: 'postgrest.herokuapp.com',
  method: 'https',
  post: 443
};
var postgrest = require('postgrest-request')(config);

postgrest.get('/festival')
  .end(function (err, data ) {
    console.log(err, data.body);
  });

The following features from postgrest have been implemented:

  • filtering
  • versioning

Filtering

The request can be filtered using the .where() option. The following code snippet gets all festivals with a rating greater than 7.

postgrest.get('/festival')
  .where({
    gt: {
      rating: 7
    }
  })
  .end(function (err, data ) {
    console.log(err, data.body);
  });

See https://github.com/begriffs/postgrest/wiki/Routing#filtering for filtering options

Versioning

A particular version of the API can be requested by chaining a call to version(versionNumber) where version number is a positive number. This will set the accept header of the request to the required version as an integer and by default version 1 of the API is requested. Calls to the superagent function accept will be ignored as postgrest always returns JSON and ignores the requested application type. Examples for implementing schemas with versioning is available here

License

MIT

About

Node interface to postgrest instances

Resources

License

Stars

Watchers

Forks

Packages

No packages published