Files
pages/internal/store/path_links.go
Anya Tokugawa c1175d389f Implement Knowledge City platform, organizer and DAV integration
Capture accumulated application, UI, CLI, regression tests and design documentation changes, including task project mapping and default CalDAV list naming.

Keep deployment data, backups, local credentials and build artifacts out of Git. Move the Compose enrollment token to an ignored local environment file.
2026-09-27 14:44:43 +09:00

185 lines
3.1 KiB
Go

package store
type PathLink struct {
Path string
CreatedAt int64
IsPrimary bool
}
func (s *Store) EnsurePathLinkColumns() error {
_, _ = 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 = ?
AND object_uuid = ?
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, nil
}
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) error {
if err := s.ensureLocalDomain(domainUUID); err != nil {
return err
}
_, err := s.DB.Exec(`
INSERT INTO paths (
domain_uuid,
path,
object_uuid,
created_at,
is_primary
)
VALUES (
?,
?,
?,
strftime('%s','now'),
0
)
`, domainUUID, normalizePath(path), objectUUID)
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) error {
if err := s.ensureLocalDomain(domainUUID); err != nil {
return err
}
_, err := s.DB.Exec(`
DELETE FROM paths
WHERE domain_uuid = ?
AND object_uuid = ?
AND path = ?
`, domainUUID, objectUUID, normalizePath(path))
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) error {
if err := s.ensureLocalDomain(domainUUID); err != nil {
return err
}
tx, err := s.DB.Begin()
if err != nil {
return err
}
_, err = tx.Exec(`
UPDATE paths
SET is_primary = 0
WHERE domain_uuid = ?
AND object_uuid = ?
`, domainUUID, objectUUID)
if err != nil {
tx.Rollback()
return err
}
_, err = tx.Exec(`
UPDATE paths
SET is_primary = 1
WHERE domain_uuid = ?
AND object_uuid = ?
AND path = ?
`, domainUUID, objectUUID, normalizePath(path))
if err != nil {
tx.Rollback()
return err
}
return tx.Commit()
}