add test for sql string collector

1 files changed, 38 insertions, 0 deletions

diff --git a/test/collectors/test_sql_string.rb b/test/collectors/test_sql_string.rb
new file mode 100644
index 0000000000..6d2e23151b
--- /dev/null
+++ b/test/collectors/test_sql_string.rb
@@ -0,0 +1,38 @@
+require 'helper'
+require 'arel/collectors/bind'
+
+module Arel
+  module Collectors
+    class TestSqlString < Arel::Test
+      def setup
+        @conn = FakeRecord::Base.new
+        @visitor = Visitors::ToSql.new @conn.connection
+        super
+      end
+
+      def collect node
+        @visitor.accept(node, Collectors::SQLString.new)
+      end
+
+      def compile node
+        collect(node).value
+      end
+
+      def ast_with_binds bv
+        table = Table.new(:users)
+        manager = Arel::SelectManager.new Table.engine, table
+        manager.where(table[:age].eq(bv))
+        manager.where(table[:name].eq(bv))
+        manager.ast
+      end
+
+      def test_compile
+        bv = Nodes::BindParam.new('?')
+        collector = collect ast_with_binds bv
+
+        sql = collector.compile ["hello", "world"]
+        assert_equal 'SELECT FROM "users" WHERE "users"."age" = ? AND "users"."name" = ?', sql
+      end
+    end
+  end
+end