本文整理匯總了Golang中github.com/youtube/vitess/go/vt/vtgate/proto.Query.BindVariables方法的典型用法代碼示例。如果您正苦於以下問題：Golang Query.BindVariables方法的具體用法？Golang Query.BindVariables怎麽用？Golang Query.BindVariables使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類github.com/youtube/vitess/go/vt/vtgate/proto.Query的用法示例。
在下文中一共展示了Query.BindVariables方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Golang代碼示例。
示例1: Execute
// Execute routes a non-streaming query.
func (rtr *Router) Execute(ctx context.Context, query *proto.Query) (*mproto.QueryResult, error) {
if query.BindVariables == nil {
query.BindVariables = make(map[string]interface{})
}
vcursor := newRequestContext(ctx, query, rtr)
plan := rtr.planner.GetPlan(string(query.Sql))
switch plan.ID {
case planbuilder.UpdateEqual:
return rtr.execUpdateEqual(vcursor, plan)
case planbuilder.DeleteEqual:
return rtr.execDeleteEqual(vcursor, plan)
case planbuilder.InsertSharded:
return rtr.execInsertSharded(vcursor, plan)
}
var err error
var params *scatterParams
switch plan.ID {
case planbuilder.SelectUnsharded, planbuilder.UpdateUnsharded,
planbuilder.DeleteUnsharded, planbuilder.InsertUnsharded:
params, err = rtr.paramsUnsharded(vcursor, plan)
case planbuilder.SelectEqual:
params, err = rtr.paramsSelectEqual(vcursor, plan)
case planbuilder.SelectIN:
params, err = rtr.paramsSelectIN(vcursor, plan)
case planbuilder.SelectKeyrange:
params, err = rtr.paramsSelectKeyrange(vcursor, plan)
case planbuilder.SelectScatter:
params, err = rtr.paramsSelectScatter(vcursor, plan)
default:
return nil, fmt.Errorf("cannot route query: %s: %s", query.Sql, plan.Reason)
}
if err != nil {
return nil, err
}
return rtr.scatterConn.ExecuteMulti(
ctx,
params.query,
params.ks,
params.shardVars,
query.TabletType,
NewSafeSession(vcursor.query.Session),
query.NotInTransaction,
)
}示例2: StreamExecute
// StreamExecute executes a streaming query.
func (rtr *Router) StreamExecute(ctx context.Context, query *proto.Query, sendReply func(*mproto.QueryResult) error) error {
if query.BindVariables == nil {
query.BindVariables = make(map[string]interface{})
}
vcursor := newRequestContext(ctx, query, rtr)
plan := rtr.planner.GetPlan(string(query.Sql))
var err error
var params *scatterParams
switch plan.ID {
case planbuilder.SelectUnsharded:
params, err = rtr.paramsUnsharded(vcursor, plan)
case planbuilder.SelectEqual:
params, err = rtr.paramsSelectEqual(vcursor, plan)
case planbuilder.SelectIN:
params, err = rtr.paramsSelectIN(vcursor, plan)
case planbuilder.SelectKeyrange:
params, err = rtr.paramsSelectKeyrange(vcursor, plan)
case planbuilder.SelectScatter:
params, err = rtr.paramsSelectScatter(vcursor, plan)
default:
return fmt.Errorf("query %q cannot be used for streaming", query.Sql)
}
if err != nil {
return err
}
return rtr.scatterConn.StreamExecuteMulti(
ctx,
params.query,
params.ks,
params.shardVars,
query.TabletType,
NewSafeSession(vcursor.query.Session),
sendReply,
query.NotInTransaction,
)
}