Using python to query IBM Rational Change

Question

I would like to get a list of all change requests that exist in a IBM Rational Change (CM) database, actually I would like to get a list of

• Change request ID
• Change request Synopsis
• Change request Description

I'm familiar with python (2.7) to do things like get data from traditional SQL databases, I am unclear how I can get data from IBM Rational Change (CM). I am reading about Open Services for Lifecycle Collaboration But I am struggling to understand how to make use of it. Is there a python library that implements OSLC? Is there a python friendly way to interact with IBM Rational Change (CM)

Are there python friendly APIs that work well with IBM Rational Change (CM)

or alternatively a python friendly tutorial on how OSLC and Python can work together to query IBM Rational Change (CM)

Answer 1

AFAIK there is no python library to access CM. The solution worked pretty well for me was to write wrappers to exec ccm commands and then parse their output.

If you need just these 3 fields then probably it would be simpler to run ccm commands from the shell and store results somewhere.

1. Get all IDs with their Synopses (can take some time):

   ccm query -u -f "%name-%version:%type:%instance\t%change_request_synopsis" -t problem

2. Repeat the next command for every problemID obtained in the previous query to get descriptions:

   ccm attribute -show problem_description problemID