dickyaryag6

// Code generated by MockGen. DO NOT EDIT.
// Source: gomocking/repository (interfaces: DatabaseInterface)

// Package mocks is a generated GoMock package.
package mocks

import (
	gomock "github.com/golang/mock/gomock"
	reflect "reflect"
)

dickyaryag6

package repository

import (
	"fmt"
)

type Database struct {}

func New(db Database) Database {
	return db

dickyaryag6

package repository

type DatabaseInterface interface {
	Insert(number int) error
}

dickyaryag6

package usecase

import (
	"errors"
	"gomocking/mocks"
	"gomocking/repository"
	"testing"

	"github.com/golang/mock/gomock"
	"github.com/undefinedlabs/go-mpatch"

dickyaryag6

package usecase

import (
	"errors"
	"gomocking/repository"
	"strconv"
)

type Usecase struct {
	Database repository.DatabaseInterface

dickyaryag6

package main

import (
	"fmt"
	uc "gomocking/usecase"
	db "gomocking/database"
)

func main() {

dickyaryag6

INSERT INTO person
(name, country, job, age)
values ('Mike', 'England', 'Software Engineer', 30)
ON CONFLICT ON CONSTRAINT person_name_country_unique
DO NOTHING;

dickyaryag6

ALTER TABLE person
ADD CONSTRAINT person_name_country_unique UNIQUE ("name", country);

dickyaryag6

INSERT INTO person
(name, country, job, age)
values ('Mike', 'England', 'Software Engineer', 5)
ON CONFLICT (name)
DO UPDATE SET age = person.age + EXCLUDED.age;

dickyaryag6

INSERT INTO person
(name, country, job, age)
values ('Peter', 'Egypt', 'Engineering Manager', 32)
ON CONFLICT (name)
DO UPDATE SET job = EXCLUDED.job || ',' || person.job;