\set ON_ERROR_STOP on

BEGIN;

INSERT INTO public.dms_file_objects (
    id, tenant_id, file_version_id, storage_platform, bucket_name,
    base_path, object_path, object_name, source_service_id, source_id, created_by
)
VALUES (
    '018f0000-0000-7000-8000-000000000201',
    'dms-v22-test',
    '018f0000-0000-7000-8000-000000000004',
    'seaweedfs-1',
    'jnpf-dms',
    'dms/',
    'dms-v22-test/2026/08/17/',
    '018f0000-0000-7000-8000-000000000004.pdf',
    'jnpf-file',
    'upload-test-1',
    'dms-test'
);

DO $dms_file_objects_test$
BEGIN
    BEGIN
        INSERT INTO public.dms_file_objects (
            id, tenant_id, file_version_id, storage_platform, bucket_name,
            base_path, object_path, object_name, source_service_id, source_id, created_by
        ) VALUES (
            '018f0000-0000-7000-8000-000000000202',
            'dms-v22-test',
            '018f0000-0000-7000-8000-000000000099',
            'seaweedfs-1',
            'jnpf-dms',
            'dms/',
            'dms-v22-test/2026/08/17/',
            'missing.pdf',
            'jnpf-file',
            'upload-test-missing-version',
            'dms-test'
        );
        RAISE EXCEPTION 'file object without a file version was accepted';
    EXCEPTION
        WHEN foreign_key_violation THEN NULL;
    END;
END;
$dms_file_objects_test$;

ROLLBACK;