GeezerVison

Description

This PR adds support for boolean type conversion in the JasyncRow class. Previously, the class supported conversions for various data types but did not explicitly handle boolean values. With these changes, the class can now properly convert various input data types (Numbers, Strings, Booleans) to Boolean values.

This enhancement is particularly important for MySQL databases, which represent boolean values as TINYINT(1) where 0 means false and any non-zero value (typically 1) means true. Our implementation correctly handles this MySQL-specific behavior by treating any non-zero numeric value as true.

Changes Made

• Extended the get method in JasyncRow to handle boolean conversions with the following mapping:
  • Numbers: 0 → false, non-zero → true (aligned with MySQL's TINYINT(1) representation of booleans)
  • Strings: Using Kotlin's built-in Boolean parsing
  • Boolean values: Preserved as-is
  • Added proper handling for primitive boolean type
• Added comprehensive test cases in JasyncRowTest to validate all conversion scenarios

Testing

• Created a dedicated test class JasyncRowTest with a test method testBooleanConversion that verifies:
  • Boolean to Boolean conversion
  • Number to Boolean conversion (0 → false, non-zero → true)
  • String to Boolean conversion ("true" → true, "false" → false)
  • Accessing Boolean values by index
  • Tests pass successfully, confirming the implementation works as expected

Related Issue

#430

Additional Notes

This change enables more flexible type handling in the database access layer, making it easier to work with boolean values returned from MySQL queries. Since MySQL stores boolean values as TINYINT(1), this implementation ensures a seamless conversion between the database representation and the application-level Boolean type, improving type safety and code readability.