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

126 lines
2.7 KiB
Go

package store
import "database/sql"
func (s *Store) EnsureConfigTable() error {
domain, err := s.GetDefaultDomain()
if err != nil {
return err
}
_, err = s.DB.Exec(`
CREATE TABLE IF NOT EXISTS config (
domain_uuid TEXT NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
updated_at INTEGER NOT NULL,
PRIMARY KEY (domain_uuid, key)
)
`)
if err != nil {
return err
}
columns, err := tableColumns(s.DB, "config")
if err != nil {
return err
}
if columns["domain_uuid"] {
return nil
}
tx, err := s.DB.Begin()
if err != nil {
return err
}
defer tx.Rollback()
if _, err = tx.Exec(`
CREATE TABLE config_domain_scoped (
domain_uuid TEXT NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
updated_at INTEGER NOT NULL,
PRIMARY KEY (domain_uuid, key)
)
`); err != nil {
return err
}
if _, err = tx.Exec(`
INSERT INTO config_domain_scoped (domain_uuid, key, value, updated_at)
SELECT ?, key, value, updated_at FROM config
`, domain.UUID); err != nil {
return err
}
if _, err = tx.Exec(`DROP TABLE config`); err != nil {
return err
}
if _, err = tx.Exec(`
ALTER TABLE config_domain_scoped RENAME TO config
`); err != nil {
return err
}
return tx.Commit()
}
func tableColumns(db *sql.DB, table string) (map[string]bool, error) {
rows, err := db.Query(`PRAGMA table_info(` + table + `)`)
if err != nil {
return nil, err
}
defer rows.Close()
columns := map[string]bool{}
for rows.Next() {
var cid, notNull, primaryKey int
var name, kind string
var defaultValue any
if err := rows.Scan(
&cid, &name, &kind, &notNull, &defaultValue, &primaryKey,
); err != nil {
return nil, err
}
columns[name] = true
}
return columns, rows.Err()
}
func (s *Store) GetConfig(key string) (string, error) {
domainUUID, err := s.defaultDomainUUID()
if err != nil {
return "", err
}
return s.GetConfigInDomain(domainUUID, key)
}
func (s *Store) GetConfigInDomain(domainUUID, key string) (string, error) {
var value string
err := s.DB.QueryRow(`
SELECT value FROM config
WHERE domain_uuid = ? AND key = ?
`, domainUUID, key).Scan(&value)
if err == sql.ErrNoRows {
return "", nil
}
return value, err
}
func (s *Store) SetConfig(key, value string) error {
domainUUID, err := s.defaultDomainUUID()
if err != nil {
return err
}
return s.SetConfigInDomain(domainUUID, key, value)
}
func (s *Store) SetConfigInDomain(domainUUID, key, value string) error {
_, err := s.DB.Exec(`
INSERT INTO config (domain_uuid, key, value, updated_at)
VALUES (?, ?, ?, strftime('%s','now'))
ON CONFLICT(domain_uuid, key)
DO UPDATE SET
value = excluded.value,
updated_at = excluded.updated_at
`, domainUUID, key, value)
return err
}