PgComposite
Marks a data class as a data type that can be mapped to a composite type in PostgreSQL database.
This annotation is crucial for TypeRegistry, which scans the classpath for marked classes to automatically build mapping between Kotlin classes and PostgreSQL composite types.
Naming convention: By default, the type name in PostgreSQL is derived from the simple class name by converting from CamelCase to snake_case (e.g., ProvinceRecord class will be mapped to province_record type).
Explicit name specification: You can override the default name by providing it in the name parameter. This is useful when the type name in the database doesn't match the convention.
Non-reflective mapping: By default, Octavius uses reflection to map data class properties to composite attributes. You can provide a custom PgCompositeMapper via the mapper parameter to bypass reflection, which can significantly improve performance for high-volume operations.
Examples
// Example 1: Using default naming convention and reflection
// `LegionPost` class will be mapped to `legion_post` composite type in PostgreSQL.
@PgComposite
data class LegionPost(val name: String, val province: String)
// Example 2: Explicit type name and custom mapper
@PgComposite(name = "battle_record", mapper = BattleRecordMapper::class)
data class BattleRecord(val location: String, val outcome: String)
object BattleRecordMapper : PgCompositeMapper<BattleRecord> {
override fun toDataObject(map: Map<String, Any?>) = BattleRecord(
location = map["location"] as String,
outcome = map["outcome"] as String
)
override fun toDataMap(obj: BattleRecord) = mapOf(
"location" to obj.location,
"outcome" to obj.outcome
)
}Parameters
Optional, explicit name of the corresponding type in PostgreSQL database. If left empty, the name will be generated automatically according to the CamelCase ->snake_case convention.
Optional, explicit schema name. If left empty, the type will be resolved based on the database search_path, or by searching for an unambiguous match in all scanned schemas.
Optional, custom mapper implementation to use instead of reflection. Must implement PgCompositeMapper.