fix(todo): update todo.sql

glennliao · glennliao · commit 5ea8039013be · 2022-11-22T12:29:23.000+08:00
diff --git a/action/node.go b/action/node.go
@@ -246,6 +246,7 @@ func (n *Node) reqUpdate() error {
 
 func (n *Node) do(ctx context.Context, method string, i int) (ret g.Map, err error) {
 
+	// todo 此处运行会导致事务时长与hook时长相关,特别是hook中运行了io类型的操作, 故需要调整到事务外去执行, 且如果事务失败, 则不执行after, 可以改成增加error
 	for _, hook := range hooks {
 		if hook.Before != nil {
 			err := hook.Before(n, method)
diff --git a/demo/todo/app/access.go b/demo/todo/app/access.go
@@ -70,7 +70,12 @@ func AccessCondition(ctx context.Context, req config.AccessConditionReq) (g.Map,
 	switch req.Table {
 	case "t_user":
 		if req.NodeRole == consts.OWNER {
-			return g.Map{"user_id": user.UserId}, nil
+			// a=b
+			// a in []b
+			// a = (sql)
+			// a in [sql]
+			// a not in sql
+			return g.Map{"user_id": user.UserId, "@sql": []string{"a in ?", "asd"}}, nil
 		}
 	case "t_todo":
 		if req.NodeRole == consts.OWNER {
diff --git a/demo/todo/doc/todo.sql b/demo/todo/doc/todo.sql
