Function jsonColumnExample

examples/session-mysql/main.go:120–168

jsonColumnExample 演示 JSON 列的优势

(ctx context.Context, service *mysql.Service, sessionID string)

// jsonColumnExample 演示 JSON 列的优势
func jsonColumnExample(ctx context.Context, service *mysql.Service, sessionID string) {
	// MySQL 8.0+ 的 JSON 列优势:
	// 1. 原生 JSON 类型（不是字符串）
	// 2. 自动验证 JSON 格式
	// 3. 支持 JSON 函数查询
	// 4. 可以为 JSON 字段创建虚拟列索引

	event := &session.Event{
		ID:           "evt-" + generateID(),
		Timestamp:    time.Now(),
		InvocationID: "inv-mysql-002",
		AgentID:      "agent-mysql-support",
		Branch:       "root",
		Author:       "assistant",
		Content: types.Message{
			Role:    types.RoleAssistant,
			Content: "MySQL 支持丰富的 JSON 操作",
			ToolCalls: []types.ToolCall{
				{
					ID:   "call-1",
					Name: "json_demo",
					Arguments: map[string]any{
						"nested": map[string]any{
							"level1": map[string]any{
								"level2": "深层嵌套也可以",
							},
						},
						"array": []string{"item1", "item2", "item3"},
					},
				},
			},
		},
		Metadata: map[string]any{
			"mysql_features": []string{
				"JSON_EXTRACT",
				"JSON_CONTAINS",
				"JSON_SEARCH",
				"Virtual Columns",
			},
		},
	}

	if err := service.AppendEvent(ctx, sessionID, event); err != nil {
		log.Fatalf("Failed to append JSON example event: %v", err)
	}

	fmt.Println("✅ Complex JSON structure stored")
	fmt.Println("   MySQL can query nested fields efficiently")
}

// queryOptimizationExample 查询优化示例
func queryOptimizationExample(ctx context.Context, service *mysql.Service, userID string) {