Request: Support UUID datatypes about swift-kuery HOT 4 CLOSED

I checked the databases we support, and it looks like only Postgres fully supports UUIDs. MySQL and and DB2 seem to be able to generate UUID, but don't have a type for it. And SQLite has no support at all.

It is easy to use UUID as input, because we just pass parameters as Any, but getting the result object as UUID will work only for Postgres.

Since we are trying to keep Swift-Kuery as db-independant as possible, adding UUID support seems to break the abstraction too much.

from swift-kuery.

I see your point. Perhaps a way to go about it then, on the Query-side, would be to allow a method to enter Raw data into a query with named/numbered parameters. So that one could add '58fba7e2-5528-4121-80ff-aee405706c45'::uuid as a named/numbered parameter. If this is already possible, I apologize – I could not figure it out.

On the result-side however, all changes I am suggesting would be done in the Kuery-Postgres implementation. It would help a great deal as currently, the only way to use UUID:s today in a useable way is to run .map() on the resultset.asRows, copying the entire result set and replacing the columns that are of the Data-type with corresponding NSUUID objects.

I'm hoping this would be a manageable way forward.

from swift-kuery.

Please check the above commit. It handles UUID in the result fetcher and returns its String value. I also added a test that inserts UUID.uuidString.

from swift-kuery.

From my testing this works exactly as expected. Fantastic!

Thanks!

from swift-kuery.