workflowmetadatatable.php

<?php
 
namespace Bitrix\Bizproc\Workflow\Entity;
 
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\StringField;
use Bitrix\Main\ORM\Fields\Validators\LengthValidator;
use Bitrix\Main\ORM\Fields\Validators\RangeValidator;
 
class WorkflowMetadataTable extends DataManager
{
    public static function getTableName(): string
    {
        return 'b_bp_workflow_meta';
    }
 
    public static function getMap(): array
    {
        return [
            (new IntegerField('ID'))
                ->configureAutocomplete()
                ->configurePrimary()
            ,
            (new StringField('WORKFLOW_ID'))
                ->configureRequired()
                ->configureSize(32)
                ->addValidator(new LengthValidator(1, 32))
            ,
            (new IntegerField('START_DURATION'))
                ->addValidator(new RangeValidator())
            ,
        ];
    }
 
    public static function deleteByWorkflowId(string $workflowId): void
    {
        $iterator = static::query()->setFilter(['WORKFLOW_ID' => $workflowId])->exec();
 
        while ($metadata = $iterator->fetchObject())
        {
            $metadata->delete();
        }
    }
}