create Simple Db
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
table Definitions
an example set of table definitions based on DbTableData specifications
db Name
the name of the database
db Directory
the directory containing the database. By default, KSL.dbDir.
delete If Exists
If true, an existing database in the supplied directory with the same name will be deleted and an empty database will be constructed.
db Type
The type of database (SQLite, Derby, DuckDb). The default is SQLite.