a simple boilerplate for nodejs express mysql api clone this repo and start your project
npx @gulali/nodejs-express-sequelize-mysql-api-boilerplate my-project-apiedit config/config.json file and change your database name, username and password
{ "development": { "username": "root", "password": "", "database": "api_db_development", "host": "127.0.0.1", "dialect": "mysql" }, "test": { "username": "root", "password": "", "database": "api_db_test", "host": "127.0.0.1", "dialect": "mysql" }, "production": { "username": "root", "password": "", "database": "api_db_production", "host": "127.0.0.1", "dialect": "mysql" } } and run this command to create database and tables
npm run preparenpm run start:devnpx sequelize-cli model:generate --name user --attributes firstname:string,lastname:string,username:string,email:string,password:string,gender:string,active:integer,deleted:integer,token:string,token_expire:string,birthday:date,role:stringPull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.