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 )
