LeftJoins on pointer structs doesn't fill data

[samonzeweb]

LeftJoins on pointer structs doesn't fill data

[samonzeweb]

Hi Erkan,

Sorry for the delay, but I was contaminated. I hope you're fine.

Godb is not designed to work this way, because it does not allocate nested structures, only the root one if needed (it depends on the target, slice of object, or slice of pointers to objects). This kind of job is closer to what will do a more featured tools like an ORM.

The way to cope with this is using only SQL.NullXXXX for fields on the optional part of the DB response.

I have to admit that it could be a problem with JSON serialisation. But using the same structure for both DB access and HTTP response is not a good practice for real products (expect simple ones).

Changing the way it works will not be a trivial thing.

Sam.

[derkan]

Thank you for response and I wish you get well soon.
About me, I'm fine thanks, we're locked in.
You are right about using same structure for DB and HTTP response but otherwise code gets lots of overhead. I'll check a way around. Closing this issue for now.