Load into map[string]interface{}

[bgaifullin]

Allow to use map[string]interface{} in function Load,
where key is column name, value is column value.

result := make(map[string]interface{})
count, err := s.Select("a", "b").From("table1").Where("a=1").Load(&result)
// expected result contains 2 items, a and b with appropriate column values.

[kumarsiva07]

How do i use map array to load more than one row?

[bgaifullin]

just pass []map[string]interface{} to method Load. you can check how this is implemented in https://github.com/mailru/dbr

[bgaifullin]

I close this issue, since PR was declined.

[kumarsiva07]

mtObj := make(map[string]interface{})
tx.SelectBySql("SELECT ID FROM Contacts where ID=? and NAME=? limit 1", values...).Loads(&mtObj)
fmt.Prtintln(mtObj["NAME"])

This prints Address.

[bgaifullin]

When you load values into map[string]interface{}, there is no information about type, and value will be stored as is. ([]byte)

You are responsible for converting value into required type:

for example:

// to string
string(v.([]byte))
// to int64
strconv.ParseInt(string(v.([]byte)), 10, 64)