trjhtr

Database utility object to control access into the database, method used in API call.

package data

import controllers.Person
import java.io.File
import java.io.InputStream
import java.sql.Connection
import java.sql.DriverManager
import java.sql.PreparedStatement

object DBUtil 
 private val USER_DIR: String = System.getProperty("user.dir")
 private val DB_URL = "jdbc:sqlite:$USER_DIR/SQL/myDB.db"
 private const val insertPerson = "INSERT INTO people(age,name,nationality) VALUES(?,?,?)"

 fun initDB() 
 val input: InputStream = File("$USER_DIR/SQL/people.sql").inputStream()
 val tableCommand: String = input.bufferedReader().use it.readText() 
 val conn = makeConnection(DB_URL)
 val statement = conn.createStatement()
 statement.execute(tableCommand)
 

 fun insertPersonToDB(person : Person) 
 val conn: Connection = makeConnection(DB_URL)
 val ps : PreparedStatement = conn.prepareStatement(insertPerson)
 ps.setInt(1, person.age)
 ps.setString(2, person.name)
 ps.setString(3, person.nationality)
 ps.executeUpdate()
 

 private fun makeConnection(url: String) : Connection 
 return DriverManager.getConnection(url)
 

And is this an acceptable way to use data classes to serialise and de-serialise json objects?

data class Person @JsonCreator constructor(
 @JsonProperty("age")
 val age: Int,
 @JsonProperty("name")
 val name: String,
 @JsonProperty("nationality")
 val nationality: String,
 @JsonProperty("pets")
 val pets: Pets
)

data class Pets @JsonCreator constructor(
 @JsonProperty("name")
 val name: String,

 @JsonProperty("breed")
 val breedId: Int
)

(whole proj- although was told not to post this https://github.com/343LovingGrace/KotlinToyAPI)