78 lines
2.7 KiB
Go
78 lines
2.7 KiB
Go
package store
|
|
|
|
import (
|
|
"context"
|
|
"database/sql"
|
|
"encoding/json"
|
|
"errors"
|
|
"strings"
|
|
"time"
|
|
"unicode"
|
|
"unicode/utf8"
|
|
)
|
|
|
|
const DefaultTaskDAVTitle = "PagesWiki Tasks"
|
|
|
|
func ValidTaskDAVTitle(title string) bool {
|
|
return strings.TrimSpace(title) != "" && len(title) <= 300 && utf8.ValidString(title) && strings.IndexFunc(title, unicode.IsControl) < 0
|
|
}
|
|
|
|
// The default list is a personal setting, not a synthetic project. Renaming it
|
|
// must not change task membership, resource identities, or another user's view.
|
|
func (s *Store) TaskDAVDefaultTitle(ctx context.Context, domain, actor string) (string, error) {
|
|
if err := s.taskActor(ctx, s.DB, domain, actor, false); err != nil {
|
|
return "", err
|
|
}
|
|
var title string
|
|
err := s.DB.QueryRowContext(ctx, `SELECT title FROM organizer_dav_default_lists WHERE domain_uuid=`+s.sqlParam(1)+` AND owner_uuid=`+s.sqlParam(2)+``, domain, actor).Scan(&title)
|
|
if errors.Is(err, sql.ErrNoRows) {
|
|
return DefaultTaskDAVTitle, nil
|
|
}
|
|
return title, err
|
|
}
|
|
|
|
func (s *Store) SetTaskDAVDefaultTitle(ctx context.Context, domain, actor, title, credential string) error {
|
|
if !ValidTaskDAVTitle(title) {
|
|
return ErrTaskInvalid
|
|
}
|
|
ctx, cancel := context.WithTimeout(ctx, 5*time.Second)
|
|
defer cancel()
|
|
tx, err := s.DB.BeginTx(ctx, nil)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
defer tx.Rollback()
|
|
if err = s.lockTaskWriter(ctx, tx); err != nil {
|
|
return err
|
|
}
|
|
// Acquire the writer before checking authority, as with task writes.
|
|
if _, err = tx.ExecContext(ctx, `UPDATE domain_memberships SET state=state WHERE domain_uuid=`+s.sqlParam(1)+` AND principal_uuid=`+s.sqlParam(2)+``, domain, actor); err != nil {
|
|
return err
|
|
}
|
|
if err = s.taskActor(ctx, tx, domain, actor, true); err != nil {
|
|
return err
|
|
}
|
|
if credential != "" {
|
|
if err = s.taskDAVCredentialAllowed(ctx, tx, domain, actor, credential, true); err != nil {
|
|
return err
|
|
}
|
|
}
|
|
var raw string
|
|
err = tx.QueryRowContext(ctx, `SELECT value FROM config WHERE domain_uuid=`+s.sqlParam(1)+` AND key='system_extension_states'`, domain).Scan(&raw)
|
|
if err != nil && !errors.Is(err, sql.ErrNoRows) {
|
|
return err
|
|
}
|
|
states := map[string]bool{}
|
|
if raw != "" && json.Unmarshal([]byte(raw), &states) != nil {
|
|
return ErrAccessDenied
|
|
}
|
|
if enabled, ok := states["organizer.tasks"]; ok && !enabled {
|
|
return ErrAccessDenied
|
|
}
|
|
_, err = tx.ExecContext(ctx, `INSERT INTO organizer_dav_default_lists(domain_uuid,owner_uuid,title,updated_at_ms) VALUES(`+s.sqlParam(1)+`,`+s.sqlParam(2)+`,`+s.sqlParam(3)+`,`+s.sqlParam(4)+`) ON CONFLICT(domain_uuid,owner_uuid) DO UPDATE SET title=excluded.title,updated_at_ms=excluded.updated_at_ms`, domain, actor, title, time.Now().UnixMilli())
|
|
if err != nil {
|
|
return err
|
|
}
|
|
return tx.Commit()
|
|
}
|