Files
pages/internal/store/domain_paths.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

135 lines
2.5 KiB
Go

package store
import (
"database/sql"
"errors"
)
func (s *Store) EnsureDomainPathsSchema() error {
defaultDomain, err := s.GetDefaultDomain()
if err != nil {
return err
}
if _, err := s.DB.Exec(`
CREATE TABLE IF NOT EXISTS paths (
domain_uuid TEXT NOT NULL,
path TEXT NOT NULL,
object_uuid TEXT NOT NULL,
created_at INTEGER NOT NULL,
is_primary INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (domain_uuid, path)
)
`); err != nil {
return err
}
columns, err := pathTableColumns(s.DB)
if err != nil {
return err
}
if columns["domain_uuid"] {
_, err = s.DB.Exec(`
UPDATE paths
SET domain_uuid = ?
WHERE domain_uuid IS NULL OR domain_uuid = ''
`, defaultDomain.UUID)
return err
}
hasPrimary := columns["is_primary"]
primaryExpr := "0"
if hasPrimary {
primaryExpr = "COALESCE(is_primary, 0)"
}
tx, err := s.DB.Begin()
if err != nil {
return err
}
defer tx.Rollback()
if _, err = tx.Exec(`
CREATE TABLE paths_domain_scoped (
domain_uuid TEXT NOT NULL,
path TEXT NOT NULL,
object_uuid TEXT NOT NULL,
created_at INTEGER NOT NULL,
is_primary INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (domain_uuid, path)
)
`); err != nil {
return err
}
if _, err = tx.Exec(`
INSERT INTO paths_domain_scoped (
domain_uuid, path, object_uuid, created_at, is_primary
)
SELECT ?, path, object_uuid, COALESCE(created_at, 0), `+
primaryExpr+`
FROM paths
`, defaultDomain.UUID); err != nil {
return err
}
if _, err = tx.Exec(`DROP TABLE paths`); err != nil {
return err
}
if _, err = tx.Exec(`
ALTER TABLE paths_domain_scoped RENAME TO paths
`); err != nil {
return err
}
if _, err = tx.Exec(`
CREATE INDEX idx_paths_object_uuid
ON paths(object_uuid)
`); err != nil {
return err
}
return tx.Commit()
}
func pathTableColumns(db *sql.DB) (map[string]bool, error) {
rows, err := db.Query(`PRAGMA table_info(paths)`)
if err != nil {
return nil, err
}
defer rows.Close()
columns := map[string]bool{}
for rows.Next() {
var cid int
var name, kind string
var notNull, primaryKey int
var defaultValue any
if err := rows.Scan(
&cid,
&name,
&kind,
&notNull,
&defaultValue,
&primaryKey,
); err != nil {
return nil, err
}
columns[name] = true
}
if err := rows.Err(); err != nil {
return nil, err
}
if len(columns) == 0 {
return nil, errors.New("paths table is missing")
}
return columns, nil
}
func (s *Store) defaultDomainUUID() (string, error) {
domain, err := s.GetDefaultDomain()
if err != nil {
return "", err
}
return domain.UUID, nil
}