I am new to golang and using Jmoiron Sqlx package for querying the Postgres Database(select query) . The waY I am doing is creating a sql string and calling Select(dest interface{}, query string,args) method. While it works well , the problem is I am generating my sql String dynamically and as such the destination structure should be different for each response .
For ex : - One query can be
Select a,b,c,d from table A ;
the other can be
Select x,y,z from Table B;
From what i understand , there should be two different structs defined for Select Method to work i.e.
Struct Resp1{
a string
b string
c string
d string
}
And,
Struct Resp2{
x string
y string
z string
}
And then invoke select as db.Select(&resp1,query,args)
and db.Select(&resp2,query,args)
I am thinking if its possible for me to define a common Struct
say Resp3{
a string
b string
c string
d string
x string
y string
z string
}
And based on my select query populates only the matching columns (i.e only a,b,c,d for first and x,y,z for second) .
I tried searching but couldnt get any leads .