MyBatis实体类中包含实体类的多个where条件的mapper.xml

MyBatis实体类中包含实体类的多个where条件的mapper.xml

SELECT a.metric_id, a.metric_name, a.metric_label_name, a.label_name_sep, a.external_metric_name, a.metric_implication, a.metric_type_code, a.metric_template_code, a.metric_source, a.created_by, a.created_time, a.updated_by, a.updated_time, c.metric_type_value, d.instance_type_value AS metric_template_value FROM tb_metrics as a JOIN tb_metric_type_code AS c ON a.metric_type_code = c.metric_type_code JOIN tb_monitor_instance_type AS d ON a.metric_template_code = d.instance_type_code metric_name = #{metricDto.metricName} instance_type_value = #{metricDto.metricTemplateValue}

public class MetricDto extends BaseEntity { @ApiModelProperty(value = "指标实体类", position = 11) private MetricEntity metricEntity; @ApiModelProperty(value = "指标类型码值", position = 5) private String metricTypeValue; @ApiModelProperty(value = "指标模板码值", position = 6) private String metricTemplateValue;}

public class MetricEntity extends BaseEntity { @TableId(type = IdType.AUTO) @ApiModelProperty(value = "指标ID", position = 1) private Integer metricId; /** * metricName是externalMetricName标准化后的指标，包括命名等标准化. * 比如从Zabbix或者Prometheus或者JMX等采集来的指标名称方式不同，造成命名冲突等. * * @see externalMetricName */ @ApiModelProperty(value = "指标名称", position = 2) private String metricName; /** * metricUnit是externalMetricUnit经过换算过的指标单位. * * @see externalMetricUnit */ @ApiModelProperty(value = "指标单位", position = 3) private String metricUnit; @ApiModelProperty(value = "指标单位含义") private String metricUnitMean; @ApiModelProperty(value = "指标单位类型") private String metricUnitType; /** * @see metricName */ @ApiModelProperty(value = "外部指标名称", position = 4) private String externalMetricName; /** * 它是外部指标原生的单位，例如prometheus中指标单位都是标准单位. * * @see metricUnit */ @ApiModelProperty(value = "外部指标单位", position = 5) private String externalMetricUnit; @ApiModelProperty(value = "外部指标单位含义") private String externalMetricUnitMean; @ApiModelProperty(value = "指标含义", position = 6) private String metricImplication; @ApiModelProperty(value = "指标类型编码", position = 7) private String metricTypeCode; @ApiModelProperty(value = "指标模板编码", position = 8) private Integer metricTemplateCode; @ApiModelProperty(value = "指标来源", position = 9) private String metricSource; /** * 有些指标没有标签（label），例如up指标，metricLabelName就为空. * 有些指标有标签（label），例如偏移量off_set{topic="test",partition="1"},metricLabelName为topic,partition * 标签名之间默认使用英文逗号隔开 * * @see labelNameSep 标签名分隔符 */ @ApiModelProperty(value = "指标标签名", position = 10) private String metricLabelName; /** * 默认分隔符：英文逗号. * * @see metricLabelName */ @ApiModelProperty(value = "指标标签名分隔符", position = 11) private String labelNameSep; @ApiModelProperty(value = "promql查询选择器", position = 12) private String promSelector; private Integer isDelete;}

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。