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

using Comal.Classes;
using Comal.Stores;
using InABox.Core;
using InABox.Database;

namespace PRS.Shared.Database_Update_Scripts;

internal class Update_7_56 : DatabaseUpdateScript
{
    public override VersionNumber Version => new(7, 56);

    public override bool Update()
    {
        var ids = DbFactory.Provider.Query<StockMovement>().Rows
            .Select(r => r.Get<StockMovement, Guid>(x => x.ID)).ToArray();
        int i = 0;
        foreach (var id in ids)
        {
            StockHoldingStore.UpdateStockHolding(id, StockHoldingStore.Action.Increase);
            i++;
            if (i % 100 == 0)
                Logger.Send(LogType.Information, "", $"Converted {i}/{ids.Length} Stock Holdings");
        }
        if (i % 100 != 0)
            Logger.Send(LogType.Information, "", $"Converted {ids.Length}/{ids.Length} Stock Holdings");
        return true;
    }
}