/
githubmirror
/
pocketbase
Обзор
Документация
Войти
/
githubmirror
/
pocketbase
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
core/log_query.go
65 строк
2 KB
Gani Georgiev
updated logs code comments
11 фев 2025, 01:38
11 фев 2025, 01:38
5c41938
Код
Авторство
О чём код?
package core import ( "time" "github.com/pocketbase/dbx" "github.com/pocketbase/pocketbase/tools/types" ) // LogQuery returns a new Log select query. func (app *BaseApp) LogQuery() *dbx.SelectQuery { return app.AuxModelQuery(&Log{}) } // FindLogById finds a single Log entry by its id. func (app *BaseApp) FindLogById(id string) (*Log, error) { model := &Log{} err := app.LogQuery(). AndWhere(dbx.HashExp{"id": id}). Limit(1). One(model) if err != nil { return nil, err } return model, nil } // LogsStatsItem defines the total number of logs for a specific time period. type LogsStatsItem struct { Date types.DateTime `db:"date" json:"date"` Total int `db:"total" json:"total"` } // LogsStats returns hourly grouped logs statistics. func (app *BaseApp) LogsStats(expr dbx.Expression) ([]*LogsStatsItem, error) { result := []*LogsStatsItem{} query := app.LogQuery(). Select("count(id) as total", "strftime('%Y-%m-%d %H:00:00', created) as date"). GroupBy("date") if expr != nil { query.AndWhere(expr) } err := query.All(&result) return result, err } // DeleteOldLogs delete all logs that are created before createdBefore. // // For better performance the logs delete is executed as plain SQL statement, // aka. no delete model hook events will be fired. func (app *BaseApp) DeleteOldLogs(createdBefore time.Time) error { formattedDate := createdBefore.UTC().Format(types.DefaultDateLayout) expr := dbx.NewExp("[[created]] <= {:date}", dbx.Params{"date": formattedDate}) _, err := app.auxNonconcurrentDB.Delete((&Log{}).TableName(), expr).Execute() return err }