tests/testthat/test_230_expr_with_null.R

In sqlq: 'SQL' Query Builder

testthat::context("Expressions involving NULL")

testthat::test_that("We can test if a field is NULL or NOT NULL", {
  testthat::expect_equal(ExprIsNull$new(ExprField$new("id"))$toString(),
                         "(id IS NULL)")
  testthat::expect_equal(ExprIsNotNull$new(ExprField$new("id"))$toString(),
                         "(id IS NOT NULL)")
})