Files
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

71 lines
1.4 KiB
Go

package store
type Object struct {
UUID string
Kind string
CreatedAt int64
}
func (s *Store) ListObjects() ([]Object, error) {
rows, err := s.DB.Query(`
SELECT
uuid,
COALESCE(kind, '') AS kind,
created_at
FROM objects
ORDER BY created_at DESC
`)
if err != nil {
return nil, err
}
defer rows.Close()
var out []Object
for rows.Next() {
var o Object
err := rows.Scan(
&o.UUID,
&o.Kind,
&o.CreatedAt,
)
if err != nil {
return nil, err
}
out = append(out, o)
}
return out, nil
}
// ListObjectsInDomain returns only Objects with a live semantic binding in the
// requested Domain. Authorization of each returned Object remains an HTTP
// layer concern because direct Object grants are also supported.
func (s *Store) ListObjectsInDomain(domainUUID string) ([]Object, error) {
rows, err := s.DB.Query(`
SELECT o.uuid, COALESCE(o.kind,''), o.created_at
FROM objects o
WHERE EXISTS (SELECT 1 FROM paths p WHERE p.domain_uuid=? AND p.object_uuid=o.uuid)
ORDER BY o.created_at DESC, o.uuid`, domainUUID)
if err != nil {
return nil, err
}
defer rows.Close()
var out []Object
for rows.Next() {
var object Object
if err := rows.Scan(&object.UUID, &object.Kind, &object.CreatedAt); err != nil {
return nil, err
}
out = append(out, object)
}
return out, rows.Err()
}