/lib/ans-model-helpers/shared_examples/date_sumup.rb

https://github.com/answer/ans-model-helpers · Ruby · 162 lines · 156 code · 5 blank · 1 comment · 5 complexity · 3d89e25ca9ceda75543123cfc273fd0e MD5 · raw file 

    

  1. # vi: set fileencoding=utf-8
    2. 

  2. 

  3. require "ans-model-helpers/shared_examples/sql"
    4. 

  4. 

  5. shared_examples_for "Ans::Model::Helpers::DateSumup" do
    6. 

  6.   describe ".date_in" do
    7. 

  7.     include Ans::Model::Helpers::SqlSpecHelper
    8. 

  8. 

  9.     before do
    10. 

  10.       scope_は :date_in
    11. 

  11.       sql_は do |sql,p|
    12. 

  12.         sql <<  "SELECT"
    13. 

  13.         sql <<   " `#{table}`.*"
    14. 

  14.         sql << " FROM"
    15. 

  15.         sql <<   " `#{table}`"
    16. 

  16.         sql << " #{date_join}" if respond_to?(:date_join)
    17. 

  17.         sql << " WHERE"
    18. 

  18.         sql <<   " (#{date_column} >= '#{p[:from]}') AND (#{date_column} <= '#{p[:to]}')"
    19. 

  19.       end
    20. 

  20.     end
    21. 

  21.     context "指定日の範囲で検索した場合" do
    22. 

  22.       before do
    23. 

  23.         scope_の引数は day: DateTime.new(2011, 1, 1)
    24. 

  24.         sql_の引数は from: "2011-01-01 00:00:00", to: "2011-01-01 23:59:59"
    25. 

  25.       end
    26. 

  26.       it_should_behave_like "Ans::Model::Helpers::Sql"
    27. 

  27.     end
    28. 

  28.     context "指定範囲で検索した場合" do
    29. 

  29.       before do
    30. 

  30.         scope_の引数は from: DateTime.new(2011, 1, 1), to: DateTime.new(2011, 1, 31)
    31. 

  31.         sql_の引数は from: "2011-01-01 00:00:00", to: "2011-01-31 23:59:59"
    32. 

  32.       end
    33. 

  33.       it_should_behave_like "Ans::Model::Helpers::Sql"
    34. 

  34.     end
    35. 

  35.   end
    36. 

  36. 

  37.   describe ".day_in" do
    38. 

  38.     context "日付指定無しの場合" do
    39. 

  39.       it "は、今日の日付で範囲指定したスコープの配列を返す" do
    40. 

  40.         stub(DateTime).now{DateTime.new(2011,1,10)}
    41. 

  41.         model.day_in({}).should == [
    42. 

  42.           model.date_in(day: DateTime.new(2011, 1, 10)),
    43. 

  43.           "2011-01-10",
    44. 

  44.         ]
    45. 

  45.       end
    46. 

  46.     end
    47. 

  47.     context "day 指定の場合" do
    48. 

  48.       it "は、指定した日付で範囲指定したスコープの配列を返す" do
    49. 

  49.         model.day_in(day: "2011-01-03").should == [
    50. 

  50.           model.date_in(day: DateTime.new(2011, 1, 3)),
    51. 

  51.           "2011-01-03",
    52. 

  52.         ]
    53. 

  53.       end
    54. 

  54.     end
    55. 

  55.   end
    56. 

  56. 

  57.   describe ".days_in" do
    58. 

  58.     context "日付指定無しの場合" do
    59. 

  59.       it "は、今月の日付で範囲指定したスコープの配列を返す" do
    60. 

  60.         stub(DateTime).now{DateTime.new(2011,1,10)}
    61. 

  61.         model.days_in({}).should == [
    62. 

  62.           [
    63. 

  63.             [DateTime.new(2011, 1, 1),  model.date_in(day: DateTime.new(2011, 1, 1))],
    64. 

  64.             [DateTime.new(2011, 1, 2),  model.date_in(day: DateTime.new(2011, 1, 2))],
    65. 

  65.             [DateTime.new(2011, 1, 3),  model.date_in(day: DateTime.new(2011, 1, 3))],
    66. 

  66.             [DateTime.new(2011, 1, 4),  model.date_in(day: DateTime.new(2011, 1, 4))],
    67. 

  67.             [DateTime.new(2011, 1, 5),  model.date_in(day: DateTime.new(2011, 1, 5))],
    68. 

  68.             [DateTime.new(2011, 1, 6),  model.date_in(day: DateTime.new(2011, 1, 6))],
    69. 

  69.             [DateTime.new(2011, 1, 7),  model.date_in(day: DateTime.new(2011, 1, 7))],
    70. 

  70.             [DateTime.new(2011, 1, 8),  model.date_in(day: DateTime.new(2011, 1, 8))],
    71. 

  71.             [DateTime.new(2011, 1, 9),  model.date_in(day: DateTime.new(2011, 1, 9))],
    72. 

  72.             [DateTime.new(2011, 1, 10), model.date_in(day: DateTime.new(2011, 1, 10))],
    73. 

  73.             [DateTime.new(2011, 1, 11), model.date_in(day: DateTime.new(2011, 1, 11))],
    74. 

  74.             [DateTime.new(2011, 1, 12), model.date_in(day: DateTime.new(2011, 1, 12))],
    75. 

  75.             [DateTime.new(2011, 1, 13), model.date_in(day: DateTime.new(2011, 1, 13))],
    76. 

  76.             [DateTime.new(2011, 1, 14), model.date_in(day: DateTime.new(2011, 1, 14))],
    77. 

  77.             [DateTime.new(2011, 1, 15), model.date_in(day: DateTime.new(2011, 1, 15))],
    78. 

  78.             [DateTime.new(2011, 1, 16), model.date_in(day: DateTime.new(2011, 1, 16))],
    79. 

  79.             [DateTime.new(2011, 1, 17), model.date_in(day: DateTime.new(2011, 1, 17))],
    80. 

  80.             [DateTime.new(2011, 1, 18), model.date_in(day: DateTime.new(2011, 1, 18))],
    81. 

  81.             [DateTime.new(2011, 1, 19), model.date_in(day: DateTime.new(2011, 1, 19))],
    82. 

  82.             [DateTime.new(2011, 1, 20), model.date_in(day: DateTime.new(2011, 1, 20))],
    83. 

  83.             [DateTime.new(2011, 1, 21), model.date_in(day: DateTime.new(2011, 1, 21))],
    84. 

  84.             [DateTime.new(2011, 1, 22), model.date_in(day: DateTime.new(2011, 1, 22))],
    85. 

  85.             [DateTime.new(2011, 1, 23), model.date_in(day: DateTime.new(2011, 1, 23))],
    86. 

  86.             [DateTime.new(2011, 1, 24), model.date_in(day: DateTime.new(2011, 1, 24))],
    87. 

  87.             [DateTime.new(2011, 1, 25), model.date_in(day: DateTime.new(2011, 1, 25))],
    88. 

  88.             [DateTime.new(2011, 1, 26), model.date_in(day: DateTime.new(2011, 1, 26))],
    89. 

  89.             [DateTime.new(2011, 1, 27), model.date_in(day: DateTime.new(2011, 1, 27))],
    90. 

  90.             [DateTime.new(2011, 1, 28), model.date_in(day: DateTime.new(2011, 1, 28))],
    91. 

  91.             [DateTime.new(2011, 1, 29), model.date_in(day: DateTime.new(2011, 1, 29))],
    92. 

  92.             [DateTime.new(2011, 1, 30), model.date_in(day: DateTime.new(2011, 1, 30))],
    93. 

  93.             [DateTime.new(2011, 1, 31), model.date_in(day: DateTime.new(2011, 1, 31))],
    94. 

  94.           ],
    95. 

  95.           model.date_in(from: DateTime.new(2011, 1, 1), to: DateTime.new(2011, 1, 31)),
    96. 

  96.           ["2011-01-01","2011-01-31"],
    97. 

  97.         ]
    98. 

  98.       end
    99. 

  99.     end
    100. 

  100.     context "month 指定の場合" do
    101. 

  101.       it "は、指定した月の日付で範囲指定したスコープの配列を返す" do
    102. 

  102.         model.days_in(month: "2011-01-01").should == [
    103. 

  103.           [
    104. 

  104.             [DateTime.new(2011, 1, 1),  model.date_in(day: DateTime.new(2011, 1, 1))],
    105. 

  105.             [DateTime.new(2011, 1, 2),  model.date_in(day: DateTime.new(2011, 1, 2))],
    106. 

  106.             [DateTime.new(2011, 1, 3),  model.date_in(day: DateTime.new(2011, 1, 3))],
    107. 

  107.             [DateTime.new(2011, 1, 4),  model.date_in(day: DateTime.new(2011, 1, 4))],
    108. 

  108.             [DateTime.new(2011, 1, 5),  model.date_in(day: DateTime.new(2011, 1, 5))],
    109. 

  109.             [DateTime.new(2011, 1, 6),  model.date_in(day: DateTime.new(2011, 1, 6))],
    110. 

  110.             [DateTime.new(2011, 1, 7),  model.date_in(day: DateTime.new(2011, 1, 7))],
    111. 

  111.             [DateTime.new(2011, 1, 8),  model.date_in(day: DateTime.new(2011, 1, 8))],
    112. 

  112.             [DateTime.new(2011, 1, 9),  model.date_in(day: DateTime.new(2011, 1, 9))],
    113. 

  113.             [DateTime.new(2011, 1, 10), model.date_in(day: DateTime.new(2011, 1, 10))],
    114. 

  114.             [DateTime.new(2011, 1, 11), model.date_in(day: DateTime.new(2011, 1, 11))],
    115. 

  115.             [DateTime.new(2011, 1, 12), model.date_in(day: DateTime.new(2011, 1, 12))],
    116. 

  116.             [DateTime.new(2011, 1, 13), model.date_in(day: DateTime.new(2011, 1, 13))],
    117. 

  117.             [DateTime.new(2011, 1, 14), model.date_in(day: DateTime.new(2011, 1, 14))],
    118. 

  118.             [DateTime.new(2011, 1, 15), model.date_in(day: DateTime.new(2011, 1, 15))],
    119. 

  119.             [DateTime.new(2011, 1, 16), model.date_in(day: DateTime.new(2011, 1, 16))],
    120. 

  120.             [DateTime.new(2011, 1, 17), model.date_in(day: DateTime.new(2011, 1, 17))],
    121. 

  121.             [DateTime.new(2011, 1, 18), model.date_in(day: DateTime.new(2011, 1, 18))],
    122. 

  122.             [DateTime.new(2011, 1, 19), model.date_in(day: DateTime.new(2011, 1, 19))],
    123. 

  123.             [DateTime.new(2011, 1, 20), model.date_in(day: DateTime.new(2011, 1, 20))],
    124. 

  124.             [DateTime.new(2011, 1, 21), model.date_in(day: DateTime.new(2011, 1, 21))],
    125. 

  125.             [DateTime.new(2011, 1, 22), model.date_in(day: DateTime.new(2011, 1, 22))],
    126. 

  126.             [DateTime.new(2011, 1, 23), model.date_in(day: DateTime.new(2011, 1, 23))],
    127. 

  127.             [DateTime.new(2011, 1, 24), model.date_in(day: DateTime.new(2011, 1, 24))],
    128. 

  128.             [DateTime.new(2011, 1, 25), model.date_in(day: DateTime.new(2011, 1, 25))],
    129. 

  129.             [DateTime.new(2011, 1, 26), model.date_in(day: DateTime.new(2011, 1, 26))],
    130. 

  130.             [DateTime.new(2011, 1, 27), model.date_in(day: DateTime.new(2011, 1, 27))],
    131. 

  131.             [DateTime.new(2011, 1, 28), model.date_in(day: DateTime.new(2011, 1, 28))],
    132. 

  132.             [DateTime.new(2011, 1, 29), model.date_in(day: DateTime.new(2011, 1, 29))],
    133. 

  133.             [DateTime.new(2011, 1, 30), model.date_in(day: DateTime.new(2011, 1, 30))],
    134. 

  134.             [DateTime.new(2011, 1, 31), model.date_in(day: DateTime.new(2011, 1, 31))],
    135. 

  135.           ],
    136. 

  136.           model.date_in(from: DateTime.new(2011, 1, 1), to: DateTime.new(2011, 1, 31)),
    137. 

  137.           ["2011-01-01","2011-01-31"],
    138. 

  138.         ]
    139. 

  139.       end
    140. 

  140.     end
    141. 

  141.     context "from, to 指定の場合" do
    142. 

  142.       it "は、指定した範囲で範囲指定したスコープの配列を返す" do
    143. 

  143.         model.days_in(from: "2011-01-01", to: "2011-01-10").should == [
    144. 

  144.           [
    145. 

  145.             [DateTime.new(2011, 1, 1),  model.date_in(day: DateTime.new(2011, 1, 1))],
    146. 

  146.             [DateTime.new(2011, 1, 2),  model.date_in(day: DateTime.new(2011, 1, 2))],
    147. 

  147.             [DateTime.new(2011, 1, 3),  model.date_in(day: DateTime.new(2011, 1, 3))],
    148. 

  148.             [DateTime.new(2011, 1, 4),  model.date_in(day: DateTime.new(2011, 1, 4))],
    149. 

  149.             [DateTime.new(2011, 1, 5),  model.date_in(day: DateTime.new(2011, 1, 5))],
    150. 

  150.             [DateTime.new(2011, 1, 6),  model.date_in(day: DateTime.new(2011, 1, 6))],
    151. 

  151.             [DateTime.new(2011, 1, 7),  model.date_in(day: DateTime.new(2011, 1, 7))],
    152. 

  152.             [DateTime.new(2011, 1, 8),  model.date_in(day: DateTime.new(2011, 1, 8))],
    153. 

  153.             [DateTime.new(2011, 1, 9),  model.date_in(day: DateTime.new(2011, 1, 9))],
    154. 

  154.             [DateTime.new(2011, 1, 10), model.date_in(day: DateTime.new(2011, 1, 10))],
    155. 

  155.           ],
    156. 

  156.           model.date_in(from: DateTime.new(2011, 1, 1), to: DateTime.new(2011, 1, 10)),
    157. 

  157.           ["2011-01-01","2011-01-10"],
    158. 

  158.         ]
    159. 

  159.       end
    160. 

  160.     end
    161. 

  161.   end
    162. 

  162. end
    163.