[runtime] Support set map value by key about cqlc HOT 3 CLOSED

the main challenge is map requires a column name and two value, so we will have two ? in query instead of just one ...

Although AppendStringSlice has values, it used for binding as value, not in query, only col is used in query

func (c *Context) AppendStringSlice(col StringSliceColumn, values ...string) SetValueStep {
	appendList(c, col, values)
	return c
}

SetStringStringMapValue(col StringStringMapColumn, key string, value string) SetValueStep

setFragments[i] = fmt.Sprintf("%s [?] = ?", col)

from cqlc.

it seems multiple ? is already handled in binding due to WHERE fo IN (?,?,?)

func (c *Context) Prepare(s *gocql.Session) (*gocql.Query, error) {
	// The reason why this is so dynamic is because of WHERE foo IN (?,?,?) clauses
	// The factoring for an IN clause is bad, since we are storing an array into the value
	// and using reflection to dig it out again
	// This should be more strongly typed
placeHolders := make([]interface{}, 0)

	for _, cond := range c.Conditions {
		v := cond.Binding.Value

		switch reflect.TypeOf(v).Kind() {
		case reflect.Slice:
			{
				s := reflect.ValueOf(v)
				for i := 0; i < s.Len(); i++ {
					placeHolders = append(placeHolders, s.Index(i).Interface())
				}
			}
		case reflect.Array:
			{

				// Not really happy about having to special case UUIDs
				// but this works for now

				if val, ok := v.(gocql.UUID); ok {
					placeHolders = append(placeHolders, val.Bytes())
				} else {
					return nil, bindingErrorf("Cannot bind component: %+v (type: %s)", v, reflect.TypeOf(v))
				}
			}
		default:
			{
				placeHolders = append(placeHolders, &v)
			}
		}
	}
}

from cqlc.

summarize what need to be done in order to get this work (previous commit already works, need to tweak the test and clean up code)

Actually it's all just runtime ....

• in tmpl/columns.tmpl
  • in SetStepValue interface, add Set{{Type1}}{{Type2}}MapValue(col, key {{type1}}, value {{type2}}
  • in Context methods, add the impl method with same name and call setMap
• run make cqlc/columns.go to generate using column_generator.go
• add setMap and use []interface{}{key, value} as Value for binding, set type to MapType and op to SetByKey
• in renderUpdate, use %s[?] = ? where %s is from col

BuildStatement, flatten binding, (copy from Prepare), former is used by Exec (update & insert) and latter is used by Fetch (select)

• NOTE: we added new struct KeyValue to avoid flatten slice value that should be kept as slice
• in old code, they were using &v for placeholder, it's pointer to interface, I don't know why it didn't trigger error, because gocql traverse ptr until it's a value?

from cqlc.