README.md

Simple Bank

This repository contains the codes of the Backend master class course by TECH SCHOOL.

In this backend master class, we’re going to learn everything about how to design, develop, and deploy a complete backend system from scratch using PostgreSQL, Golang and Docker.

Course videos:

• Lecture #1: Design DB schema and generate SQL code with dbdiagram.io
• Lecture #2: Install & use Docker + Postgres + TablePlus to create DB schema
• Lecture #3: How to write & run database migration in Golang
• Lecture #4: Generate CRUD Golang code from SQL | Compare db/sql, gorm, sqlx & sqlc
• Lecture #5: Write unit tests for database CRUD with random data in Golang
• Lecture #6: A clean way to implement database transaction in Golang
• Lecture #7: DB transaction lock & How to handle deadlock in Golang
• Lecture #8: How to avoid deadlock in DB transaction? Queries order matters!
• Lecture #9: Deeply understand transaction isolation levels & read phenomena in MySQL & PostgreSQL

Simple bank service

The service that we’re going to build is a simple bank. It will provide APIs for the frontend to do following things:

1. Create and manage bank accounts, which are composed of owner’s name, balance, and currency.
2. Record all balance changes to each of the account. So every time some money is added to or subtracted from the account, an account entry record will be created.
3. Perform a money transfer between 2 accounts. This should happen within a transaction, so that either both accounts’ balance are updated successfully or none of them are.

Setup local development

Install tools

• Docker desktop

• TablePlus

• Golang

• Homebrew

• Migrate

  brew install golang-migrate

• Sqlc

  brew install golang-migrate

Setup infrastructure

• Start postgres container:

  make postgres

• Create simple_bank database:

  make createdb

• Run db migration:

  make migrateup

How to run

• Run test:

  make test