def test_insert(self):
p = MySQLInsertProtocol()
key, value = p.read(
"INSERT INTO `user` VALUES"
" (1,'David Marin',25.25,0xC0DE,NULL);")
self.assertEqual(
(key, value),
(u'user', [1, u'David Marin', 25.25, '\xc0\xde', None]))
def test_decimal(self):
p = MySQLInsertProtocol(decimal=True)
key, value = p.read("INSERT INTO `score` (1, 1.0, 1.25)")
self.assertEqual(key, 'score')
self.assertEqual(value, [1, Decimal('1.0'), Decimal('1.25')])
self.assertEqual([type(x) for x in value], [int, Decimal, Decimal])
def test_int_vs_float(self):
p = MySQLInsertProtocol()
key, value = p.read("INSERT INTO `score` (1, 1.0, 1.25)")
self.assertEqual(key, 'score')
self.assertEqual(value, [1, 1.0, 1.25])
self.assertEqual([type(x) for x in value], [int, float, float])
