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
24
25
26
27
28

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] }
		val lastLaunch = meta["lastLaunch"]?.toLong() ?: 0L
		println("Last launch $lastLaunch")
		MetaTable.insert(connection, Table.OnConflict.REPLACE) {
			it[MetaTable.key] = "lastLaunch"
			it[MetaTable.value] = System.currentTimeMillis().toString()
		}
	}

}