goblog

Learning Go by building a simple blog APIs with GoLang, Echo

Install make on Windows

Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))
choco install make

#Install go-migrate cli

On Windows, you can install the cli using scoop

irm get.scoop.sh | iex
scoop install go-migrate

On Mac, you can install the cli using brew

brew install golang-migrate

On Linux, you can install the cli using apt

$ curl -L https://packagecloud.io/golang-migrate/migrate/gpgkey | apt-key add -
$ echo "deb https://packagecloud.io/golang-migrate/migrate/ubuntu/ $(lsb_release -sc) main" > /etc/apt/sources.list.d/migrate.list
$ apt-get update
$ apt-get install -y migrate

Create Database

Run postgres on docker

make postgres

Create database

make createdb

Migrate database to the latest version

make migrateup

If you want to migrate to a go back one version, use this command

make migratedown

Just in case you want to drop the database because it is dirty or something

make dropdb

To have more flexibility, you can use the migrate cli directly

run the app

go run github.com/tumivn/goblog/cmd/api

Build the cms app

go build -a -installsuffix cgo -ldflags "-extldflags -static" -tags musl go build -a -installsuffix cgo -ldflags "-extldflags -static" -tags musl github.com/tumivn/goblog/cmd/api

Build docker image

docker build -t tumivn/tumivn:goblog-v01 .

Run docker container, linking with postgres container

docker run --rm -p 8181:8080 --link postgres:postgres --name goblog -e DB_HOST=postgres -e DB_PORT=5432 -e DB_USER=postgres -e DB_PASSWORD=docker -e DB_NAME=goblog -e PORT=8080 -e JWT_SECRET=my_secret_key tumivn/tumivn:goblog-v01

Database migration

Using the golang-migrate/migrate library apply for database migration

Create seperated handler and entry point to run migration.

Create a migration files

$ migrate create -ext sql -dir internal/storage/migrations/ -seq migration_name

Login to get token

curl --header "Content-Type: application/json" \
  --request POST \
  --data '{"email": "[email protected]","password": "Abc@12345"}' \
  localhost:8181/api/auth/login

Try to get users

 curl -v --cookie "token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE3MjA4MTEwNjUsImlzc3VlciI6InR1bWl2bkBnbWFpbC5jb20ifQ.3BSVwwYVsheeQXwhhq_0R_TsBsyOOpcRsEgwTxfbyXE; Expires=Fri, 12 Jul 2024 19:04:25 GMT" http://localhost:8181/api/auth/users | jq

Test

 ab -n 5000 -c 100 -k -H "token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE3MjA4MTEwNjUsImlzc3VlciI6InR1bWl2bkBnbWFpbC5jb20ifQ.3BSVwwYVsheeQXwhhq_0R_TsBsyOOpcRsEgwTxfbyXE; Expires=Fri, 12 Jul 2024 19:04:25 GMT"  http://127.0.0.1:8181/api/auth/users