web/test/test_utils.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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