ores.refdata.party_contact_information

uuid_gen()

// no_generator_suffix: validated enum, a "-<idx>" suffix would be invalid.
// Rotate so a batch of several contact rows for one party gets distinct
// types (max one contact row per type per party).
[idx]{
    static constexpr const char* types[] = {
        "Legal", "Operations", "Settlement", "Billing"};
    return std::string(types[idx % 4]);
}()

std::string("123 Test Street")

std::string("Suite 100")

std::string("London")

std::string("")

// Left blank: validated against the tenant-scoped countries table, which
// isolated test tenants don't seed; empty skips validation.
std::string("")

-- Paste block: doesn't fit soft_fk_validations (joins on id, not
-- an alpha-2 code column) or the Validations table
-- (ores_refdata_validate_country_fn only checks non-null/empty,
-- not existence).
-- Validate country_code (nullable, inline check against countries table)
if NEW.country_code is not null and NEW.country_code != '' then
    if not exists (
        select 1 from ores_refdata_countries_tbl
        where tenant_id = NEW.tenant_id
          and alpha2_code = NEW.country_code
          and valid_to = ores_utility_infinity_timestamp_fn()
    ) then
        raise exception 'Invalid country_code: %. Must be a valid ISO 3166-1 alpha-2 code.',
            NEW.country_code
            using errcode = '23503';
    end if;
end if;

std::string("EC2V 8AS")

std::string("+44 20 7000 0000")

std::string("contact@example.com")

std::string("https://example.com")

// The first row a batch generates is the primary one, and four contact types
// rotate per party, so at most one of a party's rows is marked.
[idx]{
    return idx % 4 == 0;
}()

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

#include <string>