package store import ( "context" "database/sql" "errors" "fmt" "strings" "testing" "github.com/google/uuid" ) func contactsBackendFixture(t *testing.T, b storeSQLBackend) (*Store, string, string) { t.Helper() f := newPublicationBackend(t, b) s := f.s s.DocumentRoot = t.TempDir() if b == storeSQLite { if err := s.EnsureTasksSchema(); err != nil { t.Fatal(err) } } for i := 0; i < 2; i++ { if err := s.ensureSchemaComponent("contacts"); err != nil { t.Fatal(err) } } return s, f.domain, f.actor } func syntheticContact(uid string) string { return "BEGIN:VCARD\r\nVERSION:4.0\r\nUID:" + uid + "\r\nFN:日本語 Contact\r\nEMAIL:synthetic@example.invalid\r\nX-KEEP:retained\r\nEND:VCARD\r\n" } func TestContactsBackendContract(t *testing.T) { for _, b := range []storeSQLBackend{storeSQLite, storePostgreSQL} { t.Run(fmt.Sprint(b), func(t *testing.T) { s, d, a := contactsBackendFixture(t, b) ctx := context.Background() initial, err := s.ContactDAVSnapshot(ctx, d, a, "", 0) if err != nil { t.Fatal(err) } c, err := s.SaveContact(ctx, d, a, Contact{UUID: uuid.NewString(), VCard: syntheticContact("same-uid")}, true) if err != nil || c.Version != 1 { t.Fatal(c, err) } if got, err := s.SaveContact(ctx, d, a, Contact{UUID: uuid.NewString(), VCard: syntheticContact("same-uid")}, true); err != nil || got.UUID != c.UUID { t.Fatal("import idempotency", got, err) } if contacts, _, err := s.Contacts(ctx, d, a, "日本語", ""); err != nil || len(contacts) != 1 || contacts[0].VCard != "" { t.Fatal(contacts, err) } if inventory, err := s.ContactDAVInventory(ctx, d, a); err != nil || len(inventory.Items) != 1 || inventory.Items[0].VCard != "" || inventory.Items[0].Size != len(c.VCard) { t.Fatal(inventory, err) } c.Name = "Changed 日本語" old := c c, err = s.SaveContact(ctx, d, a, c, false) if err != nil || c.Version != 2 || !strings.Contains(c.VCard, "X-KEEP:retained") { t.Fatal(c, err) } if _, err = s.SaveContact(ctx, d, a, old, false); !errors.Is(err, ErrTaskConflict) { t.Fatal(err) } changes, err := s.ContactDAVSnapshot(ctx, d, a, initial.Token, 200) if err != nil || len(changes.Items) != 1 || changes.Items[0].Version != 2 { t.Fatal(changes, err) } if _, err = s.ContactDAVSnapshot(ctx, d, a, strings.Replace(changes.Token, "contacts:", "contacts:other", 1), 200); !errors.Is(err, ErrContactSyncToken) { t.Fatal(err) } c.Deleted = true c, err = s.SaveContact(ctx, d, a, c, false) if err != nil { t.Fatal(err) } if live, _, err := s.Contacts(ctx, d, a, "", ""); err != nil || len(live) != 0 { t.Fatal(live, err) } if deleted, _, err := s.ListContacts(ctx, d, a, "", "", true); err != nil || len(deleted) != 1 { t.Fatal(deleted, err) } if delta, err := s.ContactDAVSnapshot(ctx, d, a, changes.Token, 200); err != nil || len(delta.Items) != 1 || !delta.Items[0].Deleted { t.Fatal(delta, err) } if history, err := s.ContactHistory(ctx, d, a, c.UUID, 0); err != nil || len(history) != 3 { t.Fatal(history, err) } if revision, err := s.ContactAtRevision(ctx, d, a, c.UUID, 1); err != nil || revision.Name != "日本語 Contact" { t.Fatal(revision, err) } c, err = s.RestoreContactRevision(ctx, d, a, c.UUID, 1, c.Version) if err != nil || c.Deleted || c.Version != 4 || c.Name != "日本語 Contact" { t.Fatal(c, err) } if exported, err := s.ExportContacts(ctx, d, a); err != nil || exported != c.VCard { t.Fatal("export", err) } if _, err = s.Contact(ctx, d, uuid.NewString(), c.UUID); err == nil { t.Fatal("foreign owner read") } credential, _, err := s.CreateDAVCredential(ctx, d, a, "Contact writer", true, 1, "contacts") if err != nil { t.Fatal(err) } dav, err := s.SaveContactDAV(ctx, d, a, credential.ID, "client.vcf", syntheticContact("dav-uid"), 0, false) if err != nil { t.Fatal(err) } if got, err := s.ContactDAVResource(ctx, d, a, "client.vcf"); err != nil || got.UUID != dav.UUID { t.Fatal(got, err) } if _, err = s.SaveContactDAV(ctx, d, a, credential.ID, "other.vcf", syntheticContact("dav-uid"), 0, false); !errors.Is(err, ErrContactUIDConflict) { t.Fatal(err) } page, err := s.ContactDAVSnapshot(ctx, d, a, "", 1) if err != nil || !page.More || len(page.Items) != 1 { t.Fatal(page, err) } next, err := s.ContactDAVSnapshot(ctx, d, a, page.Token, 1) if err != nil || next.More || len(next.Items) != 1 || next.Items[0].UUID == page.Items[0].UUID { t.Fatal(next, err) } if err = s.RevokeTaskDAVCredential(ctx, d, a, credential.ID); err != nil { t.Fatal(err) } if _, err = s.SaveContactDAV(ctx, d, a, credential.ID, "client.vcf", dav.VCard, dav.Version, false); !errors.Is(err, ErrAccessDenied) { t.Fatal(err) } var count int if err = s.DB.QueryRow(`SELECT count(*) FROM organizer_contact_credentials`).Scan(&count); err != nil || count != 0 { t.Fatal(count, err) } s.ReadOnly = true if _, err = s.SaveContact(ctx, d, a, c, false); !errors.Is(err, ErrReadOnly) { t.Fatal(err) } }) } } func TestPostgreSQLContactsAtomicity(t *testing.T) { s, d, a := contactsBackendFixture(t, storePostgreSQL) ctx := context.Background() c, err := s.SaveContact(ctx, d, a, Contact{UUID: uuid.NewString(), Name: "Synthetic"}, false) if err != nil { t.Fatal(err) } peer := &Store{DB: s.DB, sqlBackend: storePostgreSQL, DocumentRoot: s.DocumentRoot} token, err := s.ContactDAVSnapshot(ctx, d, a, "", 0) if err != nil { t.Fatal(err) } if _, err = s.DB.Exec(`ALTER TABLE organizer_contact_revisions RENAME COLUMN hash TO unavailable_hash`); err != nil { t.Fatal(err) } changed := c changed.Name = "must rollback" if _, err = s.SaveContact(ctx, d, a, changed, false); err == nil { t.Fatal("fault ignored") } if _, err = s.DB.Exec(`ALTER TABLE organizer_contact_revisions RENAME COLUMN unavailable_hash TO hash`); err != nil { t.Fatal(err) } if got, err := s.Contact(ctx, d, a, c.UUID); err != nil || got.Version != c.Version || got.Name != c.Name { t.Fatal("partial contact", got, err) } if delta, err := s.ContactDAVSnapshot(ctx, d, a, token.Token, 200); err != nil || len(delta.Items) != 0 || delta.Token != token.Token { t.Fatal("partial sync sequence", delta, err) } ch := make(chan error, 2) for _, w := range []*Store{s, peer} { go func(w *Store) { _, e := w.SaveContact(ctx, d, a, changed, false); ch <- e }(w) } wins := 0 for i := 0; i < 2; i++ { e := <-ch if e == nil { wins++ } else if !errors.Is(e, ErrTaskConflict) { t.Fatal(e) } } if wins != 1 { t.Fatal(wins) } got, err := s.Contact(ctx, d, a, c.UUID) if err != nil || got.Version != 2 { t.Fatal(got, err) } if history, err := s.ContactHistory(ctx, d, a, c.UUID, 0); err != nil || len(history) != 2 { t.Fatal(history, err) } // Revocation and source updates share the namespace writer lock. if _, err = s.DB.Exec(`UPDATE domain_memberships SET state='suspended' WHERE domain_uuid=$1 AND principal_uuid=$2`, d, a); err != nil { t.Fatal(err) } if _, err = s.ContactDAVInventory(ctx, d, a); !errors.Is(err, ErrAccessDenied) { t.Fatal(err) } if _, err = s.SaveContact(ctx, d, a, got, false); !errors.Is(err, ErrAccessDenied) { t.Fatal(err) } if _, err = s.DB.Exec(`UPDATE domain_memberships SET state='active' WHERE domain_uuid=$1 AND principal_uuid=$2`, d, a); err != nil { t.Fatal(err) } if _, err = s.Contact(ctx, d, a, uuid.NewString()); !errors.Is(err, sql.ErrNoRows) { t.Fatal(err) } }