IsNullTest.java

package net.sourceforge.mayfly.evaluation.condition;

import junit.framework.TestCase;

import net.sourceforge.mayfly.datastore.NullCell;
import net.sourceforge.mayfly.datastore.Row;
import net.sourceforge.mayfly.datastore.StringCell;
import net.sourceforge.mayfly.datastore.TupleBuilder;
import net.sourceforge.mayfly.evaluation.condition.IsNull;
import net.sourceforge.mayfly.evaluation.expression.SingleColumn;
import net.sourceforge.mayfly.parser.Parser;
import net.sourceforge.mayfly.util.MayflyAssert;

public class IsNullTest extends TestCase {

    public void testParse() throws Exception {
        IsNull condition = (IsNull) new Parser("name is null").parseCondition().asBoolean();
        MayflyAssert.assertColumn("name", condition.expression);
    }

    public void testEvaluate() throws Exception {
        Row nullRow =
            new TupleBuilder()
                .append("colA", NullCell.INSTANCE)
                .asRow()
        ;

        assertTrue(new IsNull(new SingleColumn("colA")).evaluate(nullRow, "table1"));

        Row nonNullRow =
            new TupleBuilder()
                .append("colA", new StringCell("foo"))
                .asRow()
        ;

        assertFalse(new IsNull(new SingleColumn("colA")).evaluate(nonNullRow, "table1"));
    }

}