// buildIndexPlan adds the insert value to the Values field for the specified ColVindex.
// This value will be used at the time of insert to validate the vindex value.
func buildIndexPlan(ins *sqlparser.Insert, colVindex *vindexes.ColVindex, route *engine.Route) error {
row, pos := findOrInsertPos(ins, colVindex.Col)
val, err := valConvert(row[pos])
if err != nil {
return fmt.Errorf("could not convert val: %s, pos: %d: %v", sqlparser.String(row[pos]), pos, err)
}
route.Values = append(route.Values.([]interface{}), val)
row[pos] = sqlparser.ValArg([]byte(":_" + colVindex.Col))
return nil
}
// getDMLRouting updates the route with the necessary routing
// info. If it cannot find a unique route, then it returns an error.
func getDMLRouting(where *sqlparser.Where, route *engine.Route) error {
if where == nil {
return errors.New("unsupported: multi-shard where clause in DML")
}
for _, index := range route.Table.Ordered {
if !vindexes.IsUnique(index.Vindex) {
continue
}
if values := getMatch(where.Expr, index.Column); values != nil {
route.Vindex = index.Vindex
route.Values = values
return nil
}
}
return errors.New("unsupported: multi-shard where clause in DML")
}