UNPKG

existence-checker

Version:

makes a middleware function for checking the existence of the given thing in the database

32 lines (26 loc) 1.11 kB
# existence-checker makes an express middleware function for checking the existence of the given thing in the database ## Usage ``` const existenceChecker=require('existence-checker') const express = require('express') const app = express() const thingToUpdate = require('yourThingToUpdateController') const Pool=require('pg').Pool const config = { /** db config stuff **/ } var pool=new Pool(config) app.put('/api/thingToUpdate/:id',existenceChecker('thingSchema','thingToUpdate','id',pool.query),thingToUpdate.updateThingToUpdate) ``` ## existenceChecker(schemaName,tableName,primaryKey,queryExecutor) makes a middleware function for checking the existence of the given thing in the database ### parameters | name | description | | --- | --- | | schemaName | the database schema | | tableName | the thing to check the existence of | | primaryKey | the thing's primary key | | queryExecutor | a function that takes a query object and returns the result of the query ### returns a middleware function for checking the existence of the record with primaryKey in tableName