go package
- go-chi/chi: lightweight, idiomatic and composable router for building Go HTTP services
- jmoiron/sqlx: general purpose extensions to golang's database/sql
db
- MySQL
ENV
$ export DB_HOST=127.0.0.1
$ export DB_USER=root
$ export DB_PASS=***
$ export DB_NAME=go_sample
or Create an .env file
mysql> CREATE DATABASE go_sample;
mysql> use go_sample
mysql> CREATE TABLE IF NOT EXISTS `users` (
`id` BIGINT unsigned NOT NULL AUTO_INCREMENT,
`first_name` varchar(50) NOT NULL,
`last_name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
mysql> DESC users;
mysql> INSERT INTO users (first_name, last_name) VALUES ("tanaka", "taro");
mysql> INSERT INTO users (first_name, last_name) VALUES ("tanaka", "jiro");
mysql> SELECT * FROM users;$ go run main.go
$ curl -s -XGET localhost:8080/api/v1/users |jq .