Build a Chat app with NodeJS, React and GraphQL

start mysql

# up
docker-compose -f ./docker/docker-compose.yaml up -d

# down
docker-compose -f ./docker/docker-compose.yaml down --volumes

# enter into process on docker (password: root)
mysql -u root -p -h localhost -P 3306 --protocol=tcp

migration

# execute
sequelize db:migrate

# rollback
sequelize db:migrate:undo:all

• document: https://sequelize.org/master/manual/migrations.html

insert initial data

# running seeds
sequelize db:seed:all

# undoing seeds
sequelize db:seed:undo:all

run server

# prerequisite: mysql(which has chat db.) is running locally.
npm run dev

graphql query

# register user
mutation Register {
  register(username: "john", email: "[email protected]", password: "123456", confirmPassword: "123456") {
    username
    email
    createdAt
    token
  }
}

# login
query Login {
  login(username: "john", password: "123456") {
    username
    email
    createdAt
    token
  }
}

# getUsers
## set header (XXXXXXXXXXXXXX: passed token when logged in)
{
  "Authorization": "Bearer XXXXXXXXXXXXXX"
}

## run query
query getUsers {
  getUsers {
    username
  }
}

# send message
mutation SendMessage {
  sendMessage(to: "jane", content: "Hi, jane. Whats up!") {
    uuid from to content createdAt
  }
}

# send message to myself (assert error)
mutation SendMessageMyself {
  sendMessage(to: "john", content: "Hi, jane. Whats up!") {
    uuid from to content createdAt
  }
}

# get messages between john and jane
## 1. login as john
query Login {
  login(username: "john", password: "123456") {
    username
    email
    createdAt
    token
  }
}

## 2. craete header with returned token
{
  "Authorization": "Bearer XXXXXXXXXXX"
}

# 3. run getMessages query
query GetMessages {
  getMessages(from: "jane") {
    uuid to from content createdAt
  }
}

start client app

cd client
npm start

status

[DONE]
https://www.youtube.com/watch?v=Sz64p1Udwjk
https://www.youtube.com/watch?v=aieNcEqCLHg