'test a fetchone() with no rows'

def test_fetch_no_result(self):

    conn = self.connections[0]
    c = conn.cursor()
    c.execute('create    table    test_nr    (b    varchar(32))')
    try:
        data = 'pymysql'
        c.execute('insert    into    test_nr    (b)    values    (%s)', (data,))
        self.assertEqual(None, c.fetchone())
    finally:
        c.execute('drop    table    test_nr')
