def test_fields_datetime_on(mock_datetime_field): assert (select(mock_datetime_field("test_dt").on( "2019-12-24 02:03:04")).sysparms == "test_dtON2019-12-24 02:03:04")
def test_fields_datetime_until(mock_datetime_field): assert (select( mock_datetime_field("test_dt").until("2019-12-24 02:03:04")).sysparms == "test_dt<=2019-12-24 02:03:04")
def test_fields_datetime_before(mock_datetime_field): assert (select( mock_datetime_field("test_dt").before("2019-12-24 02:03:04")).sysparms == "test_dt<2019-12-24 02:03:04")
def test_fields_datetime_between(mock_datetime_field): assert (select( mock_datetime_field("test_dt").between("2018-12-24 02:03:04", "2019-12-24 02:03:04")).sysparms == "test_dtBETWEEN2018-12-24 02:03:04@2019-12-24 02:03:04")
def test_fields_string_query_not_equals(mock_stringmap_field): assert (select( mock_stringmap_field("test_str").not_equals( "Network storage is unavailable")).sysparms == "test_str!=Network storage is unavailable")
def test_fields_datetime_as_of(mock_datetime_field): assert (select( mock_datetime_field("test_dt").as_of("2019-12-24 02:03:04")).sysparms == "test_dt>=2019-12-24 02:03:04")
def test_fields_string_query_less_or_equals(mock_stringmap_field): assert (select(mock_stringmap_field("test_str").less_or_equals( "s")).sysparms == "test_str<=s")
def test_fields_string_query_not_contains(mock_stringmap_field): assert (select(mock_stringmap_field("test_str").not_contains( "SAP")).sysparms == "test_str!*SAP")
def test_fields_string_query_greater_or_equals(mock_stringmap_field): assert (select(mock_stringmap_field("test_str").greater_or_equals( "s")).sysparms == "test_str>=s")
def test_fields_string_query_equals(mock_stringmap_field): assert (select( mock_stringmap_field("test_str") == "test").sysparms == "test_str=test" ) assert (select(mock_stringmap_field("test_str").equals("test")).sysparms == "test_str=test")
def test_fields_string_query_ends_with(mock_stringmap_field): assert (select(mock_stringmap_field("test_str").ends_with( "outage")).sysparms == "test_strENDSWITHoutage")
def test_fields_string_query_between(mock_stringmap_field): assert (select(mock_stringmap_field("test_str").between( "q", "t")).sysparms == "test_strBETWEENq@t")
def test_fields_boolean_select_true(mock_boolean_field): assert (select( mock_boolean_field("test_bool").is_true()).sysparms == "test_bool=true" )