/
githubmirror
/
syncthing
Обзор
Документация
Войти
/
githubmirror
/
syncthing
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/db/sqlite/db_stats.go
69 строк
2 KB
Jakob Borg
feat: add `syncthing debug database-statistics` command (#10117)
20 май 2025, 15:27
Не верифицирован
20 май 2025, 15:27
085455d
Код
Авторство
О чём код?
// Copyright (C) 2025 The Syncthing Authors. // // This Source Code Form is subject to the terms of the Mozilla Public // License, v. 2.0. If a copy of the MPL was not distributed with this file, // You can obtain one at https://mozilla.org/MPL/2.0/. package sqlite type DatabaseStatistics struct { Name string `json:"name"` FolderID string `json:"folderID,omitempty"` Tables []TableStatistics `json:"tables"` Total TableStatistics `json:"total"` Children []DatabaseStatistics `json:"children,omitempty"` } type TableStatistics struct { Name string `json:"name,omitempty"` Size int64 `json:"size"` Unused int64 `json:"unused"` } func (s *DB) Statistics() (*DatabaseStatistics, error) { ts, total, err := s.tableStats() if err != nil { return nil, wrap(err) } ds := DatabaseStatistics{ Name: s.baseName, Tables: ts, Total: total, } err = s.forEachFolder(func(fdb *folderDB) error { tables, total, err := fdb.tableStats() if err != nil { return wrap(err) } ds.Children = append(ds.Children, DatabaseStatistics{ Name: fdb.baseName, FolderID: fdb.folderID, Tables: tables, Total: total, }) return nil }) if err != nil { return nil, wrap(err) } return &ds, nil } func (s *baseDB) tableStats() ([]TableStatistics, TableStatistics, error) { var stats []TableStatistics if err := s.stmt(` SELECT name, pgsize AS size, unused FROM dbstat WHERE aggregate=true ORDER BY name `).Select(&stats); err != nil { return nil, TableStatistics{}, wrap(err) } var total TableStatistics for _, s := range stats { total.Size += s.Size total.Unused += s.Unused } return stats, total, nil }