Esempio n. 1
0
def get_stories(projectIds):
    session = connect()

    stories = {}
    querystring = '('
    for projId in projectIds:
        if len(querystring) > 1:
            querystring += ' or '
        if len(projectIds) > 1:
            querystring += '('
        querystring += 'Project = https://' + settings.RALLY_SERVER + '/slm/webservice/' + settings.RALLY_REST_VERSION + '/project/' + projId
        if len(projectIds) > 1:
            querystring += ')'
    querystring += ')'

    print 'QueryString is ' + querystring

    start = 1
    pagesize = 200
    lastPage = False
    while not (lastPage):
        url = 'https://' + settings.RALLY_SERVER + '/slm/webservice/' + settings.RALLY_REST_VERSION + '/hierarchicalrequirement.js?query=' + urllib.quote(
            querystring) + '&fetch=true&start=' + str(
                start) + '&pagesize=' + str(pagesize)

        print 'Fetching url ' + url
        resp = session.get(url)
        print 'Got response ' + str(resp.status_code)
        if resp.status_code != 200:
            raise Exception('Error returned from Rally: ' + resp.text)

        queryresult = json.loads(resp.text)

        for result in queryresult['QueryResult']['Results']:
            story = Story()
            story.rally_id = result['FormattedID']
            story.name = result['Name']
            if result['Iteration']:
                story.sprint = result['Iteration']['_refObjectName']
            stories[story.rally_id] = story

        print 'results: ' + str(
            queryresult['QueryResult']['TotalResultCount']) + ' start ' + str(
                start) + ' for pagesize ' + str(pagesize)
        if queryresult['QueryResult']['TotalResultCount'] <= start + pagesize:
            lastPage = True

        start += pagesize

    return stories
def get_stories(projectIds):
    session = connect()

    stories = {}
    querystring = '('
    for projId in projectIds:
        if len(querystring) > 1:
            querystring += ' or '
        if len(projectIds) > 1:
            querystring += '('
        querystring += 'Project = https://' + settings.RALLY_SERVER + '/slm/webservice/' + settings.RALLY_REST_VERSION + '/project/' + projId
        if len(projectIds) > 1:
            querystring += ')'
    querystring += ')'
    
    print 'QueryString is ' + querystring
    
    start = 1
    pagesize = 200
    lastPage = False
    while not(lastPage):
        url = 'https://' + settings.RALLY_SERVER + '/slm/webservice/' + settings.RALLY_REST_VERSION + '/hierarchicalrequirement.js?query=' + urllib.quote(querystring) + '&fetch=true&start=' + str(start) + '&pagesize=' + str(pagesize)

        print 'Fetching url ' + url
        resp = session.get(url)
        print 'Got response ' + str(resp.status_code)
        if resp.status_code != 200:
            raise Exception('Error returned from Rally: ' + resp.text)
            
        queryresult = json.loads(resp.text)

        for result in queryresult['QueryResult']['Results']:
            story = Story()
            story.rally_id = result['FormattedID']
            story.name = result['Name']
            if result['Iteration']:
                story.sprint = result['Iteration']['_refObjectName']
            stories[story.rally_id] = story
        
        print 'results: ' + str(queryresult['QueryResult']['TotalResultCount']) + ' start ' + str(start) + ' for pagesize ' + str(pagesize)
        if queryresult['QueryResult']['TotalResultCount'] <= start + pagesize:
            lastPage = True

        start += pagesize
    
    return stories
def get_stories(projectIds):
    stories = {}
    start = 1
    pagesize = 200
    for projId in projectIds:
        print 'project'
        lastPage = False
        page = start
        while not (lastPage):
            storyurl = agileurl + apiurl + 'projects/' + projId + '/stories?' + get_page_query_params(
                page, pagesize)
            logger.debug('Retrieving Stories from URL: ' + storyurl)
            print storyurl
            response = requests.get(storyurl, headers=rest_header)
            processed_response = response.json()
            story_list = processed_response[u'items']
            count = len(story_list)  #processed_response[u'totalItems']
            print 'count %d' % count

            for result in story_list:
                #print result
                phase = result[u'phase']
                ignorestates = [
                    u'Backlog', u'Ready', u'Archive',
                    u'Release Candidate / Production'
                ]
                if not phase[u'name'] in ignorestates:
                    story = Story()
                    story.rally_id = result[u'id']
                    story.name = result[u'text'][0:100]
                    story.sprint = result[u'text'][0:3]
                    story.url = agileurl + 'project/' + projId + '/story/%d' % result[
                        u'id']
                    try:
                        story.sprint = '%s - %s' % (projId,
                                                    result[u'deadline'])
                        #story.release_date = result[u'deadline']
                    except:
                        story.sprint = '%s' % projId
                        logger.debug('no deadline for story %d' %
                                     story.rally_id)
                    stories[story.rally_id] = story

            if count == 0:
                lastPage = True
            page += 1

    return stories
