src/main/kotlin/moe/nea/ledger/database/Database.kt


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

package moe.nea.ledger.database

import java.sql.DriverManager

object Database {
	val connection = DriverManager.getConnection("jdbc:sqlite:money-ledger/database.db")

	object MetaTable : Table("LedgerMeta") {
		val key = column("key", DBString)
		val value = column("value", DBString)

		init {
			unique(key)
		}
	}

	fun init() {
		MetaTable.createIfNotExists(connection)
		val meta = MetaTable.selectAll(connection).associate { it[MetaTable.key] to it[MetaTable.value] }
		println("Old Meta: $meta")
	}

}