Package org.tailormap.api.geotools.featuresources

Class AttachmentsHelper

java.lang.Object

org.tailormap.api.geotools.featuresources.AttachmentsHelper

public final class AttachmentsHelper
extends Object

Helper class for managing the <FT>_attachments sidecar tables in JDBC DataStores.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static final record	AttachmentsHelper.AttachmentWithBinary

Method Summary

Modifier and Type	Method	Description
static void	createAttachmentTableForFeatureType(TMFeatureType featureType)	Create attachment table and index for the given FeatureType.
static void	deleteAttachment(UUID attachmentId, TMFeatureType featureType)
static void	dropAttachmentTableForFeatureType(TMFeatureType featureType)
static String	fidFromPK(@NotNull TMFeatureType featureType, @NotNull Object featurePK)	Constructs a Feature ID (FID) string from a feature type and primary key value.
static AttachmentsHelper.AttachmentWithBinary	getAttachment(TMFeatureType featureType, UUID attachmentId)
static AttachmentMetadata	insertAttachment(TMFeatureType featureType, AttachmentMetadata attachment, Object primaryKey, byte[] fileData)
static List<AttachmentMetadata>	listAttachmentsForFeature(TMFeatureType featureType, Object primaryKey)
static Map<String,List<AttachmentMetadata>>	listAttachmentsForFeaturesByFeatureId(TMFeatureType featureType, List<Object> featurePKs)	List attachments for multiple features grouped by their FIDs.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

createAttachmentTableForFeatureType

public static void createAttachmentTableForFeatureType(TMFeatureType featureType)
                                                throws IOException,
SQLException,
IllegalArgumentException

Create attachment table and index for the given FeatureType. This will validate that any AttachmentAttribute has a valid name.

Parameters:

featureType - the FeatureType to create the attachment table for

Throws:

IOException - when creating the GeoTools datastore fails

SQLException - when executing the SQL statements fails

IllegalArgumentException - when the FeatureType is invalid

dropAttachmentTableForFeatureType

public static void dropAttachmentTableForFeatureType(TMFeatureType featureType)
                                              throws IOException,
SQLException

Throws:

IOException

SQLException

insertAttachment

public static AttachmentMetadata insertAttachment(TMFeatureType featureType,
 AttachmentMetadata attachment,
 Object primaryKey,
 byte[] fileData)
                                           throws IOException,
SQLException

Throws:

IOException

SQLException

deleteAttachment

public static void deleteAttachment(UUID attachmentId,
 TMFeatureType featureType)
                             throws IOException,
SQLException

Throws:

IOException

SQLException

listAttachmentsForFeature

public static List<AttachmentMetadata> listAttachmentsForFeature(TMFeatureType featureType,
 Object primaryKey)
                                                          throws IOException,
SQLException

Throws:

IOException

SQLException

getAttachment

public static AttachmentsHelper.AttachmentWithBinary getAttachment(TMFeatureType featureType,
 UUID attachmentId)
                                                            throws IOException,
SQLException

Throws:

IOException

SQLException

listAttachmentsForFeaturesByFeatureId

@NonNull
public static Map<String,List<AttachmentMetadata>> listAttachmentsForFeaturesByFeatureId(TMFeatureType featureType,
 List<Object> featurePKs)
                                                                                  throws IOException

List attachments for multiple features grouped by their FIDs.
NOTE: the featurePKs list should contain objects that can be used as primary keys.

Parameters:

featureType - the feature type

featurePKs - the feature primary keys

Returns:

map of feature ID to list of attachments

Throws:

IOException - when an IO error occurs connecting to the database

fidFromPK

public static String fidFromPK(@NotNull
 @NotNull TMFeatureType featureType,
 @NotNull
 @NotNull Object featurePK)

Constructs a Feature ID (FID) string from a feature type and primary key value. The FID format is "{featureTypeName}.{primaryKey}". For byte[] primary keys, the bytes are converted to UUID format.

Parameters:

featureType - the feature type

featurePK - the feature primary key (supports String, Number, UUID, byte[], etc.)

Returns:

the constructed FID as a String