slatekit / kiit

Kotlin Framework for Apps, APIs, CLIs, Jobs, Mobile and more...
https://www.kiit.dev
Apache License 2.0
112 stars 13 forks source link

BUGS: Data: Sqlite issues #312

Closed kishorereddy closed 3 years ago

kishorereddy commented 3 years ago

Overview

Misc bugs for Sqlite support

Details

Listing all bugs here ( as they are mostly Sqlite related )

Issues

  1. LocalDateEncoder : Does not handle decoding Int for Sqlite
  2. LocalTimeEncoder : Does not handle decoding Int for Sqlite
  3. LocalDateTimeEncoder : Encoding/Decoding needs to stores in epochMilli not epochSecond
  4. DateTimeEncoder : Encoding/Decoding needs to stores in epochMilli not epochSecond
  5. ZonedDateTimeEncoder : Encoding/Decoding needs to stores in epochMilli not epochSecond
  6. EntityEncoder: Lookup of field values uses inst.kClass.declaredMemberProperties which does not get inherited members, needs to use inst.kClass.memberProperties in the Reflector.getValue
  7. EntityDecoder: createEntity method uses cls.primaryConstructor, but doesn't always work, better to use this in combination with cls.constructors.firstOrNull.
  8. SqlRepo: Build mode is not set to BuildMode type. Change to be buildMode:BuildMode = BuildMode.Prep
  9. Patch : Sql builder is changing column name to be lowercase causing issue to look up dataType
  10. EntityDecoder : decodeVarType and getDataValue are not open

System

  1. For Sqlite based data mappers/provider

Screenshots

n/a

Desktop

n/a

Smartphone

n/a

Additional

n/a