How to get a JSON to be scanned into a struct correctly.

[Arttii]

Hi,

I am using the db/sql driver and trying to deserialize some part of a json column into a custom struct.

My query is something like this :

SELECT 
 ts,  
JSON_QUERY(t,'$.op_log') AS op_log, J
JSONExtractRaw(t, 'error') AS error, 
from conditions;

I am trying to deserialize the results in to an array of :

type ConditionRun struct {
	 
	 
	Ts             string            `protobuf:"bytes,2,opt,name=ts,proto3" json:"ts,omitempty"`
 
	OpLog          map[string]string `protobuf:"bytes,9,rep,name=op_log,json=opLog,proto3" json:"op_log,omitempty" protobuf_key:"bytes,1,opt,name=key,proto3" protobuf_val:"bytes,2,opt,name=value,proto3"`
	Error          string            `protobuf:"bytes,10,opt,name=error,proto3" json:"error,omitempty"`
}

the problem is: I always get a string type inferred for the op_log column and so it cannot be scanned into the struct. What is the correct way to do this?

Any suggestions would be appreciated!