def test_boolean_roundtrip(self):
bool_table = Table(
'mysql_bool',
self.metadata,
Column('b1', BOOLEAN),
Column('b2', Boolean),
Column('b3', mysql.MSTinyInteger(1)),
Column('b4', mysql.MSTinyInteger(1, unsigned=True)),
Column('b5', mysql.MSTinyInteger),
)
self.metadata.create_all()
table = bool_table
def roundtrip(store, expected=None):
expected = expected or store
table.insert(store).execute()
row = table.select().execute().first()
self.assert_(list(row) == expected)
for i, val in enumerate(expected):
if isinstance(val, bool):
self.assert_(val is row[i])
table.delete().execute()
roundtrip([None, None, None, None, None])
roundtrip([True, True, 1, 1, 1])
roundtrip([False, False, 0, 0, 0])
roundtrip([True, True, True, True, True], [True, True, 1,
1, 1])
roundtrip([False, False, 0, 0, 0], [False, False, 0, 0, 0])
meta2 = MetaData(testing.db)
table = Table('mysql_bool', meta2, autoload=True)
eq_(colspec(table.c.b3), 'b3 TINYINT(1)')
eq_(colspec(table.c.b4), 'b4 TINYINT(1) UNSIGNED')
meta2 = MetaData(testing.db)
table = Table(
'mysql_bool',
meta2,
Column('b1', BOOLEAN),
Column('b2', Boolean),
Column('b3', BOOLEAN),
Column('b4', BOOLEAN),
autoload=True,
)
eq_(colspec(table.c.b3), 'b3 BOOL')
eq_(colspec(table.c.b4), 'b4 BOOL')
roundtrip([None, None, None, None, None])
roundtrip([True, True, 1, 1, 1], [True, True, True, True,
1])
roundtrip([False, False, 0, 0, 0], [False, False, False,
False, 0])
roundtrip([True, True, True, True, True], [True, True,
True, True, 1])
roundtrip([False, False, 0, 0, 0], [False, False, False,
False, 0])
def boolean_table(self, metadata):
bool_table = Table(
"mysql_bool",
metadata,
Column("b1", BOOLEAN),
Column("b2", Boolean),
Column("b3", mysql.MSTinyInteger(1)),
Column("b4", mysql.MSTinyInteger(1, unsigned=True)),
Column("b5", mysql.MSTinyInteger),
)
return bool_table
