Knex.js - PoC
Proof of concept of the library Knex.js, for this PoC, I'll be using PostgreSQL and a simple rest API in Express
- PostgreSQL needs to be installed
- Run PostgreSQL
-
Download the code:
git clone https://github.com/brion25/knex-poc -
Install dependencies:
npm install -
Run the server
node .It will run an API with the most common verbs :
GET,POST,PUT,DELETEunder the path :http:localhost:3000/book:GET http:localhost:3000/book //Get all the books POST http:localhost:3000/book //Insert a new book GET http:localhost:3000/book/:name //Get books by book name PUT http:localhost:3000/book/:name //Update books by book name DELETE http:localhost:3000/book/:name //Delete books by book name
{
name : String,
pages : Decimal,
editorial : String
}