1 files changed, 110 insertions, 0 deletions
diff --git a/pkg/database/sql/user_test.go b/pkg/database/sql/user_test.go
new file mode 100644
index 0000000..875b8e6
--- /dev/null
+++ b/pkg/database/sql/user_test.go
@@ -0,0 +1,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/auth"
+)
+
+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)
+
+	id, err := repository.Create(context.Background(), &auth.CreateUser{
+		Username: "new_username",
+		Name:     "new_name",
+	})
+	if err != nil {
+		t.Fatalf("Error creating: %s", err.Error())
+	}
+
+	got, err := repository.Get(context.Background(), id)
+	if err != nil {
+		t.Fatalf("Error getting: %s", err.Error())
+	}
+	want := &auth.User{
+		ID:       id,
+		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)
+
+	id, err := repository.Create(context.Background(), &auth.CreateUser{
+		Username: "username",
+		Name:     "name",
+	})
+	if err != nil {
+		t.Fatalf("Error creating user: %s", err.Error())
+	}
+
+	err = repository.Update(context.Background(), id, &auth.UpdateUser{
+		Username: "new_username",
+		Name:     "new_name",
+	})
+	if err != nil {
+		t.Fatalf("Error update user: %s", err.Error())
+	}
+
+	got, err := repository.Get(context.Background(), id)
+	if err != nil {
+		t.Fatalf("Error getting user: %s", err.Error())
+	}
+	want := &auth.User{
+		ID:       id,
+		Username: "new_username",
+		Name:     "new_name",
+	}
+
+	if diff := cmp.Diff(want, got); diff != "" {
+		t.Errorf("%s() mismatch (-want +got):\n%s", "Update", diff)
+	}
+}