Package-level declarations

import androidx.sqlite.SQLiteConnection
import androidx.sqlite.driver.bundled.SQLITE_OPEN_READONLY
import com.kqlite.database.KQLiteDatabase
import com.kqlite.database.KQLiteDriver
import com.kqlite.demo.contacts.model.ContactType
import com.kqlite.demo.contacts.platform.getDatabaseAbsolutePath
import com.kqlite.functions.DATE
import com.kqlite.functions.JSON_ARRAY
import com.kqlite.migration.KQLiteMigration
import com.kqlite.pragma.JournalMode
import com.kqlite.pragma.KQLitePragma
import com.kqlite.statement.quickInsert
import com.kqlite.table.KQLiteTable

class ContactsDatabase(
  kqLiteDriver: KQLiteDriver = ContactsDatabaseDriver(getDatabaseAbsolutePath(NAME))
) : KQLiteDatabase(kqLiteDriver = kqLiteDriver) {

  companion object {
    const val NAME = "contacts.db"
    const val VERSION = 2
  }

  override fun getKQLiteTables(): List<KQLiteTable> {
    return listOf(TblContact)
  }

  override fun onConfigure(pragma: KQLitePragma) {
    super.onConfigure(pragma)
    pragma.foreignKeys.set(true)
    pragma.journalMode.set(JournalMode.WAL)
  }

  override fun getKQLiteMigrations(): List<KQLiteMigration> {
    return listOf(Migration12())
  }

  fun openReadWrite() = this.open(null)

  fun openReadOnly() = this.open(SQLITE_OPEN_READONLY)

  override fun onCreate(connection: SQLiteConnection) {
    super.onCreate(connection)
    println("Database created.")
    TblContact.quickInsert {
      it.firstName.bind("John")
      it.lastName.bind("Doe")
      it.phone.bind(JSON_ARRAY("1234567890"))
      it.type.bind(ContactType.Family)
      it.birthDate.bind(DATE("2000-01-01"))
    }
  }

  override fun onOpen(connection: SQLiteConnection) {
    super.open()
    println("Database opened.")
  }

  override fun close() {
    super.close()
    println("Database closed.")
  }
}