//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/database/repository" ) 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() userRepository := NewUserRepository(db) id, err := userRepository.Create(context.Background(), &repository.CreateUser{ Username: "new_username", Name: "new_name", }) if err != nil { t.Fatalf("Error creating: %s", err.Error()) } got, err := userRepository.Get(context.Background(), id) if err != nil { t.Fatalf("Error getting: %s", err.Error()) } want := &repository.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() userRepository := NewUserRepository(db) id, err := userRepository.Create(context.Background(), &repository.CreateUser{ Username: "username", Name: "name", }) if err != nil { t.Fatalf("Error creating user: %s", err.Error()) } err = userRepository.Update(context.Background(), id, &repository.UpdateUser{ Username: "new_username", Name: "new_name", }) if err != nil { t.Fatalf("Error update user: %s", err.Error()) } got, err := userRepository.Get(context.Background(), 1) if err != nil { t.Fatalf("Error getting user: %s", err.Error()) } want := &repository.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) } }