src/main/kotlin/DB.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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

package space.anity

import org.jetbrains.exposed.sql.*
import org.jetbrains.exposed.sql.transactions.*
import java.sql.*


class DB(val dbFileLocation: String = "main.db") {
    val db :Database

    /**
     * Database table for the file location indexing
     */
    object FileLocation : Table() {
        val id = integer("id").autoIncrement().primaryKey()
        val location = text("location")
    }

    /**
     * Database table to index the users with their regarding passwords
     */
    object UserData : Table() {
        // only for multiple users:
        // val id = integer("id").autoIncrement().primaryKey()
        val username = varchar("username", 24).primaryKey()  // remove .primaryKey(), if id column is used
        val password = varchar("password", 64)
    }

    /**
     * Database table storing general data/states
     */
    object General : Table() {
        val initialUse = integer("initialUse").default(0).primaryKey() // boolean -> 0:1
    }

    init {
        // create connection
        this.db = Database.connect("jdbc:sqlite:main.db", "org.sqlite.JDBC")
        TransactionManager.manager.defaultIsolationLevel = Connection.TRANSACTION_SERIALIZABLE

        // add tables
        transaction {
            SchemaUtils.createMissingTablesAndColumns(FileLocation, UserData, General)
        }
    }

    // TODO add functions for database usage
}