bank-simulator-backend

README

bank-simulator-backend

This project aimed to build a bank simulator system. The system features include:

• User account CUDR.
• Retrive the bank account info owned by users.
• Making transation between two accounts.
• Retrive transation records from user.

For backend system, typically using Golang as programming language.

Table of Contents

• Installation
• Usage

Installation

Get latest production code.

git clone https://github.com/Petatron/bank-simulator-backend.git

Install basic required environment.

• Go installation
• Docker installation
• PostgresSQL installation

It is recommand to use Homebrew to manage and install if you are using Linux or try to use them on terminal. (Please make sure you have installed Homebrew before run below commands.)

brew install go
brew install docker
brew install postgresql

Usage

MakeFile

The project used MakeFile to set up docker image and migrate database to docker container.

# Pull docker image and start docker container.
make postgres
# Create database and set up username and password.
make createdb
# Remove database
make dropdb
# Create tables
make migrateup
# Remove database
make migratedown
# Gnerate Go code
make sqlc

SQLc

The project used SQLc to generate type-safe database connection Go code from SQL.

How to use SQLc in project?

make sqlc

Version 1.0.3