ores.refdata.business_unit

uuid_gen()

faker::company::companyName() + " Desk"

std::nullopt

std::string("DESK") + std::to_string(idx)

// WRLD is the only business centre guaranteed seeded by the base
// bootstrap (a real FpML city code like GBLO only exists once the
// large, optional FpML business-centre reference dataset is loaded --
// see the same reasoning in ores.refdata.party.org).
std::string("WRLD")

std::nullopt

std::string("Active")

-- Level constraint: when both parent and child have a type, child level > parent level
if NEW.unit_type_id is not null and NEW.parent_business_unit_id is not null then
    declare
        v_parent_type_id uuid;
        v_parent_level integer;
        v_child_level integer;
    begin
        select unit_type_id into v_parent_type_id
        from ores_refdata_business_units_tbl
        where tenant_id = NEW.tenant_id
          and id = NEW.parent_business_unit_id
          and valid_to = ores_utility_infinity_timestamp_fn();

        if v_parent_type_id is not null then
            select level into v_parent_level
            from ores_refdata_business_unit_types_tbl
            where tenant_id = NEW.tenant_id
              and id = v_parent_type_id
              and valid_to = ores_utility_infinity_timestamp_fn();

            select level into v_child_level
            from ores_refdata_business_unit_types_tbl
            where tenant_id = NEW.tenant_id
              and id = NEW.unit_type_id
              and valid_to = ores_utility_infinity_timestamp_fn();

            if v_child_level <= v_parent_level then
                raise exception
                    'Business unit type level % cannot be contained by a unit of the same or higher level %. Parent level must be strictly less than child level.',
                    v_child_level, v_parent_level
                    using errcode = '23514';
            end if;
        end if;
    end;
end if;

#include <chrono>
#include <optional>
#include <string>
#include <boost/uuid/uuid.hpp>

#include <string>
#include "sqlgen/Timestamp.hpp"
#include "sqlgen/PrimaryKey.hpp"