the-api

The API

Create API asap. Includes the following:

• log all actions to console with time, unique id, request path and time elapsed since the beginning of the request.

• error handler with app name, version, error codeName, stack, error name and description for developers.

• info endpoint: server currentTime, app name, version, uptime, requests count, endpoints

• login route - register, login, make and refresh app token

• check token, return unauthorized if token is invalid

• handle white/black lists, count of requests

• cache data in memory/redis

• notes route - example of category/notes api

Install

npm i -S the-api

or

yarn add the-api

Usage

index.js

const TheAPI = require('the-api');
const api = new TheAPI();

const { logs, errors, info, token, access } = api.extensions;
const { login, check, notes } = api.routes;

info.endpointsToShow(login, check, notes);

api.up([
          // select any extension you want to use
  logs,   // log all actions to console with time, unique id, request path and time elapsed since the beginning of the request
  errors, // error handler with app name, version, error codeName, stack, error name and description for developers
  info,   // GET /info endpoint: server currentTime, app name, version, uptime, requests count, endpoints
  login,  // login route - register, login, make and refresh app token
  check,  // check route - small example, just send {ok: 1}
  token,  // check token, return unauthorized if token is invalid
  access, // handle white/black list, count of requests
  notes,  // notes route - example of category/notes api
]);

Change e-mail templates

...
const { login } = api.routes;
...
login.setTemplates({
  register: {
    subject: 'Complete your registration',
    text: 'Hello, use your code {{code}} to POST /register/check',
    html: 'Hello, use your <b>code {{code}}</b> to POST <b>/register/check</b>',
  },
})
...
api.up([
...

examples

• Get info

curl -vvv localhost:8877/info

• Create User

curl -vvv -X POST -d '{"login":"aaa", "password":"bbb"}' --header "Content-Type: application/json" localhost:8877/register

• Refresh Token

curl -vvv -X POST -d '{"refresh":"36ae43be-ae49-46b9-ba8a-027dbcf64fa0"}' --header "Content-Type: application/json" localhost:8877/login

• Get new Token

curl -vvv -X POST -d '{"login":"aaa", "password":"bbb"}' --header "Content-Type: application/json" localhost:8877/login

.env

name | description | example | default value -----|-------------|---------|-------------- PORT | port to listen | 8878 | 8877 API_PREFIX | api prefix | /v1 | JWT_SECRET | JWT secret phrase | nruR3@_123dri!aS | JWT_EXPIRES_IN | expressed in seconds or a string describing a time span zeit/ms | 60, 2d, 10h | 1h

Database

DB options for knex

name | description | example | default value -----|-------------|---------|-------------- DB_CLIENT | client | postgres, mysql, sqlite3 | sqlite3 DB_HOST | DB host | db.server | DB_PORT | DB port | DB_USER | DB user | login | DB_PASSWORD | DB password | password | DB_NAME | database name | the_api_db DB_SCHEMA | database schema, optional | public DB_FILENAME | sqlite3 DB filename | ./sqlite.db

DB write instance options for knex

name | description | example | default value -----|-------------|---------|-------------- DB_WRITE_CLIENT | client | postgres, mysql, sqlite3 | sqlite3 DB_WRITE_HOST | DB host | db.server | DB_WRITE_PORT | DB port | DB_WRITE_USER | DB user | login | DB_WRITE_PASSWORD | DB password | password | DB_WRITE_NAME | database name | the_api_db DB_WRITE_SCHEMA | database schema, optional | public DB_WRITE_FILENAME | sqlite3 DB filename | ./sqlite.db

Login Module

name | description | example | default value -----|-------------|---------|-------------- LOGIN_CHECK_EMAIL | send code to check registration | true, false | false LOGIN_CHECK_EMAIL_DELAY | waiting for check registration code, minutes | 30 | 60 LOGIN_UNCONFIRMED_FORBID | Don't send token for unconfirmed e-mail | true, false | false EMAIL_USER | nodemailer email user | login | EMAIL_PASSWORD | email password | password | EMAIL_HOST | email server | smtp.server | EMAIL_PORT | email port | 587 | EMAIL_SECURE | nodemailer secure option | true, false | EMAIL_TLS_REJECTUNAUTH | nodemailer rejectUnauthorized option | true, false |

Sentry DSN

name | description | example | default value -----|-------------|---------|-------------- ERRORS_SENTRY_DSN | dsn of Sentry | https://b94116e6a9e24065bd8353e42e8a885a@o4504812935243920.ingest.sentry.io/4504812938299040 |

Helpers

CRUD helper

Create Create-Read-Update-Delete endpoint for table.

Usage:

const TheAPI = require('the-api');

const api = new TheAPI();
const colors = api.crud({ table: 'colors' });
api.up([colors]);

Generates the following endpoints with CRUD access to colors table:

• GET /colors
• POST /colors
• PATCH /colors
• DELETE /colors

KOA Knex helper

Implement REST endpoinds for KOA and Knex. Main features:

• hidde fields by user category
• required fields list
• forbidden fields to add list
• default where in each select request
• join tables as json array
• join tabbles aliases
• limits in joined tabbles
• define fileds to show in joined tabbles
• support orderby of joined tabbles
• .get return selected fields (GET /ship?_fields=id,name)
• .get searching (GET /ship?name=Item%20name&category_id=3)
• .get searching by from/to (GET /ship?_from_date=2001&_to_date=2011)
• .get where not searching: /ships?_fields=title&title!=main
• .get ilike searching (GET /ship?name~=%25Item%25)
• .get searching by array (GET /ship?category_id[]=3&category_id[]=5)
• .get null searching (GET /ship?category_id[]=null)
• .get pagination (GET /ship?_page=2&_limit=10)
• .get offset (GET /ship?_skip=100&_limit=10)
• .get ASC/DESC multifields sorting (GET /ship?_sort=name,-date)
• .get random sorting (GET /ship?_sort=random())
• .get pays attention to deleted field in the table (get deleted=false by dafault)
• .post/.path/.delete implementation

Usage:

//... KOA and Knex flow...
const koaKnexHelper = require('the-api/koa-knex-helper')({ table: 'colors' });

const apiHelper = new koaKnexHelper({
  table: 'ships',
  join: [
    {
      table: 'images', where: 'ships.id = images.ship_id', fields: ['id', 'name'], orderBy: 'is_main DESC, id ASC', limit: imageShowLimit || 1,
    },
    { table: 'categories', where: 'categories.id = ships.category_id' },
    { table: 'lang', where: 'lang.key = ships.name', alias: 'name_lang' },
    { table: 'users', where: 'users.id = ships.user_id', fields: ['company_country', 'company_id', 'company_name', 'first_name', 'second_name', 'id', 'position', 'product', 'status'] },
  ],
  hiddenFieldsByStatus: {
    default: ['imo', 'user_id', 'title', 'message', 'external_company_name', 'external_id', 'external_url'],
    registered: ['external_company_name', 'external_id', 'external_url'],
    owner: ['external_company_name', 'external_id', 'external_url'],
    admin: [],
    root: [],
  },
  required: {
    category_id: 'CATEGORY_ID_IS_REQUIRED',
  },
  forbiddenFieldsToAdd: ['id', 'user_id', 'timeCreated', 'timeUpdated', 'deleted', 'status', 'has_pdf', 'has_rtf'],
  defaultWhere: { sold: false },
});

app.get('/ships', ctx => {
  ctx.body = await apiHelper.get({ ctx });
});

Changelog

History of commits is here

Created by

Dimitry Ivanov [email protected] # curl -A cv ivanoff.org.ua