netdudes / DataSourceryBundle

        $this->assertEquals('Field1 = "test" or Field2 = "test" or Field3 = "test"', $reducedFilter[3]->toUQL());

    }

    public function testReducesSearchTextFilterWithFilterConditionsAndUsesWildcardForLikeComparisonMethod()

    {

        $fields = [

            $this->buildField('Field1', new StringDataType(), 'field1'),

            $this->buildField('Field2', new StringDataType(), 'field2'),

            $this->buildField('Field3', new StringDataType(), 'field3'),

        ];

        $filterToReduce = $this->createFilter(Filter::CONDITION_TYPE_OR, [

            $this->createFilterCondition('column_search_text', FilterCondition::METHOD_STRING_LIKE, 'test', true),

        ]);

        $searchTextFilterReducer = new SearchTextFilterReducer($fields);

        $reducedFilter = $searchTextFilterReducer->reduceToFilterCondition($filterToReduce);

        $this->assertEquals('Field1 ~ "%test%" or Field2 ~ "%test%" or Field3 ~ "%test%"', $reducedFilter[0]->toUQL());

    }

    public function testReducesSearchTextFilterWithFilterConditionsButSkipsFieldsThatDoNotSupportGivenMethod()

    {

        $this->assertEquals('StringField = "test" or AnotherStringField = "test"', $reducedFilter[0]->toUQL());

    }

    public function testReducesSearchTextFilterWithFilterConditionsButSkipsFieldsThatDoNotDefineDatabaseFilterQueryField()

    {

        $fields = [

            $this->buildField('FieldWithDbQueryField', new StringDataType(), 'field_with_db_field'),

            $this->buildField('FieldWithoutDbQueryField', new StringDataType(), null),

            $this->buildField('AnotherFieldWithDbQueryField', new StringDataType(), 'another_field_with_db_field'),

        ];

        $filterToReduce = $this->createFilter(Filter::CONDITION_TYPE_OR, [

            $this->createFilterCondition('column_search_text', FilterCondition::METHOD_STRING_EQ, 'test', true),

        ]);

        $searchTextFilterReducer = new SearchTextFilterReducer($fields);

        $reducedFilter = $searchTextFilterReducer->reduceToFilterCondition($filterToReduce);

        $this->assertEquals('FieldWithDbQueryField = "test" or AnotherFieldWithDbQueryField = "test"', $reducedFilter[0]->toUQL());

    }

    public function testReducesSearchTextFilterWithFilterConditionsButSkipsFieldsThatDefineDatabaseSelectAliasAsArray()

    {