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])