14_yml语法-数组（List、Set）的写法

最新推荐文章于 2024-05-14 21:42:22 发布
原创 最新推荐文章于 2024-05-14 21:42:22 发布 · 5.2k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#yml

本文介绍了一种在YAML文件中简化数组元素表示的方法，使用杠加空格的行内写法，使得配置文件更加简洁易读。例如，通过这种写法可以快速定义如pets: [cat,dog,pig]这样的数组。

用- 值表示数组中的一个元素（杠+空格）

             

 

行内写法

       pets: [cat,dog,pig]

 

JavaWeb笔记整理03——yml配置文件
hello77的blogggg 祝你得偿所愿
08-06 713
如果你需要一个简单、直观、易于编辑的配置文件，YML是个不错的选择。
SpringBoot2.x学习（一）：yml 语法学习
liyananBest的博客
12-16 451
文章目录yml 配置文件yml 语法yml 常见写法字面量对象和 Map数组（List, Set）SpringBoot 使用 application.yml 实战创建两个 javaBean使用 application.yml 注入值 yml 配置文件 yml 语法 key: value 在 yml 语法中表示一组键值对。冒号后面必须有空格。 yml 中的键值区分大小写。 保证同一级别的配置左边对齐...
springboot yml文件中的数组书写形式
jfqqqqq的博客
06-29 6541
不老用就容易忘，记录下来。 类型一：对象数组 假设有一个对象user，有name和age两个属性。 方式一： users: user[0]: name: roger age: 18 user[1]: name: tom age: 17 方式二： users: user: - name: roger age: 18 - name: tom age: 17 类型二：基本变量数组 方式一： names: r
yml书写格式
weixin_64035133的博客
02-28 596
注：数据前加空格与冒号。
yml文件里的数组使用 @Value || @ConfigurationProperties
Genmer的博客
06-15 1万+
文章目录前言一、 yml数组形式二、配置类取对象三、SpEL四、参考材料 前言 最近有个功能突然有个需求，需要在yml配置文件里配置多条路径，需要动态获取配置文件里的参数，根据接口接收的参数判断，使用对应的配置 就了解到yml数组，遂记录 一、 yml数组形式 upload-record-paths: basepath: filerecord list: - name: 111 path: 111 - name: 222 path: 222 其中对象对应Ja
java使用yml配置文件注入，set方法注入配置
weixin_67631325的博客
05-14 806
该方式使用@ConfigurationProperties(prefix = "")的形式注入，可在nacos配置中心中配置自动实现热更新；若在不改动yml文件中配置的前提下，想要不采用list命名以上成员变量，可用另外的一种@Value("${moder.roster.list}")的形式注入，但要注意在类上要使用@RefreshScope注解才可以实现nacos热更新机制，不过这种方式日常开发中不推荐。
yml语法
weixin_57176230的博客
05-22 2930
Spring Boot 提供了大量的自动配置，极大地简化了spring 应用的开发过 程，当用户创建了一个 Spring Boot 项目后，即使不进行任何配置，该项 目也能顺利的运行起来。当然，用户也可以根据自身的需要使用配置文件 修改 Spring Boot 的默认设置。 SpringBoot 默认使用以下 2 种全局的配置文件，其文件名是固定的。 application.properties application.yml 其中，application.yml 是一种使用 YAML 语言编写的文件，它与
UPDATE tbl_micro ### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID' at line 1 ### The error may exist in com/huawei/it/gaia/apigc/infrastructure/mapper/IInvokeRelationMapper.xml ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID = '' WHERE INVOKER_MICRO_SERVICE_NAME = ? AND INVOKER_MICRO_SERVICE_ID = ? ; UPDATE tbl_micro_app_rel SET PROVIDER_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE PROVIDER_MICRO_SERVICE_NAME = ? AND PROVIDER_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET C_MICRO_SERVICE_ID = '' WHERE C_MICRO_SERVICE_NAME = ? AND C_MICRO_SERVICE_ID = ? ; UPDATE tbl_gaiamonitor_day_invoke SET P_MICRO_SERVICE_ID = '', ASSET_ID = '' WHERE P_MICRO_SERVICE_NAME = ? AND P_MICRO_SERVICE_ID = ?; ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; UPDATE tbl_micro_app_rel SET INVOKER_MICRO_SERVICE_ID' at line 1 ; bad SQL grammar [解释下为什么报错
11-18
但是，在原来的写法中，我们使用了separator=";"，这会在每个循环项之间添加分号，导致在第一个循环项结束后出现分号，然后紧接着是第二个循环项（即UPDATE语句），这样就会产生语法错误。 因此，我们可以尝试...
--- - hosts: all remote_user: root gather_facts: no tasks: - name: Get file list based on distid # shell: | # {% if dist_id == 1 %} # grep -oP 'neice\K\d+' /home/update/path.txt # {% else %} # cat /home/update/path.txt | awk -F "_" '{print $NF}' # {% endif %} shell: ls -1 /data1/apex | grep '^svr[0-9]\+$' | sed 's/^svr//' register: file_list - debug: var=file_list.stdout_lines - name: register timestamp shell: echo "{{date}}" register: timestamp - name: check dir shell: apex_path=/home/apex ; test -d /data1/apex ; [ $? -eq 0 ] && apex_path=/data1/apex ; echo $apex_path register: apex_path - name: check apex log shell: "ls {{ apex_path.stdout_lines.0 }}/*/ax_itemsvr/hook_log/*{{ timestamp.stdout_lines.0 }}*" register: returnmsg ignore_errors: true - name: echo have apexlog result shell: echo "have" > check_apexlog.txt delegate_to: localhost when: returnmsg.rc == 0 - debug: var=returnmsg.rc - name: check check_apexlog.txt shell: "cat check_apexlog.txt" register: check_result ignore_errors: true delegate_to: localhost - name: check apex log debug: msg: "{{date}} apexlog does not exist !!!" when: check_result.stdout_lines.0 == "none" - name: when apex log does not exist,stop shell: "ls {{ apex_path.stdout_lines.0 }}/*/ax_itemsvr/hook_log/*{{ timestamp.stdout_lines.0 }}*" when: check_result.stdout_lines.0 == "none" - name: copy compression_or_not.txt copy: dest=/tmp/compression_or_not.txt src=compression_or_not.txt - name: echo have apexlog result shell: echo "have" > /tmp/compression_or_not.txt when: returnmsg.rc == 0 - name: check check_apexlog.txt shell: "cat /tmp/compression_or_not.txt" register: compression_or_not ignore_errors: true - debug: var=compression_or_not.stdout_lines.0 - debug: var=timestamp.stdout_lines.0 - name: create dir shell: 'mkdir -p log/{{ timestamp.stdout_lines.0 }}_apexlog_{{ dist_id }}/svr{{ item }}' delegate_to: localhost with_items: - "{{ file_list.stdout_lines }}" - name: compress destination log file shell: cd {{ apex_path.stdout_lines.0 }}/svr{{ item }}/ax_itemsvr/hook_log/ && zip -r apex2log{{ timestamp.stdout_lines.0 }}.zip apex2log{{ timestamp.stdout_lines.0 }}.txt ignore_errors: true with_items: - "{{ file_list.stdout_lines }}" when: compression_or_not.stdout_lines.0 == "have" - name: fetch log fetch: src={{ apex_path.stdout_lines.0 }}/svr{{ item }}/ax_itemsvr/hook_log/apex2log{{ timestamp.stdout_lines.0 }}.zip dest=log/{{ timestamp.stdout_lines.0 }}_apexlog_{{ dist_id }}/svr{{ item }}/ flat=yes ignore_errors: true with_items: - "{{ file_list.stdout_lines }}" when: compression_or_not.stdout_lines.0 == "have" - name: uncompress tgz log file shell: 'cd log/{{ timestamp.stdout_lines.0 }}_apexlog_{{ dist_id }}/svr{{item}} && unzip -o apex2log{{ timestamp.stdout_lines.0 }}.zip && rm -f *.zip' delegate_to: localhost ignore_errors: true with_items: - "{{ file_list.stdout_lines }}" when: compression_or_not.stdout_lines.0 == "have" - name: delete remote tgz package shell: cd {{ apex_path.stdout_lines.0 }}/svr{{ item }}/ax_itemsvr/hook_log/ && rm -f apex2log{{ timestamp.stdout_lines.0 }}.zip with_items: - "{{ file_list.stdout_lines }}" --------------- 1. 增加一个字符串参数A: 传账号或进程名（可能为中文，并可能包含/或\等符号） 不传A: 原逻辑中同时取多个区组时产生多个压缩文件调整为多个区组压缩到一个压缩文件中，按区组目录，同时分线路。 传A: 当传入账号或进程名(可能是中文)时，过滤之后，将结果直接输入到一个文件中，文件命名可以是: {distid}.log,多个区组，产生多个{distid}.log，再将多个文件压缩成一个压缩包。压缩包名称可以固定一个，如{date}_apexlog_multi.tgz
最新发布
11-26
# 这里注意：如果A包含空格或特殊符号，上面的写法在双引号内是安全的。 loop: "{{ groups }}" loop_control: loop_var: item # 任务2: 创建一个目录，将log文件收集起来 - name: 创建临时目录用于收集log...
yml详解以及java对yml的使用
11-08
### YAML详解及Java对YML的使用 #### 一、YAML简介 YAML (Yet Another Markup Language) 是一种人类可读的数据序列化格式。它旨在提供清晰且易于理解的数据表示方式，通常用于配置文件中。 #### 二、基本语法规则...
yml格式（list）
曹学成的博客
12-24 1万+
配置一个nodes节点 nodes: - node1 - node2 - node3
Spring Boot之yaml配置注入基本使用
兮动人
01-31 1517
文章目录1. 配置文件2. yaml概述1. yaml基础语法2. 对象、Map（键值对）3. 数组（ List、set ）注入配置文件yaml注入配置文件 1. 配置文件 SpringBoot使用一个全局的配置文件 ， 配置文件名称是固定的 application.properties 语法结构 ：key=value application.yml 语法结构 ：key：空格 value 配置文件的作用 ：修改SpringBoot自动配置的默认值，因为SpringBoot在底层都给我
SpringBoot配置文件详解与yml导入字面量、对象、Map、List、Set等类型语法
qq_38530648的博客
08-23 1150
SpringBoot配置文件详解与配置文件语法格式 配置文件的作用：修改SpringBoot自动配置的默认值；SpringBoot在底层都给我们自动配置好了 配置文件的类型 SpringBoot使用一个全局的配置文件，配置文件名是固定的。配置文件有两种： application.properties application.yml 下面介绍下application.yml YML ...
SpringBoot 中yml配置文件：定义list集合、数组及注意事项
qq_44761854的博客
02-29 5174
2.下面说一下如何在yml配置文件中定义list集合、对象集合、数组以及map集合等。如果使用@value注解会报错；2.1定义list集合。
SpringBoot绑定复杂类型自定义参数（List/Map/Set/自定义对象等）YML
daiyi666的博客
01-15 5457
SpringBoot绑定复杂类型自定义参数（List/Map/Set/自定义对象等）YML
SpringBoot--yaml
dfdvf的博客
01-05 1461
1、yaml相关语法 application.yml语法结构 key:空格value application.yml的作用： 修改SpringBoot自动配置的默认值，因为SpringBoot在底层都给我们自动配置好了； 字面量：普通的值 [ 数字，布尔值，字符串 ] 字面量直接写在后面就可以 ， 字符串默认不用加上双引号或者单引号； name: 张三 注意： “ ” 双引号，不会转义字符串里面的特殊字符 ， 特殊字符会作为本身想表示的意思； 比如 ：name: "张\n三" ..
二十分钟掌握yaml编写方式
weixin_45336222的博客
10-31 3050
​ 在数据格式描述和复杂数据展示方面的配置文件，Yaml设计的原则就是方便人类进行阅读，后缀名结束一般使用yml或者yaml，使用它也需要遵循相关的规范大小写敏感1 #表示注释2 使用缩进表示层级关系，缩进过程中只允许使用空格不允许使用Tab3 相同层级的元素只要左对齐即可支持的数据格式1 字典2 列表3 常量。
springboot~yml里的自定义配置
weixin_34284188的博客
01-02 1134
主要介绍三种，字符串配置，数组配置和带默认值的配置 字符串配置 //yml setString: hello /** * 字符串. */ @Value("${setString}") String setString; 数组配置 //yml setArray: -http://www.taobao.com -http://www.tmall.com /**...
yml基本语法
热门推荐
qq_30443907的博客
09-14 3万+
1、基本语法 格式要求 k:(空格)v：表示一对键值对（空格必须有）； 以空格的缩进来控制层级关系；只要是左对齐的一列数据，都是同一个层级的 server: port: 8081 path: /hello 属性和值也是大小写敏感； 2、值的写法 字面量：普通的值（数字，字符串，布尔） ​ k: v：字面直接来写； ​ 字符串默认不用加上单引号或...
评论 1
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值