How to store query results in maps

packs · March 14, 2024, 6:47pm

Dean_Davidson · March 14, 2024, 7:09pm

This is a pretty broad question. SQLX has a MapScan func that might be of use to you though in terms of a general approach:

github.com

jmoiron/sqlx/blob/28212d434cdd87418ecd0cb81173690ce7ac6ab6/sqlx.go#L834


      
          	return values, r.Err()
          }
          
          // MapScan scans a single Row into the dest map[string]interface{}.
          // Use this to get results for SQL that might not be under your control
          // (for instance, if you're building an interface for an SQL server that
          // executes SQL from input).  Please do not use this as a primary interface!
          // This will modify the map sent to it in place, so reuse the same map with
          // care.  Columns which occur more than once in the result will overwrite
          // each other!
          func MapScan(r ColScanner, dest map[string]interface{}) error {
          	// ignore r.started, since we needn't use reflect for anything.
          	columns, err := r.Columns()
          	if err != nil {
          		return err
          	}
          
          	values := make([]interface{}, len(columns))
          	for i := range values {
          		values[i] = new(interface{})
          	}

Long and short of it is: return a row iterator, then iterate over it and create your map. It’s unclear to me if you are trying to create a map per row or a map with all values from a single column or something else. But - that should get you started.