Express Boillerplate RestfullApi With Mysql

Core Stack

• Node.js - http://nodejs.org/
• Express - http://expressjs.com/
• Mysql - https://www.mysql.com//
• nodemon - https://www.npmjs.com/package/nodemon
• dotenv - https://www.npmjs.com/package/dotenv/
• nodemon - https://www.npmjs.com/package/nodemon/
• bodyparser - https://www.npmjs.com/package/body-parser/
• mysql - https://www.npmjs.com/package/mysql/
• jsonwebtoken - https://mongoosejs.com/
• bcrypt - https://mongoosejs.com/

Feature

1. crud example
2. authentication with jwt, login
3. error handling
4. custom message api response
5. strict mode

How To run

copy environment variable

cp .env.sample .env

Run manualy

# install package
npm install

#  running app
npm run start

Fill in the copied environment earlier

APP_PORT=3000
TZ=Asia/Jakarta
SECRET_KEY=secretpassword

#Database config
DB_HOST=host #server host database
DB_DATABASE=database name #db name
DB_USERNAME=database username #username
DB_PASSWORD=database password #password

Demo login

username: admin
password: 123

Code Style Guides

• Guideline:
  • Use camelCase for variable name, naming function, load module or other functions
  • Use UpperCase for Constant Variable
  • Use PascalCase for class name, models, controller, route, load module model
  • Use snake_case for file name as variable
  • Function name use Verb
  • Variable name use Noun