Esempio n. 4
0
def get_stories(projectIds):
    stories = {}
    start = 1
    pagesize = 200
    for projId in projectIds:
        print 'project'
        lastPage = False
        page = start
        while not (lastPage):
            storyurl = agileurl + apiurl + 'projects/' + projId + '/stories?' + get_page_query_params(
                page, pagesize)
            logger.debug('Retrieving Stories from URL: ' + storyurl)
            print storyurl
            response = requests.get(storyurl, headers=rest_header)
            processed_response = response.json()
            story_list = processed_response[u'items']
            count = len(story_list)  #processed_response[u'totalItems']
            print 'count %d' % count

            for result in story_list:
                #print result
                phase = result[u'phase']
                ignorestates = [u'Backlog']
                if not phase[u'name'] in ignorestates:
                    story = Story()
                    story.rally_id = result[u'id']
                    story.name = result[u'text'][0:100]
                    story.sprint = result[u'text'][0:3]
                    story.url = agileurl + 'project/' + projId + '/story/%d' % result[
                        u'id']
                    project = result[u'project']
                    project_name = project[u'name']
                    projshort_name = ''
                    try:
                        projshort_name = (re.search(r'\(.*?\)',
                                                    project_name)).group()
                    except:
                        #expected the project name to have a short name in ()
                        #this will cut the name down to 10 characters and append ERRNOPAREN
                        projshort_name = '%s-%s' % (project_name[0:10],
                                                    '(ERRNOPAREN)')
                    story.sprint = '%s - %s' % (projId, projshort_name)
                    storykey = '%s-%s' % (story.rally_id, story.sprint)
                    #print 'generated key for stories list - %s' % storykey
                    stories[storykey] = story

            if count == 0:
                lastPage = True
            page += 1

    return stories
def get_stories(projectIds):
    stories = {}
    start = 1
    pagesize = 200
    for projId in projectIds:
        print 'project'
        lastPage = False
        page = start
        while not(lastPage):
            storyurl = agileurl+apiurl+'projects/'+ projId +'/stories?'+ get_page_query_params(page, pagesize)
            logger.debug('Retrieving Stories from URL: '+storyurl)
            print storyurl
            response = requests.get(storyurl, headers=rest_header)
            processed_response = response.json()
            story_list = processed_response[u'items']
            count = len(story_list) #processed_response[u'totalItems']
            print 'count %d'%count
            
            for result in story_list:
                #print result
                phase = result[u'phase']
                ignorestates = [u'Backlog']
                if not phase[u'name'] in ignorestates:
                    story = Story()
                    story.rally_id = result[u'id']
                    story.name = result[u'text'][0:100]
                    story.sprint = result[u'text'][0:3]
                    story.url = agileurl+'project/'+ projId +'/story/%d'%result[u'id']
                    project = result[u'project']
                    project_name = project[u'name']
                    projshort_name = ''
                    try:
                        projshort_name = (re.search( r'\(.*?\)', project_name)).group()
                    except:
                        #expected the project name to have a short name in ()
                        #this will cut the name down to 10 characters and append ERRNOPAREN
                        projshort_name = '%s-%s' % (project_name[0:10],'(ERRNOPAREN)')
                    story.sprint = '%s - %s' % (projId, projshort_name)
                    storykey = '%s-%s' % (story.rally_id, story.sprint)
                    #print 'generated key for stories list - %s' % storykey
                    stories[storykey] = story
                    
            if count == 0:
                lastPage = True
            page += 1
            
    return stories
