Escape _ and % in SQL LIKE queries.

Fixes #40.

1 files changed, 26 insertions, 0 deletions

diff --git a/web/test/test_utils.rb b/web/test/test_utils.rb
new file mode 100644
index 0000000..7d0afce
--- /dev/null
+++ b/web/test/test_utils.rb
@@ -0,0 +1,26 @@
+$: << 'lib'
+require File.join(File.dirname(__FILE__), '..', 'lib', 'utils.rb')
+require 'test/unit'
+
+class TestSql < Test::Unit::TestCase
+
+    def test_like_escape
+        assert_equal 'x@%y', like_escape('x%y')
+        assert_equal 'x@_', like_escape('x_')
+        assert_equal '@@a', like_escape('@a')
+        assert_equal '', like_escape('')
+        assert_equal '', like_escape(nil)
+    end
+
+    def test_like_prefix
+        assert_equal 'postal@_%', like_prefix('postal_')
+        assert_equal '@%foo%', like_prefix('%foo')
+    end
+
+    def test_like_contains
+        assert_equal '%name%', like_contains('name')
+        assert_equal '%foo@_bar%', like_contains('foo_bar')
+        assert_equal '%@@123%', like_contains('@123')
+    end
+
+end