aboutsummaryrefslogtreecommitdiff
path: root/pkg/database/sql/user_test.go
blob: 473ce032516e298768da908b7e64f84e4f705bce (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
//go:build integration

package sql

import (
	"context"
	"os"
	"testing"

	"github.com/google/go-cmp/cmp"
	"gorm.io/driver/sqlite"
	"gorm.io/gorm"
	"gorm.io/gorm/logger"

	"git.sr.ht/~gabrielgio/img/pkg/components/user"
)

func setup(t *testing.T) (*gorm.DB, func()) {
	t.Helper()

	file, err := os.CreateTemp("", "img_user_*.db")
	if err != nil {
		t.Fatalf("Error creating tmp error: %s", err.Error())
	}

	db, err := gorm.Open(sqlite.Open(file.Name()), &gorm.Config{
		Logger: logger.Default.LogMode(logger.Info),
	})
	if err != nil {
		t.Fatalf("Error openning db, error %s", err.Error())
	}

	err = Migrate(db)
	if err != nil {
		t.Fatalf("Error migrating db, error %s", err.Error())
	}

	return db, func() {
		//nolint:errcheck
		os.Remove(file.Name())
	}
}

func TestCreate(t *testing.T) {
	t.Parallel()
	db, tearDown := setup(t)
	defer tearDown()

	repository := NewUserRepository(db)

	err := repository.Create(context.Background(), &user.CreateUser{
		Username: "new_username",
		Name:     "new_name",
	})
	if err != nil {
		t.Fatalf("Error creating: %s", err.Error())
	}

	got, err := repository.Get(context.Background(), 1)
	if err != nil {
		t.Fatalf("Error getting: %s", err.Error())
	}
	want := &user.User{
		ID:       1,
		Username: "new_username",
		Name:     "new_name",
	}

	if diff := cmp.Diff(want, got); diff != "" {
		t.Errorf("%s() mismatch (-want +got):\n%s", "Update", diff)
	}
}

func TestUpdate(t *testing.T) {
	t.Parallel()
	db, tearDown := setup(t)
	defer tearDown()

	repository := NewUserRepository(db)

	err := repository.Create(context.Background(), &user.CreateUser{
		Username: "username",
		Name:     "name",
	})
	if err != nil {
		t.Fatalf("Error creating user: %s", err.Error())
	}

	err = repository.Update(context.Background(), 1, &user.UpdateUser{
		Username: "new_username",
		Name:     "new_name",
	})
	if err != nil {
		t.Fatalf("Error update user: %s", err.Error())
	}

	got, err := repository.Get(context.Background(), 1)
	if err != nil {
		t.Fatalf("Error getting user: %s", err.Error())
	}
	want := &user.User{
		ID:       1,
		Username: "new_username",
		Name:     "new_name",
	}

	if diff := cmp.Diff(want, got); diff != "" {
		t.Errorf("%s() mismatch (-want +got):\n%s", "Update", diff)
	}
}