• Content-Type of "application/json;charset=utf-8", snake_case naming (identical to the database columns)
• Status Codes
  • 500 for server(db) errors,
  • 422 for validation errors, e.g.

  {
      "code": 422,
      "message": "required fields are missing",
      "timestamp": 1589306271
  }
  • 400 for malformed syntax, e.g.

  {
      "code": 400,
      "message": "json: cannot unmarshal number -2 into Go struct field Category.position of type uint64",
      "timestamp": 1589306325
  }

  {
      "code": 400,
      "message": "json: unknown field \"field_not_exists\"",
      "timestamp": 1589306367
  }
  • 404 for entity not found, e.g.

  {
      "code": 404,
      "message": "entity does not exist",
      "timestamp": 1589306199
  }
  • 304 for unaffected UPDATE or DELETE,
  • 201 for CREATE with the last inserted ID,
  • 200 for GET, UPDATE and DELETE

Download the folder.

Install Docker and execute the command below

$ docker-compose up --build

Run go build -mod=mod or go run -mod=mod main.go and read below.

Environment variables:

MYSQL_USER=user_myapp
MYSQL_PASSWORD=dbpassword
MYSQL_HOST=localhost
MYSQL_DATABASE=myapp

Download the schema from migration/db.sql and execute it against your MySQL server instance.

CREATE DATABASE IF NOT EXISTS myapp DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

USE myapp;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS categories;
CREATE TABLE categories  (
  id int(11) NOT NULL AUTO_INCREMENT,
  title varchar(255) NOT NULL,
  position int(11) NOT NULL,
  image_url varchar(255) NOT NULL,
  created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
);

DROP TABLE IF EXISTS products;
CREATE TABLE products  (
  id int(11) NOT NULL AUTO_INCREMENT,
  category_id int,
  title varchar(255) NOT NULL,
  image_url varchar(255) NOT NULL,
  price decimal(10,2) NOT NULL,
  description text NOT NULL,
  created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id),
  FOREIGN KEY (category_id) REFERENCES categories(id)
);

SET FOREIGN_KEY_CHECKS = 1;

Some request bodies can be found at: migration/api_category and migration/api_product. However I've provided a postman.json Collection that you can import to your POSTMAN and start playing with the API.

All write-access endpoints are "protected" via JWT, a client should "verify" itself. You'll need to manually take the token from the http://localhost:8080/token and put it on url parameter ?token=$token or to the Authentication: Bearer $token request header.

Testing is important. The code is written in a way that testing should be trivial (Pseudo/memory Database or SQLite local file could be integrated as well, for end-to-end tests a Docker image with MySQL and fire tests against that server). However, there is nothing(?) to see here.

• https://github.com/kataras/jwt (JWT parsing)
• https://github.com/go-sql-driver/mysql (Go Driver for MySQL)
• https://github.com/DATA-DOG/go-sqlmock (Testing DB see service/category_service_test.go)
• https://github.com/kataras/iris (HTTP)
• https://github.com/mailgun/groupcache (Caching)