Rava Laddu

Buy Homemade Ravva Laddu Online

Premium Quality Homemade Rava Laddu is a traditional Indian sweet made with rava, pure ghee, sugar and other best ingredients. It is aromatic, tastes delicious with a slight crunch, and is commonly served during festivals and celebrations. No Preservatives or Added Colors.

// Builds the KDB query for each rule. Paste your full qSQL base bodies below.

public String createQueryWithVariables(String productClass,

                                       String yOrN,

                                       String side,

                                       int lowerBoundPct,

                                       int upperBoundPct) {

    String query = "";

    if ("ASK".equalsIgnoreCase(side)) {

        if ("Y".equalsIgnoreCase(yOrN)) {

            // ASK, retail=Y -> return ONLY rows outside [-10, +5] so Y should assert size==0

            query = "select sym, product_class, offerid, price, idcprice, retail_enabled, pct_away_idcprice, remarks "

                  + "from bp lj rtl where product_class = `" + productClass + " "

                  + " , side = `ASK, retail_enabled = `Y, "

                  + " , (pct_away_idcprice < " + lowerBoundPct + " or pct_away_idcprice > " + upperBoundPct + ")";

        } else {

            // ASK, retail=N -> rows that HAVE remarks; we will validate tokens

            query = "select sym, product_class, offerid, price, idcprice, retail_enabled, pct_away_idcprice, remarks "

                  + "from bp lj rtl where product_class = `" + productClass + " "

                  + " , side = `ASK, retail_enabled = `N";

        }

    } else if ("BID".equalsIgnoreCase(side)) {

        if ("Y".equalsIgnoreCase(yOrN)) {

            // BID, retail=Y -> price not more than X% below best ask

            // Query should return ONLY violating rows (price < best_ask_price*(1 - upperBoundPct/100))

            query =

            "bprtl:bp lj (offerid xkey select sym, offerid, remarks, side, source, retail_enabled, dist_ytw, rtl_bondtier: bondtier, "

          + " rtl_risktest: risktest, rtl_pricetest: pricetest, rtl_mina: mina, rtl_incra: incra, src_rank, io, isExcluded, idctest from rtl "

          + " where product_class like \"" + productClass + "\" , not product_class like \"TIPS\");"

          + "best_ask: sym xkey select sym, best_ask_price: price from rA where bond_type=`S, price=(min;price) fby (1;sym), qty=(max;qty) fby (1;sym), src_rank=(min;src_rank) fby (1;sym);"

          + "select 100 sym, remarks, offerid, price, best_ask_price, pct_away:( (price - best_ask_price) % best_ask_price) * 100 "

          + "from bprtl lj best_ask where side=`BID, retail_enabled=`Y, price < best_ask_price * (1 - " + (upperBoundPct / 100.0) + ")";

        } else {

            // BID, retail=N -> we’ll validate remarks contain “Bid Compliance Check failed”

            query =

            "bprtl:bp lj (offerid xkey select sym, offerid, remarks, side, source, retail_enabled, dist_ytw, rtl_bondtier: bondtier, "

          + " rtl_risktest: risktest, rtl_pricetest: pricetest, rtl_mina: mina, rtl_incra: incra, src_rank, io, isExcluded, idctest from rtl "

          + " where product_class like \"" + productClass + "\" , not product_class like \"TIPS\");"

          + "best_ask: sym xkey select sym, best_ask_price: price from rA where bond_type=`S, price=(min;price) fby (1;sym), qty=(max;qty) fby (1;sym), src_rank=(min;src_rank) fby (1;sym);"

          + "select 100 sym, remarks, offerid, price, best_ask_price, pct_away:( (price - best_ask_price) % best_ask_price) * 100 "

          + "from bprtl lj best_ask where side=`BID, retail_enabled=`N";

        }

    }

    return query;

}