SQLConfiguration

classin packageklyn.data.sql

public final class SQLConfiguration implements ProviderConfiguration:

SQLConfiguration

All Implemented Interfaces: ProviderConfiguration

Immutable connection and rendering configuration for the SQL KQL provider.

The connection URL is passed unchanged to DriverManager. MariaDB, PostgreSQL and SQL Server dialects are inferred from their URL when dialect is omitted. ODBC URLs require an explicit dialect because an ODBC connection string does not identify SQL semantics reliably.

configuration = SQLConfiguration(
url="mariadb://localhost:3306/klyn",
login="klyn",
password="secret"
)

Properties

Modifier and Type	Member	Description
public readonly property	dialect `dialect as SQLDialect`	SQL dialect used by KQL translation, persistence and schema management.
public readonly property	formatSQL `formatSQL as Boolean`	Whether logged SQL is expanded over readable lines.
public readonly property	login `login as String`	Database login, or an empty string when the driver uses another authentication mechanism.
public readonly property	password `password as String`	Database password passed to the selected low-level driver.
public readonly property	providerName `providerName as String:`	Stable provider family name.
public readonly property	queryTimeoutSeconds `queryTimeoutSeconds as Int`	Provider query timeout in seconds, or `0` for no explicit deadline.
public readonly property	showSQL `showSQL as Boolean`	Whether executed SQL text is written to the current console.
public readonly property	url `url as String`	Low-level database URL accepted by `DriverManager`.

Inherited Properties

propertyInherited Properties from ProviderConfiguration: providerName

Constructors

Modifier and Type	Member	Description
public	SQLConfiguration `SQLConfiguration( url as String, login as String = "", password as String = "", dialect as SQLDialect = null, showSQL as Boolean = false, formatSQL as Boolean = false, queryTimeoutSeconds as Int = 0 ):`	Creates one SQL provider configuration.

Methods

Modifier and Type	Member	Description
public	openConnection `openConnection() as Connection throws Exception:`	Opens one low-level connection owned by the caller.