Nodal TL:DR Seed Database

1. Command Line

npm install -g nodal
nodal new todo-pgjson
cd todo-pgjson
nodal g:model Todo user_id:int tasks:json done:boolean
nodal g:controller --for Todos
nodal db:bootstrap

// add json data to seed.json

nodal db:seed
nodal db:bootstrap

2. seed.json

// config/seed.json
{

  "development": {
    "Todo": [
      {
        "user_id" : "1",
        "done" : "false",
        "tasks" : {"grapes":"7","bananas":"4","apples":"3"}
      }
    ]
  },

  "test": {
    "Todo": [
      {
        "user_id" : "1",
        "done" : "false",
        "tasks" : {"grapes":"7","bananas":"4","apples":"3"}
      }
    ]
  },

  "production": {}

}

Requests and Responses

Request: 

GET to /todos 

Response:

{
  "meta": {
    "total": 2,
    "count": 2,
    "offset": 0,
    "error": null
  },
  "data": [
    {
      "id": 1,
      "user_id": 1,
      "tasks": {
        "apples": "3",
        "grapes": "7",
        "bananas": "4"
      },
      "done": false,
      "created_at": "2016-06-05T02:34:06.291Z",
      "updated_at": "2016-06-05T02:34:06.291Z"
    },
    {
      "id": 2,
      "user_id": 1,
      "tasks": {
        "apples": "3",
        "grapes": "7",
        "bananas": "4"
      },
      "done": false,
      "created_at": "2016-06-05T02:34:09.730Z",
      "updated_at": "2016-06-05T02:34:09.730Z"
    }
  ]
}