'Confirm support for transactions.'

@cached_property
def supports_transactions(self):

    with self.connection.cursor() as cursor:
        cursor.execute('CREATE    TABLE    ROLLBACK_TEST    (X    INT)')
        self.connection.set_autocommit(False)
        cursor.execute('INSERT    INTO    ROLLBACK_TEST    (X)    VALUES    (8)')
        self.connection.rollback()
        self.connection.set_autocommit(True)
        cursor.execute('SELECT    COUNT(X)    FROM    ROLLBACK_TEST')
        (count,) = cursor.fetchone()
        cursor.execute('DROP    TABLE    ROLLBACK_TEST')
    return (count == 0)