def get_stories(projectIds):
    stories = {}
    start = 1
    pagesize = 200
    for projId in projectIds:
        print 'project'
        lastPage = False
        page = start
        while not(lastPage):
            storyurl = agileurl+apiurl+'projects/'+ projId +'/stories?'+ get_page_query_params(page, pagesize)
            logger.debug('Retrieving Stories from URL: '+storyurl)
            print storyurl
            response = requests.get(storyurl, headers=rest_header)
            processed_response = response.json()
            story_list = processed_response[u'items']
            count = len(story_list) #processed_response[u'totalItems']
            print 'count %d'%count
            
            for result in story_list:
                #print result
                phase = result[u'phase']
                ignorestates = [u'Backlog', u'Ready', u'Archive',  u'Release Candidate / Production']
                if not phase[u'name'] in ignorestates:
                    story = Story()
                    story.rally_id = result[u'id']
                    story.name = result[u'text'][0:100]
                    story.sprint = result[u'text'][0:3]
                    story.url = agileurl+'project/'+ projId +'/story/%d'%result[u'id']
                    try:
                        story.sprint = '%s - %s' % (projId, result[u'deadline'])
                        #story.release_date = result[u'deadline']
                    except:
                        story.sprint = '%s'%projId
                        logger.debug('no deadline for story %d'%story.rally_id)
                    stories[story.rally_id] = story
                    
            if count == 0:
                lastPage = True
            page += 1
            
    return stories
Esempio n. 7
0
def addtostory(request):

    log = logging.getLogger("user")

    results = {"success": False}

    if request.method == u"GET":
        story = None
        try:
            storyId = request.GET["storyId"]
            if storyId == "null":
                storyId = ""
            storyName = request.GET["storyName"]
            storyRallyId = request.GET["storyRallyId"]
            storyURL = request.GET["storyURL"]

            if len(storyId) > 0 or len(storyRallyId) > 0:

                if len(storyId) > 0:
                    try:
                        story = Story.objects.get(id=storyId)
                    except ObjectDoesNotExist:
                        pass

                if not story and len(storyRallyId) > 0:
                    try:
                        story = Story.objects.get(rally_id=storyRallyId)
                    except ObjectDoesNotExist:
                        pass

                if not story:
                    story = Story()
                    if len(storyRallyId) > 0:
                        story.rally_id = storyRallyId
                        story.url = "https://rally1.rallydev.com/slm/detail/" + story.rally_id
                    if len(storyURL) > 0:
                        story.url = storyURL

                if len(storyName) > 0:
                    story.name = storyName

                story.save()

            objectIds = request.GET.getlist("itemid")

            objects = DeployableObject.objects.filter(id__in=objectIds)
            for object in objects:
                if story:
                    object.pending_stories.add(story)
                    object.release_status = "p"
                object.save()

            transIds = request.GET.getlist("transid")

            translations = DeployableTranslation.objects.filter(id__in=transIds)
            for translation in translations:
                if story:
                    translation.pending_stories.add(story)
                    translation.release_status = "p"
                translation.save()

            results = {"success": True}
        except Exception as ex:
            tb = traceback.format_exc()
            results = {"success": False, "error": "ERROR: " + tb}

    json = simplejson.dumps(results)
    return HttpResponse(json, mimetype="application/json")
