Skip to content

armgit / ente

Public Imported from GitHub
0

πŸ’š End-to-end encrypted cloud for everything.

4.6 KB
Raw Blame
package repo

import (
	"database/sql"
	"testing"

	"github.com/ente/museum/ente"
	"github.com/ente/museum/pkg/repo/public"
)

func TestGetStoredFileCountsReturnsMinusOneUntilInitialized(t *testing.T) {
	_, db, userID := setupCollectionMembershipTest(t)
	usageRepo := &UsageRepository{DB: db}
	for _, tt := range []struct {
		name                            string
		sql                             string
		storageConsumed, photos, locker int64
	}{
		{"uninitialized", "", 0, -1, -1},
		{"ready", `UPDATE usage SET storage_consumed = 42, photos_file_count = 0, locker_file_count = 7 WHERE user_id = $1`, 42, 0, 7},
		{"missing", `DELETE FROM usage WHERE user_id = $1`, 0, -1, -1},
	} {
		t.Run(tt.name, func(t *testing.T) {
			if tt.sql != "" {
				if _, err := db.Exec(tt.sql, userID); err != nil {
					t.Fatal(err)
				}
			}
			storageConsumed, photos, locker, err := usageRepo.GetStoredFileCounts(t.Context(), userID)
			if err != nil || storageConsumed != tt.storageConsumed || photos != tt.photos || locker != tt.locker {
				t.Fatalf("GetStoredFileCounts() = (%d, %d, %d, %v), want (%d, %d, %d, nil)", storageConsumed, photos, locker, err, tt.storageConsumed, tt.photos, tt.locker)
			}
		})
	}
}

func TestTrashAndRestoreMaintainReadyLockerCount(t *testing.T) {
	repository, db, userID := setupCollectionMembershipTest(t)
	setReadyFileCounts(t, db, userID, 0, 1)
	firstCollectionID := insertObjectTestCollection(t, db, userID)
	secondCollectionID := insertObjectTestCollection(t, db, userID)
	if _, err := db.Exec(`UPDATE collections SET app = 'locker'
		WHERE collection_id IN ($1, $2)`, firstCollectionID, secondCollectionID); err != nil {
		t.Fatal(err)
	}
	fileID := insertObjectTestFile(t, db, userID)
	linkObjectTestFileToCollection(t, db, firstCollectionID, fileID, userID)
	linkObjectTestFileToCollection(t, db, secondCollectionID, fileID, userID)
	repository.TrashRepo.FileLinkRepo = public.NewFileLinkRepo(db)

	if err := repository.TrashRepo.TrashFiles(t.Context(), userID, ente.TrashRequest{
		TrashItems: []ente.TrashItemRequest{{FileID: fileID, CollectionID: firstCollectionID}},
	}); err != nil {
		t.Fatalf("TrashFiles() error = %v", err)
	}
	assertReadyFileCounts(t, db, userID, 0, 0, 1)

	if err := repository.RestoreFiles(t.Context(), userID, firstCollectionID,
		[]ente.CollectionFileItem{collectionMembershipTestItem(fileID)}); err != nil {
		t.Fatalf("RestoreFiles() error = %v", err)
	}
	assertReadyFileCounts(t, db, userID, 0, 1, 2)
}

func TestTrashInvalidatesCrossAppFileCounts(t *testing.T) {
	repository, db, userID := setupCollectionMembershipTest(t)
	setReadyFileCounts(t, db, userID, 1, 1)
	photosCollectionID := insertObjectTestCollection(t, db, userID)
	lockerCollectionID := insertObjectTestCollection(t, db, userID)
	if _, err := db.Exec(`UPDATE collections SET app = 'locker' WHERE collection_id = $1`, lockerCollectionID); err != nil {
		t.Fatal(err)
	}
	fileID := insertObjectTestFile(t, db, userID)
	linkObjectTestFileToCollection(t, db, photosCollectionID, fileID, userID)
	linkObjectTestFileToCollection(t, db, lockerCollectionID, fileID, userID)
	repository.TrashRepo.FileLinkRepo = public.NewFileLinkRepo(db)

	if err := repository.TrashRepo.TrashFiles(t.Context(), userID, ente.TrashRequest{
		TrashItems: []ente.TrashItemRequest{{FileID: fileID, CollectionID: photosCollectionID}},
	}); err != nil {
		t.Fatalf("TrashFiles() error = %v", err)
	}

	photos, locker, version := readFileCountState(t, db, userID)
	if photos.Valid || locker.Valid || version != 1 {
		t.Fatalf("file count state = (%v, %v, %d), want (NULL, NULL, 1)", photos, locker, version)
	}
}

func setReadyFileCounts(t *testing.T, db *sql.DB, userID, photos, locker int64) {
	t.Helper()
	if _, err := db.Exec(`UPDATE usage
		SET photos_file_count = $2, locker_file_count = $3
		WHERE user_id = $1`, userID, photos, locker); err != nil {
		t.Fatal(err)
	}
}

func assertReadyFileCounts(t *testing.T, db *sql.DB, userID, wantPhotos, wantLocker, wantVersion int64) {
	t.Helper()
	photos, locker, version := readFileCountState(t, db, userID)
	if !photos.Valid || photos.Int64 != wantPhotos || !locker.Valid || locker.Int64 != wantLocker || version != wantVersion {
		t.Fatalf("file count state = (%v, %v, %d), want (%d, %d, %d)", photos, locker, version, wantPhotos, wantLocker, wantVersion)
	}
}

func readFileCountState(t *testing.T, db *sql.DB, userID int64) (sql.NullInt64, sql.NullInt64, int64) {
	t.Helper()
	var photos, locker sql.NullInt64
	var version int64
	if err := db.QueryRow(`SELECT photos_file_count, locker_file_count, file_count_source_version
		FROM usage WHERE user_id = $1`, userID).Scan(&photos, &locker, &version); err != nil {
		t.Fatal(err)
	}
	return photos, locker, version
}