Spaces:
Running
Running
File size: 2,288 Bytes
215df2f |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 |
package db
import (
"fmt"
"sort"
"github.com/alist-org/alist/v3/internal/model"
"github.com/pkg/errors"
)
// why don't need `cache` for storage?
// because all storage store in `op.storagesMap`
// the most of the read operation is from `op.storagesMap`
// just for persistence in database
// CreateStorage just insert storage to database
func CreateStorage(storage *model.Storage) error {
return errors.WithStack(db.Create(storage).Error)
}
// UpdateStorage just update storage in database
func UpdateStorage(storage *model.Storage) error {
return errors.WithStack(db.Save(storage).Error)
}
// DeleteStorageById just delete storage from database by id
func DeleteStorageById(id uint) error {
return errors.WithStack(db.Delete(&model.Storage{}, id).Error)
}
// GetStorages Get all storages from database order by index
func GetStorages(pageIndex, pageSize int) ([]model.Storage, int64, error) {
storageDB := db.Model(&model.Storage{})
var count int64
if err := storageDB.Count(&count).Error; err != nil {
return nil, 0, errors.Wrapf(err, "failed get storages count")
}
var storages []model.Storage
if err := storageDB.Order(columnName("order")).Offset((pageIndex - 1) * pageSize).Limit(pageSize).Find(&storages).Error; err != nil {
return nil, 0, errors.WithStack(err)
}
return storages, count, nil
}
// GetStorageById Get Storage by id, used to update storage usually
func GetStorageById(id uint) (*model.Storage, error) {
var storage model.Storage
storage.ID = id
if err := db.First(&storage).Error; err != nil {
return nil, errors.WithStack(err)
}
return &storage, nil
}
// GetStorageByMountPath Get Storage by mountPath, used to update storage usually
func GetStorageByMountPath(mountPath string) (*model.Storage, error) {
var storage model.Storage
if err := db.Where("mount_path = ?", mountPath).First(&storage).Error; err != nil {
return nil, errors.WithStack(err)
}
return &storage, nil
}
func GetEnabledStorages() ([]model.Storage, error) {
var storages []model.Storage
if err := db.Where(fmt.Sprintf("%s = ?", columnName("disabled")), false).Find(&storages).Error; err != nil {
return nil, errors.WithStack(err)
}
sort.Slice(storages, func(i, j int) bool {
return storages[i].Order < storages[j].Order
})
return storages, nil
}
|