Contents

# -*- coding: utf-8 -*-
require 'helper'
require 'write_xlsx'
require 'stringio'

class TestExtractFilterTokens < Test::Unit::TestCase
  def setup
    @workbook = WriteXLSX.new(StringIO.new)
    @worksheet = @workbook.add_worksheet('')
  end

  def test_extract_filter_tokens
    [
      [
          nil,
          [],
      ],

      [
          '',
          [],
      ],

      [
          '0 <  2000',
          [0, '<', 2000],
      ],

      [
          'x <  2000',
          ['x', '<', 2000],
      ],

      [
          'x >  2000',
          ['x', '>', 2000],
      ],

      [
          'x == 2000',
          ['x', '==', 2000],
      ],

      [
          'x >  2000 and x <  5000',
          ['x', '>',  2000, 'and', 'x', '<', 5000],
      ],

      [
          'x = "foo"',
          ['x', '=', 'foo'],
      ],

      [
          'x = foo',
          ['x', '=', 'foo'],
      ],

      [
          'x = "foo bar"',
          ['x', '=', 'foo bar'],
      ],

      [
          'x = "foo "" bar"',
          ['x', '=', 'foo " bar'],
      ],

      [
          'x = "foo bar" or x = "bar foo"',
          ['x', '=', 'foo bar', 'or', 'x', '=', 'bar foo'],
      ],

      [
          'x = "foo "" bar" or x = "bar "" foo"',
          ['x', '=', 'foo " bar', 'or', 'x', '=', 'bar " foo'],
      ],

      [
          'x = """"""""',
          ['x', '=', '"""'],
      ],

      [
          'x = Blanks',
          ['x', '=', 'Blanks'],
      ],

      [
          'x = NonBlanks',
          ['x', '=', 'NonBlanks'],
      ],

      [
          'top 10 %',
          ['top', 10, '%'],
      ],

      [
          'top 10 items',
          ['top', 10, 'items'],
      ]
    ].each do |test|
      expected = test[1]
      result = @worksheet.__send__('extract_filter_tokens', test[0])
      assert_equal(expected, result)
    end
  end
end

Version data entries

52 entries across 52 versions & 1 rubygems

Version	Path
write_xlsx-0.86.0	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.11	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.10	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.9	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.8	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.7	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.6	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.5	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.4	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.3	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.2	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.85.1	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.83.0	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.81.1	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.81.0	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.80.0	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.79.0	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.78.0	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.77.2	test/worksheet/test_extract_filter_tokens.rb
write_xlsx-0.77.1	test/worksheet/test_extract_filter_tokens.rb