matrix-lib-utils-backend v1.0.4

MATRIX-LIB-BACKEND

Storage location and centralization of utilities for MATRIX development.

How do I get set up?

$ npm install --save matrix-lib-utils-backend

import { thisFeature } from 'matrix-lib-utils-backend'

Features

Raw Query

Lib designed to facilitate the use of raw queries with sequelize.

• Usage

  	The first parameter to be informed is sql query in string format.
  
  	The second parameter to be informed is an array of query parameters.
  
  	The last parameter to be informed is the current instance of the sequelize.

  import sequelize from 'sequelize'
  
  import { rawQuery } from 'matrix-lib-utils-backend'
  
  const result = rawQuery.select('select * from user where id = $1', [1], sequelize)

• available methods

  	**select** 
  
  	**insert**
  
  	**update**
  
  	**delete**
  
  	**hasSelect** 
  
  	*Used to check if something exists. "select 1" is recommended for best performance*
  
  	```javascript 
  	rawQuery.hasSelect('select  1 from user where id = $1', [1], sequelize)

  		**hasCount** 
  
  		*Used to count the number of records returned. "select 1" is recommended for best performance*
  
  		```javascript 
  		rawQuery.hasCount('select  1 from user where id = $1', [1], sequelize)

  	**selectValue** 
  
  	*Used to select a record. "as value" it is necessary*
  
  	```javascript 
  	rawQuery.selectValue('select name as value from user where id = $1', [1], sequelize)

  
  		**selectValues** 
  
  		*Used to select many records. "as value" it is necessary*
  		```javascript 
  		rawQuery.selectValues('select name as value from user where id_company = $1', [1], sequelize)