createSimpleDb

fun createSimpleDb(tableDefinitions: Set<DbTableData>, dbName: String, dbDirectory: Path = KSL.dbDir, deleteIfExists: Boolean = true, dbType: EmbeddedDbType = EmbeddedDbType.SQLITE): Database

This constructs a database on disk. The database will contain empty tables based on the table definitions.

Return

a database

Parameters

tableDefinitions

an example set of table definitions based on DbTableData specifications

dbName

the name of the database

dbDirectory

the directory containing the database. By default, KSL.dbDir.

deleteIfExists

If true, an existing database in the supplied directory with the same name will be deleted and an empty database will be constructed.

dbType

The type of database (SQLite, Derby, DuckDb). The default is SQLite.