jasync-sql · oshai · May 27, 2025 · May 18, 2025 · May 18, 2025 · May 19, 2025
diff --git a/r2dbc-mysql/src/main/java/JasyncRow.kt b/r2dbc-mysql/src/main/java/JasyncRow.kt
@@ -30,6 +30,14 @@ class JasyncRow(private val rowData: RowData, private val metadata: JasyncMetada
        return when {
            requestedType == Object::class.java -> value
            requestedType == String::class.java -> value?.toString()
+            requestedType == java.lang.Boolean::class.java -> {
+                when (value) {
+                    is Number -> value.toInt() != 0
+                    is String -> value.toBoolean()
+                    is Boolean -> value
+                    else -> throw IllegalStateException("Cannot convert ${value?.javaClass?.simpleName} to Boolean")
+                }
+            }
            value is Number -> {
                when (requestedType) {
                    java.lang.Long::class.java -> value.toLong()
@@ -54,6 +62,12 @@ class JasyncRow(private val rowData: RowData, private val metadata: JasyncMetada
                    else -> throw IllegalStateException("unmatched requested type ${requestedType.simpleName}")
                }
            }
+            value is Boolean && requestedType.isPrimitive -> {
+                when (requestedType.name) {
+                    "boolean" -> value
+                    else -> throw IllegalStateException("Cannot convert Boolean to ${requestedType.name}")
+                }
+            }
            value is LocalDateTime -> {
                when (requestedType) {
                    LocalDate::class.java -> value.toLocalDate()

diff --git a/r2dbc-mysql/src/test/java/com/github/jasync/r2dbc/mysql/JasyncRowTest.kt b/r2dbc-mysql/src/test/java/com/github/jasync/r2dbc/mysql/JasyncRowTest.kt
@@ -0,0 +1,55 @@
+package com.github.jasync.r2dbc.mysql
+
+import com.github.jasync.sql.db.RowData
+import io.mockk.every
+import io.mockk.mockk
+import org.junit.Test
+import kotlin.test.assertFalse
+import kotlin.test.assertTrue
+
+/**
+ * Unit tests for [JasyncRow].
+ */
+internal class JasyncRowTest {
+
+    @Test
+    fun testBooleanConversion() {
+        // Mock dependencies
+        val rowData = mockk<RowData>()
+        val metadata = mockk<JasyncMetadata>()
+
+        // Setup mock values for different types of data
+        every { rowData["boolTrue"] } returns true
+        every { rowData["boolFalse"] } returns false
+        every { rowData["numZero"] } returns 0
+        every { rowData["numOne"] } returns 1
+        every { rowData["stringTrue"] } returns "true"
+        every { rowData["stringFalse"] } returns "false"
+        every { rowData[0] } returns true
+        every { rowData[1] } returns 0
+        every { rowData[2] } returns "true"
+
+        val row = JasyncRow(rowData, metadata)
+
+        // Test conversion from Boolean to Boolean
+        assertTrue(row.get("boolTrue", java.lang.Boolean::class.java) as Boolean)
+        assertFalse(row.get("boolFalse", java.lang.Boolean::class.java) as Boolean)
+
+        // Test conversion from Number to Boolean
+        assertFalse(row.get("numZero", java.lang.Boolean::class.java) as Boolean)
+        assertTrue(row.get("numOne", java.lang.Boolean::class.java) as Boolean)
+
+        // Test conversion from String to Boolean
+        assertTrue(row.get("stringTrue", java.lang.Boolean::class.java) as Boolean)
+        assertFalse(row.get("stringFalse", java.lang.Boolean::class.java) as Boolean)
+
+        // Test conversion from various types using index
+        assertTrue(row.get(0, java.lang.Boolean::class.java) as Boolean)
+        assertFalse(row.get(1, java.lang.Boolean::class.java) as Boolean)
+        assertTrue(row.get(2, java.lang.Boolean::class.java) as Boolean)
+
+        // Test conversion to primitive boolean - using Boolean class in Kotlin
+        assertTrue(row.get("boolTrue", java.lang.Boolean::class.java) as Boolean)
+        assertFalse(row.get("boolFalse", java.lang.Boolean::class.java) as Boolean)
+    }
+}