Git Product home page Git Product logo

node-postgres-api-boilerplate's Introduction

node-postgresql-api-boilerplate

a simple api boilerplate

This is a basic boilerplate for spinning up a non-hypermedia API with a minimum of abstractions. It relies heavily on pg-promise and uses json schema for input validation (via is-my-json-valid).

Setup Instructions

Install node 6x+ and postgresql (this should be in vagrant or docker).

  1. Run npm install to install local dependencies.
  2. Create database createdb api-boilerplate.
  3. Run npm run migrate:up to initialize the database schema.
  4. Run npm run seed:up to populate database with seed data.
  5. Run npm run start-dev to start the api.
  6. Browse to http://localhost:8080/
  7. Edit files in src/api (the server will automatically restart on changes).

Database Migrations

  1. Run npm run migrate to check the status of migrations.
  2. Run npm run migrate:up to migrate to the most recent migration.
  3. Run npm run migrate:down to roll back one migration.
  4. Run npm run migrate:create to create a new migration file.

Database Seeds

  1. Run npm run seed to check the status of seeds.
  2. Run npm run seed:up to load to the most recent seed.
  3. Run npm run seed:down to roll back one seed.
  4. Run npm run seed:create to create a new seed file.

Creating Resources

// one
POST /v1/state
Content-Type: application/json
{
  "data": {
    "name": "Minnesota",
    "abbr": "MN"
  }
}

// many
POST /v1/state
Content-Type: application/json
{
  "data": [{
    "name": "Minnesota",
    "abbr": "MN"
  }, {
    "name": "Vermont",
    "abbr": "VT"
  }]
}

Reading Resources

// many
GET /v1/state

// one
GET /v1/state/1

Updating Resources

PATCH /v1/state/1
Content-Type: application/json
{
  "data": {
    "name": "Minnesota"
  }
}

Destroying Resources

DELETE /v1/state/1

node-postgres-api-boilerplate's People

Contributors

lyzadanger avatar vitaly-t avatar

Watchers

James Cloos avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.