def test_deltaTime_good_real_object( ): from datetime import timedelta sieve = filters.Filter() myDeltaTime = timedelta( days = 13 ) answer = sieve.decode_field( 'test_table', 'intervalName', 13.8 ) assert answer == myDeltaTime # Note the truncation
def test_db_id_bad_type( ): from datetime import timedelta sieve = filters.Filter() myDeltaTime = timedelta( days = 13 ) with pytest.raises( ValueError ): answer = sieve.decode_field( 'test_table', 'DbIdName', myDeltaTime )
def test_app_id_bad_type( ): from datetime import timedelta sieve = filters.Filter() myDeltaTime = timedelta( days = 13 ) answer = sieve.decode_field( 'test_table', 'idName', myDeltaTime ) assert answer == None
def test_deltaTime_good_string_object( ): from datetime import timedelta sieve = filters.Filter() myDeltaTime = timedelta( days = 13 ) answer = sieve.decode_field( 'test_table', 'intervalName', '13' ) assert answer == myDeltaTime
def test_string_corrupt_2(): sieve = filters.Filter( ) myBadString = chr( 27 ) + chr( 97 ) answer = sieve.decode_field( 'test_table', 'stringName', myBadString ) assert type( answer ) == str assert answer == 'Corrupt string #2'
def test_deltaTime_deltatime_object( ): from datetime import timedelta sieve = filters.Filter() myDeltaTime = timedelta( days = 13 ) passedDeltaTime = timedelta( days = 13, hours = 4 ) # Note the truncation answer = sieve.decode_field( 'test_table', 'intervalName', passedDeltaTime ) assert answer == myDeltaTime
def test_date_bad_date_string(): sieve = filters.Filter() answer = sieve.decode_field( 'test_table', 'goodFieldName', '1971-14-14' ) assert answer == None
def test_date_bad_date_type_2( ): sieve = filters.Filter() myDateTime = datetime.strptime( '1971-11-11', '%Y-%m-%d' ) answer = sieve.decode_field( 'test_table', 'goodFieldName', myDateTime ) assert answer == None
def test_gender_goodSex_5( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'genderName', ' dAme' ) assert answer == 'female'
def test_posReal_BadReal_3( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'posRealName', 0.0 ) assert answer == None
def test_posReal_goodString( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'posRealName', '8' ) assert answer == 8.0 assert type( answer ) == float
def test_posReal_goodFloat_1( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'posRealName', 5.5123 ) assert answer == 5.5123
def test_string_good_province_1( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'provinceName', 'ON' ) assert answer == '35'
def test_string_good_string_6( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'stringName', 42 ) assert type( answer ) == str assert answer == '42'
def test_string_good_string_5( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'stringName', bytes( 'accepté', 'utf-8' ) ) assert type( answer ) == str assert answer == 'accepté'
def test_boolean_good_True_Int( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'booleanName', 1 ) assert answer == True
def test_boolean_good_False_bool( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'booleanName', False ) assert answer == False
def test_string_good_province_2( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'provinceName', 'Newfoundland and Labrador' ) assert answer == '10'
def test_date_empty_string( ): sieve = filters.Filter() answer = sieve.decode_field( 'test_table', 'goodFieldName', '' ) assert answer == None
def test_string_bad_province_2( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'provinceName', None ) assert answer == None
def test_posReal_Negativity( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'posRealName', '-8' ) assert answer == None
def test_wrong_no_args( ): sieve = filters.Filter( ) with pytest.raises( TypeError ): answer = sieve.decode_field( "test_table", "goodFieldName" )
def test_date_bad_date_type_1( ): sieve = filters.Filter() answer = sieve.decode_field( 'test_table', 'goodFieldName', 7 ) assert answer == None
def test_date_null( ): sieve = filters.Filter() answer = sieve.decode_field( 'test_table', 'goodFieldName', None ) assert answer == None
def test_gender_badSex_2( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'genderName', 1.069 ) assert answer == None
def test_boolean_bad_byte_2( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'booleanName', b'' ) assert answer == None
def test_datetime_null_date_string(): sieve = filters.Filter() answer = sieve.decode_field( 'test_table', 'goodFieldName', '0000-00-00' ) assert answer == None
def test_boolean_bad_type_1( ): sieve = filters.Filter( ) answer = sieve.decode_field( 'test_table', 'booleanName', None ) assert answer == None
def test_date_good_date_object( ): sieve = filters.Filter() myDateTime = datetime.strptime( '1971-11-11', '%Y-%m-%d' ) myDate = myDateTime.date() answer = sieve.decode_field( 'test_table', 'goodFieldName', myDate ) assert answer == myDate
def test_boolean_bad_type_2( ): sieve = filters.Filter( ) myDateTime = datetime.strptime( '1971-11-11 12:12:13', '%Y-%m-%d %H:%M:%S' ) with pytest.raises( NotImplementedError ): answer = sieve.decode_field( 'test_table', 'booleanName', myDateTime )