package store import "time" type PathLink struct { Path string CreatedAt int64 IsPrimary bool } func (s *Store) EnsurePathLinkColumns() error { if s.sqlBackend == storePostgreSQL { return s.EnsureDomainPathsSchema() } _, _ = s.DB.Exec(` ALTER TABLE paths ADD COLUMN is_primary INTEGER NOT NULL DEFAULT 0 `) return nil } func (s *Store) ListPathLinks( objectUUID string, ) ([]PathLink, error) { domainUUID, err := s.defaultDomainUUID() if err != nil { return nil, err } return s.ListPathLinksInDomain(domainUUID, objectUUID) } func (s *Store) ListPathLinksInDomain( domainUUID string, objectUUID string, ) ([]PathLink, error) { rows, err := s.DB.Query(` SELECT path, created_at, COALESCE(is_primary, 0) FROM paths WHERE domain_uuid = `+s.sqlParam(1)+` AND object_uuid = `+s.sqlParam(2)+` ORDER BY is_primary DESC, path ASC `, domainUUID, objectUUID) if err != nil { return nil, err } defer rows.Close() var out []PathLink for rows.Next() { var p PathLink var primary int err := rows.Scan( &p.Path, &p.CreatedAt, &primary, ) if err != nil { return nil, err } p.IsPrimary = primary != 0 out = append(out, p) } return out, rows.Err() } func (s *Store) AddPathLink( objectUUID string, path string, ) error { domainUUID, err := s.defaultDomainUUID() if err != nil { return err } return s.AddPathLinkInDomain(domainUUID, objectUUID, path) } func (s *Store) AddPathLinkInDomain(domainUUID, objectUUID, path string) (resultErr error) { defer func() { resultErr = s.sqlError("add path link", resultErr) }() if err := s.ensureLocalDomain(domainUUID); err != nil { return err } tx, cancel, err := s.beginPathMutation(domainUUID) defer cancel() if err != nil { return err } defer tx.Rollback() _, err = tx.Exec(` INSERT INTO paths ( domain_uuid, path, object_uuid, created_at, is_primary ) VALUES ( `+s.sqlParam(1)+`, `+s.sqlParam(2)+`, `+s.sqlParam(3)+`, `+s.sqlParam(4)+`, 0 ) `, domainUUID, normalizePath(path), objectUUID, time.Now().Unix()) if err != nil { return err } if err = tx.Commit(); err == nil { s.InvalidatePathCaches() } return err } func (s *Store) DeletePathLink( objectUUID string, path string, ) error { domainUUID, err := s.defaultDomainUUID() if err != nil { return err } return s.DeletePathLinkInDomain(domainUUID, objectUUID, path) } func (s *Store) DeletePathLinkInDomain(domainUUID, objectUUID, path string) (resultErr error) { defer func() { resultErr = s.sqlError("delete path link", resultErr) }() if err := s.ensureLocalDomain(domainUUID); err != nil { return err } tx, cancel, err := s.beginPathMutation(domainUUID) defer cancel() if err != nil { return err } defer tx.Rollback() _, err = tx.Exec(` DELETE FROM paths WHERE domain_uuid = `+s.sqlParam(1)+` AND object_uuid = `+s.sqlParam(2)+` AND path = `+s.sqlParam(3)+` `, domainUUID, objectUUID, normalizePath(path)) if err != nil { return err } if err = tx.Commit(); err == nil { s.InvalidatePathCaches() } return err } func (s *Store) SetPrimaryPathLink( objectUUID string, path string, ) error { domainUUID, err := s.defaultDomainUUID() if err != nil { return err } return s.SetPrimaryPathLinkInDomain(domainUUID, objectUUID, path) } func (s *Store) SetPrimaryPathLinkInDomain(domainUUID, objectUUID, path string) (resultErr error) { defer func() { resultErr = s.sqlError("set primary path", resultErr) }() if err := s.ensureLocalDomain(domainUUID); err != nil { return err } tx, cancel, err := s.beginPathMutation(domainUUID) defer cancel() if err != nil { return err } defer tx.Rollback() var exists bool if err := tx.QueryRow(`SELECT EXISTS(SELECT 1 FROM paths WHERE domain_uuid=`+s.sqlParam(1)+` AND object_uuid=`+s.sqlParam(2)+` AND path=`+s.sqlParam(3)+`)`, domainUUID, objectUUID, normalizePath(path)).Scan(&exists); err != nil { return err } if !exists { return ErrPathNotFound } _, err = tx.Exec(` UPDATE paths SET is_primary = 0 WHERE domain_uuid = `+s.sqlParam(1)+` AND object_uuid = `+s.sqlParam(2)+` `, domainUUID, objectUUID) if err != nil { tx.Rollback() return err } _, err = tx.Exec(` UPDATE paths SET is_primary = 1 WHERE domain_uuid = `+s.sqlParam(1)+` AND object_uuid = `+s.sqlParam(2)+` AND path = `+s.sqlParam(3)+` `, domainUUID, objectUUID, normalizePath(path)) if err != nil { tx.Rollback() return err } if err = tx.Commit(); err == nil { s.InvalidatePathCaches() } return err }