jpa/hibernate @onetomany 使用left join 添加多条件,可以使用过滤器filters (with-clause not allowed on fetched associations; use filters异常信息)
2024-09-16 10:52:19
package com.ipinyou.mip.dataAsset.campaignManagement.entity; import com.ipinyou.mip.utils.NumberUtils;
import com.ipinyou.mip.utils.StringHelper;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.ToString;
import org.apache.commons.lang3.builder.HashCodeExclude;
import org.hibernate.annotations.Filter; import javax.persistence.*; import java.text.DecimalFormat;
import java.util.HashSet;
import java.util.Set; import static javax.persistence.FetchType.EAGER;
import static javax.persistence.FetchType.LAZY; @Data
@Entity
@Table(name = "campaign_dashboard_dimension")
@ToString
@EqualsAndHashCode
public class CampaignDashboardDimensionDo { @Id
private Long id; @Transient
private Double impRate = 1.0;
@Column(name = "3_reach")
private Double reach3;
@Column(name = "1_reach")
private Double reach1;
private Long campaignId;
@OneToMany(fetch = LAZY, cascade = CascadeType.ALL)
@JoinColumn(name = "campaign_dashboard_dimension_id")
@org.hibernate.annotations.OrderBy(clause = "imp desc")
@Filter(name = "dimension",condition = "dimension_type=:dimension ")
private Set<CampaignDashboardDimensionDetailDo> campaignDashboardDimensionDetailDo = new HashSet<>(); }
one
package com.ipinyou.mip.dataAsset.campaignManagement.entity; import com.ipinyou.mip.utils.NumberUtils;
import com.ipinyou.mip.utils.StringHelper;
import lombok.Data;
import lombok.ToString;
import org.hibernate.annotations.FilterDef;
import org.hibernate.annotations.OrderBy;
import org.hibernate.annotations.ParamDef;
import org.hibernate.annotations.Where; import javax.persistence.*;
import java.text.DecimalFormat; import static javax.persistence.FetchType.EAGER; @Data
@Entity
@Table(name = "campaign_dashboard_dimension_detail")
@ToString
@FilterDef(name="dimension", parameters=@ParamDef(name="dimension",type="java.lang.String"))
public class CampaignDashboardDimensionDetailDo {
@Id
private Long id;
private Long version;
private java.sql.Timestamp lastModified;
private String removed; private Long imp;
private Double reachRate;
private String dimensionName;
private String dimensionType;
private Long uv;
private Long click;
private Double ta = 0.0; @Transient
private Double impRate;
@Transient
private Double diffTa;
@Transient
private Double diffReach3 = 0.0;
@Transient
private Double targetTa = 0.0;
@Transient
private Double targetReach3 = 0.0; }
many
public List<CampaignDashboardDimensionDo> getCategoryData(List<String> displayType, String dimension, String source, Long campaignId) { List<CampaignDashboardDimensionDo> resultList=new ArrayList<>();
if (displayType==null||displayType.isEmpty()){
return resultList;
} for (String type:displayType ){
StringBuilder sb = new StringBuilder();
sb.append("select cdd from CampaignDashboardDimensionDo as cdd left join fetch cdd.campaignDashboardDimensionDetailDo as cddd where cdd.campaignId=:campaignId and cdd.source=:source" +
" and cdd.logDate=(select max(logDate) from CampaignDashboardDimensionDo where campaignId=:campaignId and source=:source and displayType=:type) and cdd.displayType=:type");
Filter filter = entityManager.unwrap(Session.class).enableFilter("dimension");
filter.setParameter("dimension",dimension);
TypedQuery<CampaignDashboardDimensionDo> query = entityManager.createQuery(sb.toString(), CampaignDashboardDimensionDo.class);
query.setParameter("type",type);
query.setParameter("source", source);
query.setParameter("campaignId", campaignId);
List<CampaignDashboardDimensionDo> list = query.getResultList();
Set<CampaignDashboardDimensionDo> set=new HashSet<>(list);
resultList.addAll(set);
} return resultList; }
查询代码
最新文章
- [转]五种开源协议的比较(BSD,Apache,GPL,LGPL,MIT)
- CityGML文件格式
- 137. Single Number II
- mysql 清除数据库数据
- libvirt虚拟系统如何增加usb设备
- 关于mapreduce过程中出现的错误:Too many fetch-failures
- appcan 跨窗口处理方法 appcan.window.evaluateScript({name,scriptContent,type})使用解读
- Light OJ 1036 - A Refining Company
- Microservice架构模
- struts2标签库----数据标签详解
- api-gateway实践(09)支持rest服务注册
- LVS负载均衡原理
- consul介绍
- python使用requests发送application/json报文数据
- nginx的白名单
- [JS] Topic - define ";class"; by tricky methods
- 统计数组中各个元素出现的次数,元素取值范围为:1到N
- sublime sftp 打开远程文件夹
- 第三百七十七节,Django+Xadmin打造上线标准的在线教育平台—apps目录建立,以及数据表生成
- Linux系统下 MongoDB安装搭建
热门文章
- 超哥笔记 -- 用户管理、权限设置、进程管理、中文配置、计划任务和yum源配置(5)
- .net 调用java service 代理类方法
- Kafka配置项unclean.leader.election.enable造成consumer出现offset重置现象
- 使用time+dd测试硬盘读写速度
- debian8下acme nginx 部署记录
- mac 利用svn下载远程代码出现Agreeing to the Xcode/iOS license requires admin privileges, please re-run as root via sudo.
- java将对象转map,map转对象工具类
- iOS 基础:Frames、Bounds 和 CGGeometry
- SpringMVC整合freeMarker实现页面静态化+SpringMVC配置多视图
- Android——具有边框的Textview