OnetoMany kundera cassandra based on condition

[sreekanth0041]

I have two table one is products and next one is discounts,problem is when i am getting the products i want to get the discounts based on valid date.If date expires then i don't want to get the record.
My code is below
Products.java

@Entity
@Table(name = "products", schema = "db@cassandra")
public class Products {

    @Id
    @Column(name = "prod_id")
    private UUID prod_id;

    @Column(name = "product_name")
    private String store_name;

    @Column(name = "product_price")
    private BigDecimal store_price;

    @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
    @JoinColumn(name = "prod_id")
    private List<Discount> discount;

//setter and getters
}

Discount.java

@Entity
@Table(name = "products", schema = "db@cassandra")
public class Discount{
       @Id
    @Column(name = "discount_id")
    private UUID discount_id;

    @Column(name = "prod_id")
    private UUID prod_id;

    @Column(name = "discount_name")
    private String discount_name;

    @Column(name = "start_date")
    private Timestamp start_date;

    @Column(name = "end_date")
    private Timestamp end_date;

//setter and getters
}

Main.java

          em = emf.createEntityManager();
          Query q = em.createQuery("select p from Products p");
          List<Products> products= q.getResultList();
          em.close();

Can you please help me.

[chhavigangwal]

@sreekanth0041

In order to enable querying over non-primary key columns you need to create indexes on them in the following manner :

@Entity
@Table(name = "products", schema = "db@cassandra")
@IndexCollection(columns = { @Index(name = "start_date")})
public class Discount{
       @Id
    @Column(name = "discount_id")
    private UUID discount_id;

However, you cannot directly query over associated entity's attribute using Kundera. So you can resolve your problem in the following manner :

• Fetch all objects of Discount which are not expired

  Query q = em.createQuery("select p from Discount p where p.end_date > :date ").setParameter(new Date());
   List<Discount> discounts= q.getResultList();

• Loop through discount objects to retrieve the product ids and

Hope that Helps!
Chhavi

[devender-yadav]

@sreekanth0041
Did the above suggestion work for you?

Devender