Python MySQLDictionaryCursor示例

示例#1

文件： cursorTest.py 项目： glenntnorton/y47

class TestMySQLDictionaryCursor(unittest.TestCase):
    def setUp(self):
        self.connection = MySQLConnection(host='localhost', user='******', 
                                passwd='y47test', database='y47test').connect

    # connection from __init__
    def testInitConnectionIsNone(self):
        self.cursor = MySQLDictionaryCursor(connection=None)
        self.assertEqual(self.cursor.connection, None)

    def testInitConnectionIsNotNone(self):
        self.cursor = MySQLDictionaryCursor(connection=self.connection)
        self.assertTrue(self.cursor.connection is not None)

    def testInitConnectionIsCorrectType(self):
        self.cursor = MySQLDictionaryCursor(connection=self.connection)
        self.assertTrue('_mysql.connection' in repr(self.cursor.connection))

    def testInitConnectionIsIncorrectType(self):
        self.cursor = MySQLDictionaryCursor(connection=self.connection)
        self.assertTrue('foo' not in repr(self.cursor.connection))


    # execute
    def testExecuteConnectionNotSet(self):
        self.cursor = MySQLDictionaryCursor()
        with self.assertRaises(ValueError):
            self.cursor.execute("SELECT * FROM test")

    def testConnectId(self):
        self.cursor = MySQLDictionaryCursor(connection=self.connection)
        results = self.cursor.execute("SELECT * FROM test WHERE name=%s",
                                    ('Glenn',))
        self.assertEqual(results[0]['id'], 1)

    def testConnectName(self):
        self.cursor = MySQLDictionaryCursor(connection=self.connection)
        results = self.cursor.execute("SELECT * FROM test WHERE name=%s",
                                    ('Glenn',))
        self.assertEqual(results[0]['name'], 'Glenn')


    def tearDown(self):
        self.connection = None
        del self.connection

示例#2

文件： cursorTest.py 项目： glenntnorton/y47

 def testConnectName(self):
     self.cursor = MySQLDictionaryCursor(connection=self.connection)
     results = self.cursor.execute("SELECT * FROM test WHERE name=%s",
                                 ('Glenn',))
     self.assertEqual(results[0]['name'], 'Glenn')

示例#3

文件： cursorTest.py 项目： glenntnorton/y47

 def testExecuteConnectionNotSet(self):
     self.cursor = MySQLDictionaryCursor()
     with self.assertRaises(ValueError):
         self.cursor.execute("SELECT * FROM test")

示例#4

文件： cursorTest.py 项目： glenntnorton/y47

 def testInitConnectionIsIncorrectType(self):
     self.cursor = MySQLDictionaryCursor(connection=self.connection)
     self.assertTrue('foo' not in repr(self.cursor.connection))

示例#5

文件： cursorTest.py 项目： glenntnorton/y47

 def testInitConnectionIsCorrectType(self):
     self.cursor = MySQLDictionaryCursor(connection=self.connection)
     self.assertTrue('_mysql.connection' in repr(self.cursor.connection))

示例#6

文件： cursorTest.py 项目： glenntnorton/y47

 def testInitConnectionIsNotNone(self):
     self.cursor = MySQLDictionaryCursor(connection=self.connection)
     self.assertTrue(self.cursor.connection is not None)

示例#7

文件： cursorTest.py 项目： glenntnorton/y47

 def testInitConnectionIsNone(self):
     self.cursor = MySQLDictionaryCursor(connection=None)
     self.assertEqual(self.cursor.connection, None)