From 34981c30a78e8bbd7791131059a9210f9928b62c Mon Sep 17 00:00:00 2001
From: 刘光辉 <347230014@qq.com>
Date: 星期四, 17 九月 2026 09:24:09 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master' into master

---
 jnpf-dms/jnpf-dms-biz/src/test/resources/sql/dms_file_objects_test.sql |   49 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 49 insertions(+), 0 deletions(-)

diff --git a/jnpf-dms/jnpf-dms-biz/src/test/resources/sql/dms_file_objects_test.sql b/jnpf-dms/jnpf-dms-biz/src/test/resources/sql/dms_file_objects_test.sql
new file mode 100644
index 0000000..08757fd
--- /dev/null
+++ b/jnpf-dms/jnpf-dms-biz/src/test/resources/sql/dms_file_objects_test.sql
@@ -0,0 +1,49 @@
+\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;

--
Gitblit v1.8.0