def test_with_unicode():
assert isinstance(roundtrip_value(cu, 'txt', u'\xe6\xf8\xe5'), unicode)
def test_utf8():
cnx.encoding = 'utf-8'
roundtrip_value(cu, 'x', 'abc')
roundtrip_value(cu, 'x', u'\xef')
def test_with_str():
assert isinstance(roundtrip_value(cu, 'txt', 'abc'), unicode)
def test_decimal():
assert isinstance(roundtrip_value(cu, 'y', Decimal('1.5')), Decimal)
def test_latin1():
cnx.encoding = 'latin-1'
roundtrip_value(cu, 'x', 'abc')
roundtrip_value(cu, 'x', u'\xef')
def test_bigint():
assert isinstance(roundtrip_value(cu, 'w', 42), (int, long))
assert isinstance(roundtrip_value(cu, 'w', 42L), (int, long))
assert isinstance(roundtrip_value(cu, 'w', 2**31), (int, long))
def test_real():
assert isinstance(roundtrip_value(cu, 'x', 1.5), float)
def test_integer():
assert isinstance(roundtrip_value(cu, 'z', 42), int)
assert isinstance(roundtrip_value(cu, 'z', 42L), int)
assert isinstance(roundtrip_value(cu, 'z', 2**31-1), int)
def test_float_into_integer():
assert isinstance(roundtrip_value(cu, 'z', 42.0), int)
def test_roundtrip_interval():
roundtrip_value(cu, 'z', interval())
roundtrip_value(cu, 'z', interval(seconds=1))
roundtrip_value(cu, 'z', interval(years=1, months=2, days=3))
def test_without_string_typecast():
del cnx.typecasts['string']
assert isinstance(roundtrip_value(cu, 'txt', 'abc'), str)
def test_Date():
roundtrip_value(cu, 'y', dbapi.Date(1979, 7, 7))
def test_precise_Time():
ts = dbapi.Time(22, 00, 12.33)
assert str(ts) == '22:00:12.330000', str(ts)
roundtrip_value(cu, 'w', ts)
def test_precise_Timestamp():
ts = dbapi.Timestamp(1979, 7, 7, 22, 00, 12.33)
assert str(ts) == '1979-07-07 22:00:12.330000', str(ts)
roundtrip_value(cu, 'x', ts)
def test_Timestamp():
roundtrip_value(cu, 'x', dbapi.Timestamp(1979, 7, 7, 22, 00, 00))
def test_null():
roundtrip_value(cu, 'x', None)
roundtrip_value(cu, 'y', None)
