TODO LIST

User stories

  • Service not needed authentication
  • User can create a item TODO
  • User can edit a item TODO
  • User can delete a item TODO
  • User can change status of a item TODO from doing to done
  • User can see all items TODO (pagination)

Golang

  • Gin framework
  • GORM ORM (for mysql)

Design system

todo_items CREATE TABLE todo_items ( id int NOT NULL AUTO_INCREMENT, title varchar(150) CHARACTER SET utf8 NOT NULL, status enum('Doing','Finished') DEFAULT 'Doing', created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

api_todo_items

  • [post] /v1/items
  • [get] /v1/items
  • [get] /v1/items/:id
  • [put] /v1/items/:id
  • [delete] /v1/items/:id

Process

Install library

  • go get -u github.com/gin-gonic/gin

  • go get -u gorm.io/gorm

  • go get -u gorm.io/driver/mysql

  • Automatically reload server when code change

  • Using air

RUN

  • Start the server: air

GitHub

View Github