1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
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;
|
|
