prs/prs.shared/Database Update Scripts/Update_7_21.cs

using InABox.Configuration;
using InABox.Core;
using InABox.Database;

namespace PRS.Shared;

public class Update_7_21 : DatabaseUpdateScript
{
    public override VersionNumber Version => new(7, 21);
    public override bool Update()
    {
        var filters = DbFactory.NewProvider(Logger.Main).Query<GlobalSettings>(
            new Filter<GlobalSettings>(x => x.Section).IsEqualTo("DynamicGridFilters")
            ).Rows.Select(x=>x.ToObject<GlobalSettings>()).ToArray();
        foreach (var filter in filters)
            filter.Section = typeof(CoreFilterDefinitions).EntityName().Split('.').Last();
        DbFactory.NewProvider(Logger.Main).Save(filters);
        return true;
    }
}