README.md

DEV BUILD

Express Bookshelf Postgres ES6

Express, Bookshelf.js & Postgres. ES6 style using Babel.

Main Components:

• Grunt
• Babel Compiler
• Express
• Bookshelf.js
• SASS
• BrowserSync

Usage

# clone a copy
git clone https://github.com/kurtisdunn/Express-Bookshelf-Postgres-ES6.git
cd ES6-ExpressJS-Starter

# get it going:
npm install

# run it
node dist/server.js

Development Stuff

# Compile ES6 to ES5
grunt compile

# run up a development version:
grunt dev

DB Persistence:

This build uses Bookshelf.js to persist our data from postgresql, easily mapping table relations in a minimal promise based format.

# Model
const Make = Bookshelf.Model.extend({
  tableName: 'make',
  models: () => {
    return this.hasMany(Model);
  }
});
  
# Query
Make.where('id', req.params.id).fetch().then((make) => {
  res.json(make); 
}).catch((err) => {
  console.error(err);
});
  

###Endpoints

• GET /api - Returns nothing
• GET /api/make/:id - Fetch make by id
• GET /api/make/:id/models - Fetch models by make
• GET /api/models/:id - Query model by model name