Esempio n. 8
0
def addtostory(request):

    log = logging.getLogger('user')

    results = {'success':False}

    if request.method == u'GET':
        story = None
        try:
            storyId = request.GET['storyId']
            if (storyId == 'null'):
                storyId = ''
            storyName = request.GET['storyName']
            storyRallyId = request.GET['storyRallyId']
            storyURL = request.GET['storyURL']

            if len(storyId) > 0 or len(storyRallyId) > 0:

                if len(storyId) > 0:
                    try:
                        story = Story.objects.get(id=storyId)
                    except ObjectDoesNotExist:
                        pass

                if not story and len(storyRallyId) > 0:
                    try:
                        story = Story.objects.get(rally_id=storyRallyId)
                    except ObjectDoesNotExist:
                        pass

                if not story:
                    story = Story()
                    if len(storyRallyId) > 0:
                        story.rally_id = storyRallyId
                        story.url = "https://rally1.rallydev.com/slm/detail/" + story.rally_id
                    if len(storyURL) > 0:
                        story.url = storyURL

                if len(storyName) > 0:
                    story.name = storyName
                    
                story.save()
                
            objectIds = request.GET.getlist('itemid');

            objects = DeployableObject.objects.filter(id__in=objectIds)
            for object in objects:
                if story:
                    object.pending_stories.add(story)
                    object.release_status = 'p'
                object.save()

            transIds = request.GET.getlist('transid');

            translations = DeployableTranslation.objects.filter(id__in=transIds)
            for translation in translations:
                if story:
                    translation.pending_stories.add(story)
                    translation.release_status = 'p'
                translation.save()

            results = {'success':True}
        except Exception as ex:
            tb = traceback.format_exc()
            results = {'success':False, 'error':'ERROR: ' + tb}

    json = simplejson.dumps(results)
    return HttpResponse(json, mimetype='application/json')
Esempio n. 9
0
def get_stories(projectIds):
    urllib2 = connect()

    stories = {}
    for projId in projectIds:
        url = 'https://' + settings.RALLY_SERVER + '/slm/webservice/' + settings.RALLY_REST_VERSION + '/project/' + projId + '.js'
        logger.debug('Fetching url ' + url)
        pcprojjson = urllib2.urlopen(url).read()
        pcproj = json.loads(pcprojjson)
        logger.debug('Processing project ' + pcproj['Project']['_refObjectName'])
        pcproj['Project']['Iterations']

        sprint_data = {}        
        sprint_names = {}        
        sprints = []
        
        for iteration in pcproj['Project']['Iterations']:
            sprdet = urllib2.urlopen(iteration['_ref']).read()
            sprint = json.loads(sprdet)
            # 2010-07-12T00:00:00.000Z
            sprintName = iteration['_refObjectName']
            startDate = sprint['Iteration']['StartDate'][0:10]
            logger.debug('Looking at sprint ' + sprintName)
            logger.debug('Date is ' + startDate)
            sprint_data[startDate + '_' + sprintName] = sprint
            sprint_names[startDate + '_' + sprintName] = sprintName
            sprints.append(startDate + '_' + sprintName)
            
        sprints.sort()
        for sprint_key in sprints:
            logger.debug('Processing ' + sprint_key)
            sprint = sprint_data[sprint_key]
            sprintName = sprint_names[sprint_key]
            
            hist = urllib2.urlopen(sprint['Iteration']['RevisionHistory']['_ref']).read()
            history = json.loads(hist)
        
            revisions = list()
            for rev in history['RevisionHistory']['Revisions']:
                revisions.append(rev)
        
            revisions.reverse()
            for rev in revisions:
                if rev['Description'].startswith('Scheduled ') or rev['Description'].startswith('Unscheduled '):
                    ral_id = rev['Description'].split('[')[1].split(']')[0].partition(':')[0]
                    ral_name = rev['Description'][rev['Description'].find(':') + 2:150]
                    if ral_name.endswith(']'):
                        ral_name = ral_name[0:ral_name.rfind(']')]
                    if rev['Description'].startswith('Scheduled '):
                        logger.debug('Add [' + ral_id + '] ' + ral_name)
                        if ral_id not in stories:
                            story = Story()
                            story.rally_id = ral_id
                            story.name = ral_name
                            story.sprint = sprintName
                            stories[ral_id] = story
                        else:
                            story = stories[ral_id]
                            story.sprint = sprintName
                    if rev['Description'].startswith('Unscheduled '):
                        logger.debug('Remove [' + ral_id + '] ' + ral_name)
                        if ral_id in stories:
                            story = stories[ral_id]
                            if story.sprint == sprintName:
                                story.sprint = ''

    return stories
