Father Scott

func (a *Account) Insert(db *sql.DB) {
    now := time.Now()
    sql_statement := "INSERT INTO account (account_id, device_model, memory_size, created_at) VALUES ($1, $2, $3, $4);"
    _, err := db.Exec(sql_statement, a.AccountId, a.DeviecModel, a.MemorySize, now)
    if err != nil {
        sql_statement = "UPDATE account SET device_model = $1, memory_size = $2, created_at = $3 WHERE account_id = $4;"
        result, _ := db.Exec(sql_statement, a.DeviecModel, a.MemorySize, now, a.AccountId)

        row, err := result.RowsAffected()

        if row == 0 || err != nil {
            log.Panic().Stack().Err(err).Msg("Insert")
        }
    }
}

version: '3.3'
services:
  redis:
    image: 'redis:6.0.5'
    environment:
      ALLOW_EMPTY_PASSWORD: "yes"
    ports:
    - 6379:6379
    volumes:
    - /mnt/d/docker/Redis/Log:/data
    - /mnt/d/docker/Redis/redis.conf:/usr/local/etc/redis/redis.conf
  mysql5.7:
    image: mysql:5.7.28
    command: --default-authentication-plugin=mysql_native_password
    environment:
      MYSQL_ROOT_PASSWORD: coral
    ports:
    - 3306:3306
    volumes:
    - /home/mysql5.7/Data:/var/lib/mysql
    - /home/mysql5.7/:/etc/mysql/
  postgreSQL:
    image: postgres
    restart: always
    environment:
      POSTGRES_PASSWORD: "test"      
    ports:
    - 5432:5432
    volumes:
    - /home/postgreSQL:/var/lib/postgresql/data

docker ps 로 이미명 찾자

# docker exec -it 4f85072fd34a bash

디비에 들어가자

 psql -U postgres

계정 생성

postgres=#  CREATE USER test PASSWORD 'test' SUPERUSER;

사용하자

On UNIX and OS X

$ export P4CLIENT=bruno_ws

On Windows

$ set P4CLIENT=bruno_ws