Advertisement
Guest User

Untitled

a guest
May 5th, 2014
267
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.97 KB | None | 0 0
  1. irb(main):001:0> @lhgs = Totalsold.order('date asc').group_by{ |s| [s.date, s.store_id, s.nomor] }
  2.  
  3. ←[1m←[36mTotalsold Load (84.0ms)←[0m ←[1mSELECT "totalsolds".* FROM "totalsolds" WHERE (date >= '2014-05-01 00:00:00.000000' AND date <= '2014-05-31 23:59:59.999999') ORDER BY date asc←[0m
  4. ←[1m←[36mEXPLAIN (1.0ms)←[0m ←[1mEXPLAIN SELECT "totalsolds".* FROM "totalsolds" WHERE(date >= '2014-05-01 00:00:00.000000' AND date <= '2014-05-31 23:59:59.999999') ORDER BY date asc←[0m
  5. EXPLAIN for: SELECT "totalsolds".* FROM "totalsolds" WHERE (date >= '2014-05-01 00:00:00.000000' AND date <= '2014-05-31 23:59:59.999999') ORDER BY date asc
  6.  
  7. QUERY PLAN
  8. ----------------------------------------------------------------------------------------------------
  9. ---
  10. Sort (cost=1.48..1.51 rows=14 width=51)
  11. Sort Key: date
  12. -> Seq Scan on totalsolds (cost=0.00..1.21 rows=14 width=51)
  13. Filter: ((date >= '2014-05-01'::date) AND (date <= '2014-05-31'::date
  14. ))
  15. (4 rows)
  16.  
  17.  
  18. => {[Mon, 05 May 2014, 1, "111111"]=>[#<Totalsold id: 44, nomor: "111111", store_id: 1, date: "2014-05-05", created_at: "2014-05-04 05:30:23", updated_at: "2014-05-04 05:30:23", product_id: 34, price_id: 45, qty: 0, value: #<BigDecimal:4e7e078,'0.0',9(18)>>, #<Totalsold id: 39, nomor: "111111", store_id: 1, date: "2014-05-05", created_at: "2014-05-04 05:30:23", updated_at: "2014-05-04 05:30:23", product_id: 31, price_id: 37, qty: 0, value: #<BigDecimal:4e7d0d0,'0.0',9(18)>>, #<Totalsold id: 41, nomor: "111111", store_id: 1, date: "2014-05-05", created_at: "2014-05-04 05:30:23", updated_at: "2014-05-04 05:30:23", product_id:28, price_id: 42, qty: 0, value: #<BigDecimal:4e7c1d0,'0.0',9(18)>>, #<Totalsold id:43, nomor: "111111", store_id: 1, date: "2014-05-05", created_at: "2014-05-04 05:30:23", updated_at: "2014-05-04 05:30:23", product_id: 33, price_id: 44, qty: 0, value: #<BigDecimal:4e6ad28,'0.0',9(18)>>, #<Totalsold id: 40, nomor: "111111", store_id: 1, date: "2014-05-05", created_at: "2014-05-04 05:30:23", updated_at: "2014-05-04 18:43:59", product_id: 30, price_id: 41, qty: 2, value: #<BigDecimal:4e69e40,'0.2444E6',9(18)>>, #<Totalsold id: 38, nomor: "111111", store_id: 1, date: "2014-05-05", created_at: "2014-05-04 05:30:23", updated_at: "2014-05-04 18:48:24", product_id: 29, price_id: 35, qty: 1, value: #<BigDecimal:4e68f10,'0.125E6',9(18)>>, #<Totalsold id: 42, nomor: "111111", store_id: 1, date: "2014-05-05", created_at: "2014-05-04 05:30:23", updated_at: "2014-05-04 05:30:23", product_id: 32, price_id: 43, qty: 2, value: #<BigDecimal:4e68028,'0.6E6',9(18)>>], [Mon, 05 May 2014, 2, "123456"]=>[#<Totalsold id: 54, nomor: "123456", store_id: 2, date: "2014-05-05", created_at: "2014-05-04 09:12:56", updated_at: "2014-05-04 09:12:56", product_id: 30, price_id: 41, qty: 3, value: #<BigDecimal:4e66bb8,'0.3666E6',9(18)>>, #<Totalsold id: 55, nomor: "123456", store_id: 2, date: "2014-05-05", created_at: "2014-05-04 09:12:56", updated_at: "2014-05-04 09:12:56", product_id: 28, price_id: 42, qty: 23, value: #<BigDecimal:4e65bc8,'0.28106E6',9(18)>>, #<Totalsold id: 56, nomor: "123456", store_id: 2, date: "2014-05-05", created_at: "2014-05-04 09:12:56", updated_at: "2014-05-04 09:12:56", product_id: 32, price_id: 43, qty: 0, value: #<BigDecimal:4e64350,'0.0',9(18)>>, #<Totalsold id: 57, nomor: "123456", store_id: 2, date: "2014-05-05", created_at: "2014-05-04 09:12:56", updated_at: "2014-05-04 09:12:56", product_id: 33, price_id: 44, qty: 0, value: #<BigDecimal:4e634c8,'0.0',9(18)>>, #<Totalsold id: 58, nomor: "123456", store_id: 2, date: "2014-05-05", created_at: "2014-05-04 09:12:56", updated_at: "2014-05-04 09:12:56", product_id: 34, price_id: 45, qty: 0, value: #<BigDecimal:4e524b8,'0.0',9(18)>>, #<Totalsold id: 52, nomor: "123456", store_id: 2, date: "2014-05-05", created_at: "2014-05-04 09:12:56", updated_at: "2014-05-04 09:12:56", product_id: 29, price_id: 35, qty: 1, value: #<BigDecimal:4e514b0,'0.125E6',9(18)>>, #<Totalsold id: 53, nomor: "123456", store_id: 2, date: "2014-05-05", created_at: "2014-05-04 09:12:56", updated_at: "2014-05-04 09:12:56", product_id: 31, price_id: 37, qty: 0, value: #<BigDecimal:4e504c0,'0.0',9(18)>>], [Tue, 06 May 2014, 1, "122221"]=>[#<Totalsold id: 68, nomor: "122221", store_id: 1, date: "2014-05-06", created_at: "2014-05-04 16:51:42", updated_at: "2014-05-04 16:51:42", product_id: 30, price_id: 41, qty: 1, value: #<BigDecimal:4e4f3f8,'0.1222E6',9(18)>>, #<Totalsold id: 69, nomor: "122221", store_id: 1, date: "2014-05-06", created_at: "2014-05-04 16:51:42", updated_at: "2014-05-04 16:51:42", product_id: 28, price_id: 42, qty: 0, value: #<BigDecimal:4e4e420,'0.0',9(18)>>, #<Totalsold id: 70, nomor: "122221", store_id: 1, date: "2014-05-06", created_at: "2014-05-04 16:51:42", updated_at: "2014-05-04 16:51:42", product_id: 32, price_id: 43, qty: 0, value: #<BigDecimal:4e4d400,'0.0',9(18)>>, #<Totalsold id: 71, nomor: "122221", store_id: 1, date: "2014-05-06", created_at: "2014-05-04 16:51:42", updated_at: "2014-05-04 16:51:42", product_id: 33, price_id: 44, qty: 0, value: #<BigDecimal:4e4c440,'0.0',9(18)>>, #<Totalsold id: 72, nomor: "122221", store_id: 1, date: "2014-05-06", created_at: "2014-05-04 16:51:42", updated_at: "2014-05-04 16:51:42", product_id: 34, price_id: 45, qty: 0, value: #<BigDecimal:4e4b390,'0.0',9(18)>>, #<Totalsold id: 73, nomor: "122221", store_id: 1, date: "2014-05-06", created_at: "2014-05-04 16:51:42", updated_at: "2014-05-04 16:51:42", product_id: 36, price_id: 47, qty: 2, value: #<BigDecimal:4e4a3a0,'0.4E6',9(18)>>, #<Totalsold id: 67, nomor: "122221", store_id: 1, date: "2014-05-06", created_at: "2014-05-04 16:51:42", updated_at: "2014-05-04 18:48:42", product_id: 31, price_id: 37, qty: 1, value: #<BigDecimal:4e493c8,'0.4E6',9(18)>>, #<Totalsold id: 66, nomor: "122221", store_id: 1, date: "2014-05-06", created_at: "2014-05-04 16:51:42", updated_at: "2014-05-04 16:51:42", product_id: 29, price_id: 35, qty: 1, value: #<BigDecimal:4e48468,'0.125E6',9(18)>>]}
  19.  
  20. irb(main):002:0> @lhgs.class
  21. => Hash
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement