KSLCore/ksl.app.dist.config/DataSourceReference/Database

Database

@Serializable

data class Database(val connection: DatabaseConnectionRef, val source: DbSource, val layout: DatasetLayout = DatasetLayout.WIDE, val idColumn: String? = null, val valueColumn: String? = null, val datasetColumns: List<String>? = null) : DataSourceReference(source)

A database table or query. Numeric columns are read into datasets.

WIDE layout (the default): each numeric column becomes a dataset (filtered to datasetColumns, in order, when given).

LONG layout: rows are grouped by idColumn (first-seen order) into one dataset each, with valueColumn supplying the numeric values; both must be set.

Embedded databases (SQLite, Derby) need no credentials; server databases and credential resolution land in a later phase.

Constructors

Database

constructor(connection: DatabaseConnectionRef, source: DbSource, layout: DatasetLayout = DatasetLayout.WIDE, idColumn: String? = null, valueColumn: String? = null, datasetColumns: List<String>? = null)

Properties

connection

val connection: DatabaseConnectionRef

datasetColumns

val datasetColumns: List<String>?

idColumn

val idColumn: String?

layout

val layout: DatasetLayout

source

val source: DbSource

valueColumn

val valueColumn: String?