From fef9ce493ec3eab3cf120550abd0257f89eaddf7 Mon Sep 17 00:00:00 2001 From: Tamir Duberstein Date: Wed, 24 Sep 2014 19:01:33 -0700 Subject: {Matches,DoesNotMatch} support the ESCAPE clause --- test/visitors/test_to_sql.rb | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'test/visitors') diff --git a/test/visitors/test_to_sql.rb b/test/visitors/test_to_sql.rb index 195566902b..abd8cfe356 100644 --- a/test/visitors/test_to_sql.rb +++ b/test/visitors/test_to_sql.rb @@ -312,6 +312,13 @@ module Arel } end + it "can handle ESCAPE" do + node = @table[:name].matches('foo!%', '!') + compile(node).must_be_like %{ + "users"."name" LIKE 'foo!%' ESCAPE '!' + } + end + it 'can handle subqueries' do subquery = @table.project(:id).where(@table[:name].matches('foo%')) node = @attr.in subquery @@ -329,6 +336,13 @@ module Arel } end + it "can handle ESCAPE" do + node = @table[:name].does_not_match('foo!%', '!') + compile(node).must_be_like %{ + "users"."name" NOT LIKE 'foo!%' ESCAPE '!' + } + end + it 'can handle subqueries' do subquery = @table.project(:id).where(@table[:name].does_not_match('foo%')) node = @attr.in subquery -- cgit v1.2.3