mysql2-handler
The custom handler for mysql2 module.
Installation
npm install @edu-tosel/mysql2-handler
Environment Variables
export DB_HOST='localhost'
export DB_USER='root'
export DB_PASSWORD='password'
export DB_NAME='database'
export DB_PORT='3306'
export DATE_STRINGS='DATE'
export CONNECTION_LIMIT='10'
Default configuration
- DB_HOST: None
- DB_USER: None
- DB_PASSWORD: None
- DB_NAME: None
- DB_PORT: 3306
- DATE_STRINGS: 'DATE'
- CONNECTION_LIMIT: 5
- TIMEZONE: 'UTC'
Usage
const mysqlHandler = require('@edu-tosel/mysql2-handler');
function select1(){
return mysqlHandler.handler(async(connection)=>{
const [rows, fields] = await connection.execute('SELECT 1 AS `one`');
return rows;
});
}
select1().then(console.log).catch(console.error);