Add getNoteByID method to NoteDao

kahverengi · kahverengi · commit b65e21ffaf97 · 2021-04-21T13:19:53.000+03:00
diff --git a/src/main/kotlin/com/parnote/db/dao/NoteDao.kt b/src/main/kotlin/com/parnote/db/dao/NoteDao.kt
@@ -52,4 +52,10 @@ interface NoteDao : Dao<Note> {
         sqlConnection: SQLConnection,
         handler: (exists: Boolean?, asyncResult: AsyncResult<*>) -> Unit
     )
+
+    fun getNoteByID(
+        noteID: Int,
+        sqlConnection: SQLConnection,
+        handler: (note: Note?, asyncResult: AsyncResult<*>) -> Unit
+    )
 }
diff --git a/src/main/kotlin/com/parnote/db/entity/NoteDaoImpl.kt b/src/main/kotlin/com/parnote/db/entity/NoteDaoImpl.kt
@@ -184,4 +184,31 @@ class NoteDaoImpl(override val tableName: String = "note") : DaoImpl(), NoteDao
                 handler.invoke(null, queryResult)
         }
     }
+
+    override fun getNoteByID(
+        noteID: Int,
+        sqlConnection: SQLConnection,
+        handler: (note: Note?, asyncResult: AsyncResult<*>) -> Unit
+    ) {
+        val query =
+            "SELECT `id`, `user_id`, `title`, `text`, `last_modified`, `status`, `favorite` FROM `${getTablePrefix() + tableName}` WHERE `id` = ?"
+
+        sqlConnection.queryWithParams(query, JsonArray().add(noteID)) { queryResult ->
+            if (queryResult.succeeded()) {
+                val row = queryResult.result().results[0]
+                val note = Note(
+                    row.getInteger(0),
+                    row.getInteger(1),
+                    row.getString(2),
+                    row.getString(3),
+                    row.getString(4),
+                    row.getInteger(5),
+                    row.getBoolean(6)
+                )
+
+                handler.invoke(note, queryResult)
+            } else
+                handler.invoke(null, queryResult)
+        }
+    }
 }

Original file line number	Diff line number	Diff line change
`@@ -52,4 +52,10 @@ interface NoteDao : Dao<Note> {`
`52`	`52`	`sqlConnection: SQLConnection,`
`53`	`53`	`handler: (exists: Boolean?, asyncResult: AsyncResult<*>) -> Unit`
`54`	`54`	`)`
	`55`	`+`
	`56`	`+ fun getNoteByID(`
	`57`	`+ noteID: Int,`
	`58`	`+ sqlConnection: SQLConnection,`
	`59`	`+ handler: (note: Note?, asyncResult: AsyncResult<*>) -> Unit`
	`60`	`+ )`
`55`	`61`	`}`