yusufsholeh

// Class ORM 
type Mitra struct {
	gorm.Model
	Phone    string `gorm:"type:varchar(50);not null;unique default:null"`
	Email	 string `gorm:"type:varchar(50);not null;unique"`
	Password string
}

type MitraRepository struct {
}

yusufsholeh

func TestMitraGetByPhoneNumber(t *testing.T) {
	var mitraFieldNames = []string{"id", "phone", "email", "password"}
	rows := sqlmock.NewRows(mitraFieldNames)
	rows.AddRow("1", "0812345678", "abdul@gmail.com", "abcdefghi")
	db, mock, _ := sqlmock.New()
	gormDb, _ := gorm.Open("postgres", db)
	gormDb.LogMode(true)
}

yusufsholeh

func TestMitraGetByPhoneNumber(t *testing.T) {
	var mitraFieldNames = []string{"id", "phone", "email", "password"}
	rows := sqlmock.NewRows(mitraFieldNames)
	rows.AddRow("1", "0812345678", "abdul@gmail.com", "abcdefghi")
	db, mock, _ := sqlmock.New()
	gormDb, _ := gorm.Open("postgres", db)
	gormDb.LogMode(true)
  	mock.ExpectQuery("^SELECT (.+) FROM \"mitras\".+$").WillReturnRows(rows)
	models.SetDB(gormDb)
	mitraRepo := new(MitraRepository)

yusufsholeh

package customercontrollers

import (
	"encoding/json"
	"net/http"
)

func writeEncoded(w http.ResponseWriter, data interface{}) {
	w.Header().Add("Content-Type", "application/json")
	json.NewEncoder(w).Encode(data)

yusufsholeh

type UserProfileService struct {
}

// class UserProfileServices implements this interface
type IUserProfileService interface {
	GetUserProfile(userID int) (*models.User, error)
}

yusufsholeh

// class ORM: models.User
type User struct {
	UserID   int
	Name     string
	Email    string
   	Phone    string
   	Address  string
	Password string
}

yusufsholeh

type UserProfileService struct {
    UserRepository repositories.IUserRepository // masukkan interface repository ke dalam UserProfileServices  
}

// class UserProfileServices implements this interface
type IUserProfileService interface {
	GetUserProfile(userID int) (*models.User, error)
}

yusufsholeh

import "backend/repositories"

type UserProfileService struct {
	UserRepository repositories.IUserRepository // put the dependency!!
}

// class UserProfileServices implements this interface
type IUserProfileService interface {
	GetUserProfile(userID int) (*models.User, error)
}

yusufsholeh

func main() {
    ...
    
    userRepository := new(UserRepository) // initiate an object
    
    // initiate userProfileService object
    userProfileService := UserProfileService{
        UserRepository: userRepository // <--- inject !!
    }
    

yusufsholeh

-- +migrate Up

-- SEQUENCE: public.customers_id_seq
CREATE SEQUENCE customers_id_seq;

-- Table: public.customers
CREATE TABLE customers
(
    id integer NOT NULL DEFAULT nextval('customers_id_seq'::regclass),