go-automatic-chainsaw -> bank-app [WIP]

Roadmap

run database migration in Golang golang-migrate after this [check migrate --version]

mkdir -p db/migration
migrate create -ext sql -dir db/migration -seq init_schema  #you will see up/down migration files

create Makefile in your root (to create/drop db with ease)

make createdb # you should see db by name bank_db
 # after migrate up to find out migration version and stats
ls -l db/migration

also you can use ORM like GORM but after some research like.1, like.2,... we decide to use sqlc

-   install sqlc

docker pull sqlc/sqlc #then use docker run ...
#or
yay sqlc

then init sqlc and generate sqlc config like here , insure use postgres config

then create all needed schemas files like here and queries files like here based on your db find sample here

then run

make sqlc # after this ./db/sqlc directory should contain generated go files [account/entry/transfer/.../db/model]

then you can write your own custom query like AddAccountBalance or default standard CRUD and enjoy

go get github.com/stretchr/testify #install package
go mod tidy #to update all used packages

then init your main_test.go for all test connection to db

now you can your test by sample for your account CRUD like this.

then run

make test # run all test by coverage

after run you can check success coverage code by highlights

final config should look like this

after install gin :
- create api folder and server.go file for base service configuration
- create main.go main.go file in root to init go for db,server
- after make server you can use Thunder Client or postman to check and test api
after install gomock :
- check installed is correctly by mockgen -version
- make Store as interface and make Querier by set emit_interface: true in sqlc
- create mock folder in db dir and :
```
make mock #path project go package / path store (db/sqlc)
```
  check store.go

🔰 install viper as a configuration file solution.
```
go get github.com/spf13/viper
```
then create app.env file to define configs. and config.go file to load configs in app
🔰 install paseto as a Platform-Agnostic Security Tokens. also you can use JWT, but after some research we decide to use paseto
```
go get -u github.com/o1egl/paseto
```
then create maker file to define base auth-token flow. and paseto_maker file to define paseto configs.

🟨 Initial auth-middleware to handle user access to apis just by right token