Esempio n. 10
0
def addtostory(request):

    log = logging.getLogger('user')

    results = {'success':False}

    if request.method == u'GET':
        story = None
        try:
            storyId = request.GET['storyId']
            if (storyId == 'null'):
                storyId = ''
            storyName = request.GET['storyName']
            storyRallyId = request.GET['storyRallyId']
            storyURL = request.GET['storyURL']

            if len(storyId) > 0 or len(storyRallyId) > 0:

                if len(storyId) > 0:
                    try:
                        story = Story.objects.get(id=storyId)
                    except ObjectDoesNotExist:
                        pass

                if not story and len(storyRallyId) > 0:
                    try:
                        story = Story.objects.get(rally_id=storyRallyId)
                    except ObjectDoesNotExist:
                        pass

                if not story:
                    story = Story()
                    if len(storyRallyId) > 0:
                        story.rally_id = storyRallyId
                        story.url = "https://rally1.rallydev.com/slm/detail/" + story.rally_id
                    if len(storyURL) > 0:
                        story.url = storyURL

                if len(storyName) > 0:
                    story.name = storyName
                    
                story.save()
                
            objectIds = request.GET.getlist('itemid');

            objects = DeployableObject.objects.filter(id__in=objectIds)
            for object in objects:
                if story:
                    object.pending_stories.add(story)
                    object.release_status = 'p'
                object.save()

            transIds = request.GET.getlist('transid');

            translations = DeployableTranslation.objects.filter(id__in=transIds)
            for translation in translations:
                if story:
                    translation.pending_stories.add(story)
                    translation.release_status = 'p'
                translation.save()

            results = {'success':True}
        except Exception as ex:
            tb = traceback.format_exc()
            results = {'success':False, 'error':'ERROR: ' + tb}

    json = simplejson.dumps(results)
    return HttpResponse(json, mimetype='application/json')
Esempio n. 11
0
def get_stories(projectIds):
    urllib2 = connect()

    stories = {}
    for projId in projectIds:
        url = 'https://' + settings.RALLY_SERVER + '/slm/webservice/' + settings.RALLY_REST_VERSION + '/project/' + projId + '.js'
        logger.debug('Fetching url ' + url)
        pcprojjson = urllib2.urlopen(url).read()
        pcproj = json.loads(pcprojjson)
        logger.debug('Processing project ' +
                     pcproj['Project']['_refObjectName'])
        pcproj['Project']['Iterations']

        sprint_data = {}
        sprint_names = {}
        sprints = []

        for iteration in pcproj['Project']['Iterations']:
            sprdet = urllib2.urlopen(iteration['_ref']).read()
            sprint = json.loads(sprdet)
            # 2010-07-12T00:00:00.000Z
            sprintName = iteration['_refObjectName']
            startDate = sprint['Iteration']['StartDate'][0:10]
            logger.debug('Looking at sprint ' + sprintName)
            logger.debug('Date is ' + startDate)
            sprint_data[startDate + '_' + sprintName] = sprint
            sprint_names[startDate + '_' + sprintName] = sprintName
            sprints.append(startDate + '_' + sprintName)

        sprints.sort()
        for sprint_key in sprints:
            logger.debug('Processing ' + sprint_key)
            sprint = sprint_data[sprint_key]
            sprintName = sprint_names[sprint_key]

            hist = urllib2.urlopen(
                sprint['Iteration']['RevisionHistory']['_ref']).read()
            history = json.loads(hist)

            revisions = list()
            for rev in history['RevisionHistory']['Revisions']:
                revisions.append(rev)

            revisions.reverse()
            for rev in revisions:
                if rev['Description'].startswith('Scheduled ') or rev[
                        'Description'].startswith('Unscheduled '):
                    ral_id = rev['Description'].split('[')[1].split(
                        ']')[0].partition(':')[0]
                    ral_name = rev['Description'][rev['Description'].
                                                  find(':') + 2:150]
                    if ral_name.endswith(']'):
                        ral_name = ral_name[0:ral_name.rfind(']')]
                    if rev['Description'].startswith('Scheduled '):
                        logger.debug('Add [' + ral_id + '] ' + ral_name)
                        if ral_id not in stories:
                            story = Story()
                            story.rally_id = ral_id
                            story.name = ral_name
                            story.sprint = sprintName
                            stories[ral_id] = story
                        else:
                            story = stories[ral_id]
                            story.sprint = sprintName
                    if rev['Description'].startswith('Unscheduled '):
                        logger.debug('Remove [' + ral_id + '] ' + ral_name)
                        if ral_id in stories:
                            story = stories[ral_id]
                            if story.sprint == sprintName:
                                story.sprint = ''

    return stories