the-api

20.6.6 • Public • Published

NPM version NPM downloads MIT License Build Status: Linux Build Status: Windows Coverage Status Requirements Status Bundle Size Issues Stars Node version Contributors

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 2@ivanoff.org.ua # curl -A cv ivanoff.org.ua

Readme

Keywords

Package Sidebar

Install

npm i the-api

Weekly Downloads

59

Version

20.6.6

License

MIT

Unpacked Size

209 kB

Total Files

98

Last publish

Collaborators

  • ivanoff