From bb8416d0943f3e797d572d127a2d74103761d947 Mon Sep 17 00:00:00 2001 From: Joshua Cody Date: Sat, 26 Jul 2014 22:27:31 -0500 Subject: Allow for alias omission in aggregate expressions --- test/test_expressions.rb | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 test/test_expressions.rb (limited to 'test') diff --git a/test/test_expressions.rb b/test/test_expressions.rb new file mode 100644 index 0000000000..d061bbc335 --- /dev/null +++ b/test/test_expressions.rb @@ -0,0 +1,29 @@ +require 'helper' + +module Arel + describe "Expressions" do + before do + @table = Table.new(:users) + end + + describe "average" do + it "aliases the average as avg_id by default" do + @table[:score].average.to_sql.must_be_like %{ + AVG("users"."score") AS avg_id + } + end + + it "aliases the average as another string" do + @table[:score].average("my_alias").to_sql.must_be_like %{ + AVG("users"."score") AS my_alias + } + end + + it "omits the alias if nil" do + @table[:score].average(nil).to_sql.must_be_like %{ + AVG("users"."score") + } + end + end + end +end -- cgit v1.2.3