- Create a database
CREATE DATABASE <dbname>;
- update .env file (we should .gitignore this and upload a .env.example but...)
- Optionally, seed the database with a little data
npm install
npm run start
ornpm run watch
for dev modenpm run test
ornpm run test:dev
for unit test dev mode
these are my npm global packages, if you need
garylee@iMac [~] ]$ npm list -g --depth=0
/usr/local/lib
├── create-react-app@1.5.2
├── mysql@2.16.0
├── n@2.1.4
├── npm@6.4.1
├── sequelize-auto@0.4.29
├── tsd@0.6.5
├── typescript@2.1.4
├── typings@2.1.0
└── webpack@1.14.0
PORT=80
SQLUSER=root
SQLPASSWORD=P@ssw0rd!
SQLHOST=localhost
SQLDATABASENAME=<dbname>
node_modules/.bin/sequelize db:seed:all
- modularize routes
- catch all routes
- nodemon
- prettier rc
- eslint
- env file for ports
- jest test setup
- user story 1 POST /api/register
- user story 2 GET /api/commonstudents
- user story 3 POST /api/suspend
- user story 4 POST /api/retrievefornotifications
-- create database mba; -- if you use new auth protocol, you might get 'please upgrade client warning', do this till mysql2 driver supports the new protocol
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'P@ssw0rd!'