def rally_projects(request): if request.method == u'GET' and request.GET.__contains__('chkProject'): pickedProjs = request.GET.getlist('chkProject') isFirst = True projectConfValue = '' for p in pickedProjs: if not isFirst: projectConfValue = projectConfValue + ';' isFirst = False projectConfValue = projectConfValue + p ConfigCache.store_config_value('rally.pickedprojects', projectConfValue) return redirect('/configs/') projects = [] if ConfigCache.get_config_value('rally.enabled') == '1': projlist = rallyintegration.get_projects(True) for project in projlist: projects.append(project) if ConfigCache.get_config_value('agilezen.enabled') == '1': projlist = agilezenintegration.get_projects(True) for project in projlist: projects.append(project) data = {'projects': projects} return render(request, 'rally_projects.html', data)
def email_results(batch, failures, runs): long_runners = UnitTestRunResult.objects.filter(test_run__in=runs).order_by('-runtime')[:5] long_runners.select_related() long_runner_classes = UnitTestRun.objects.filter(batch=batch).order_by('-runtime')[:5] long_runner_classes.select_related() try: schedule = UnitTestSchedule.objects.get(branch=batch.branch) except ObjectDoesNotExist: logger.error( 'No Schedule exists for this branch (' + batch.branch.name + '), so no way to figure out who to email') return email_host = ConfigCache.get_config_value('email.host') conn = mail.get_connection(host=email_host) from_address = ConfigCache.get_config_value('email.from') if schedule.email_only_failures and len(failures) == 0: return template = get_template('unit_test_results_email.html') c = Context({'batch': batch, 'failures': failures, 'long_runners': long_runners, 'long_runner_classes': long_runner_classes}) subject = 'Unit test results for ' + batch.branch.name.upper() + ' started at ' + str(batch.batch_time) from_email, to = from_address, schedule.results_email_address text_content = 'Please join the 21st century and get an HTML compatible email client to see the content of this email.' html_content = template.render(c) msg = EmailMultiAlternatives(subject, text_content, from_email, [to]) msg.attach_alternative(html_content, "text/html") msg.connection = conn msg.send(fail_silently=False)
def rally_projects(request): if request.method == u"GET" and request.GET.__contains__("chkProject"): pickedProjs = request.GET.getlist("chkProject") isFirst = True projectConfValue = "" for p in pickedProjs: if not isFirst: projectConfValue = projectConfValue + ";" isFirst = False projectConfValue = projectConfValue + p ConfigCache.store_config_value("rally.pickedprojects", projectConfValue) return redirect("/configs/") projects = [] if ConfigCache.get_config_value("rally.enabled") == "1": projlist = rallyintegration.get_projects(True) for project in projlist: projects.append(project) if ConfigCache.get_config_value("agilezen.enabled") == "1": projlist = agilezenintegration.get_projects(True) for project in projlist: projects.append(project) data = {"projects": projects} return render(request, "rally_projects.html", data)
def getAgentForBranch(branch, logger=None): if not logger: logger = logging.getLogger('root') user = branch.api_user password = branch.api_pass authkey = branch.api_auth if authkey is None: authkey = '' svcurl = 'https://' + branch.api_env + '.salesforce.com/services/Soap/u/' + CSBase.CS_SF_API_VERSION #branch.api_ver # print("user='******' path='%s' types=[%s] url='%s'", user, path, ' '.join(types), svcurl) partner_wsdl = 'file://' + os.path.join(CSBase.CSCONF_DIR, 'partner.wsdl') meta_wsdl = 'file://' + os.path.join(CSBase.CSCONF_DIR, 'metadata.wsdl') proxy_host = ConfigCache.get_config_value('proxy.host') proxy_port = ConfigCache.get_config_value('proxy.port') if len(proxy_host) > 0 and len(proxy_port) > 0: agent = SalesforceAgent(partner_wsdl, meta_wsdl, clientLogger=logger, proxy_host=proxy_host, proxy_port=proxy_port) else: agent = SalesforceAgent(partner_wsdl, meta_wsdl, clientLogger=logger) agent.login(user, password + authkey, server_url=svcurl) return agent
def refresh(): projectList = ConfigCache.get_config_value('rally.pickedprojects') #print 'project list: '+projectList if len(projectList) > 0: rallyStories = get_stories(projectList.split(';')) dbstories = Story.objects.filter(rally_id__in=rallyStories.keys()) dbStoryMap = {} for dbstory in dbstories: #print 'storing story %d' % int(dbstory.rally_id) dbStoryMap[int(dbstory.rally_id)] = dbstory for story in rallyStories.values(): dbstory = story if story.rally_id in dbStoryMap: #print 'match found %d' % story.rally_id logger.debug('Updating [%d]' % story.rally_id) # Override with database version if it exists dbstory = dbStoryMap[story.rally_id] dbstory.url = story.url dbstory.name = story.name dbstory.sprint = story.sprint else: #print 'no match found %d' % story.rally_id logger.debug('Creating [%d]' % story.rally_id) dbstory.sprint = story.sprint dbstory.save()
def refresh(): projectList = ConfigCache.get_config_value('rally.pickedprojects') #print 'project list: '+projectList if len(projectList) > 0: rallyStories = get_stories(projectList.split(';')) dbstories = Story.objects.filter(rally_id__in=rallyStories.keys()) dbStoryMap = {} for dbstory in dbstories: #print 'storing story %d' % int(dbstory.rally_id) dbStoryMap[int(dbstory.rally_id)] = dbstory for story in rallyStories.values(): dbstory = story if story.rally_id in dbStoryMap: #print 'match found %d' % story.rally_id logger.debug('Updating [%d]' % story.rally_id) # Override with database version if it exists dbstory = dbStoryMap[story.rally_id] dbstory.url = story.url dbstory.name = story.name dbstory.sprint = story.sprint else: #print 'no match found %d' % story.rally_id logger.debug('Creating [%d]' % story.rally_id) dbstory.sprint = story.sprint dbstory.save()
def email_results(batch, failures, runs): long_runners = UnitTestRunResult.objects.filter( test_run__in=runs).order_by('-runtime')[:5] long_runners.select_related() long_runner_classes = UnitTestRun.objects.filter( batch=batch).order_by('-runtime')[:5] long_runner_classes.select_related() try: schedule = UnitTestSchedule.objects.get(branch=batch.branch) except ObjectDoesNotExist: logger.error('No Schedule exists for this branch (' + batch.branch.name + '), so no way to figure out who to email') return email_host = ConfigCache.get_config_value('email.host') conn = mail.get_connection(host=email_host) from_address = ConfigCache.get_config_value('email.from') if schedule.email_only_failures and len(failures) == 0: return template = get_template('unit_test_results_email.html') # c = Context({'batch': batch, 'failures': failures, 'long_runners': long_runners, # 'long_runner_classes': long_runner_classes}) c = { 'batch': batch, 'failures': failures, 'long_runners': long_runners, 'long_runner_classes': long_runner_classes } subject = 'Unit test results for ' + batch.branch.name.upper( ) + ' started at ' + str(batch.batch_time) from_email, to = from_address, schedule.results_email_address text_content = 'Please join the 21st century and get an HTML compatible email client to see the content of this email.' html_content = template.render(c) msg = EmailMultiAlternatives(subject, text_content, from_email, [to]) msg.attach_alternative(html_content, "text/html") msg.connection = conn msg.send(fail_silently=False)
def getAgentForBranch(branch, logger = None): if not logger: logger = logging.getLogger('root') user = branch.api_user password = branch.api_pass authkey = branch.api_auth if authkey is None: authkey = '' svcurl = 'https://' + branch.api_env + '.salesforce.com/services/Soap/u/' + CSBase.CS_SF_API_VERSION #branch.api_ver # print("user='******' path='%s' types=[%s] url='%s'", user, path, ' '.join(types), svcurl) partner_wsdl = 'file://' + os.path.join(CSBase.CSCONF_DIR, 'partner.wsdl') meta_wsdl = 'file://' + os.path.join(CSBase.CSCONF_DIR, 'metadata.wsdl') proxy_host = ConfigCache.get_config_value('proxy.host') proxy_port = ConfigCache.get_config_value('proxy.port') if len(proxy_host) > 0 and len(proxy_port) > 0: agent = SalesforceAgent(partner_wsdl, meta_wsdl, clientLogger=logger, proxy_host=proxy_host, proxy_port=proxy_port) else: agent = SalesforceAgent(partner_wsdl, meta_wsdl, clientLogger=logger) agent.login(user, password+authkey,server_url=svcurl) return agent
def get_projects(leaves): logger.debug('Start getting projects') projurl = agileurl+apiurl+'projects' #?' #+ get_page_query_params(1, 200) logger.debug('Retrieving Projects from URL: '+projurl) rest_header['X-Zen-ApiKey'] = ConfigCache.get_config_value('agilezen.apikey') response = requests.get(projurl, headers=rest_header) project_list = {} try: project_list = (response.json())[u'items'] print_proj_tree(project_list) except: logger.debug('No Results Returned') return project_list
def get_projects(leaves): logger.debug('Start getting projects') projurl = agileurl + apiurl + 'projects' #?' #+ get_page_query_params(1, 200) logger.debug('Retrieving Projects from URL: ' + projurl) rest_header['X-Zen-ApiKey'] = ConfigCache.get_config_value( 'agilezen.apikey') response = requests.get(projurl, headers=rest_header) project_list = {} try: project_list = (response.json())[u'items'] print_proj_tree(project_list) except: logger.debug('No Results Returned') return project_list
def get_stories(projectIds): stories = {} start = 1 pagesize = 200 for projId in projectIds: 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) rest_header['X-Zen-ApiKey'] = ConfigCache.get_config_value( 'agilezen.apikey') 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'] 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
def get_stories(projectIds): stories = {} start = 1 pagesize = 200 for projId in projectIds: 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) rest_header['X-Zen-ApiKey'] = ConfigCache.get_config_value('agilezen.apikey') 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'] 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
def refresh(): projectList = ConfigCache.get_config_value('rally.pickedprojects') logger.debug('projectList:') logger.debug(projectList) if len(projectList) > 0: rallyStories = get_stories(projectList.split(';')) dbstories = Story.objects.filter(rally_id__in=rallyStories.keys()) dbStoryMap = {} for dbstory in dbstories: dbStoryMap[dbstory.rally_id] = dbstory for story in rallyStories.values(): dbstory = story if story.rally_id in dbStoryMap: #logger.debug('Updating [' + story.rally_id + ']') # Override with database version if it exists dbstory = dbStoryMap[story.rally_id] dbstory.name = story.name #else: #logger.debug('Creating [' + story.rally_id + ']') dbstory.sprint = story.sprint dbstory.save()
def refresh(): projectList = ConfigCache.get_config_value('rally.pickedprojects') logger.debug('projectList:') logger.debug(projectList) if len(projectList) > 0: rallyStories = get_stories(projectList.split(';')) dbstories = Story.objects.filter(rally_id__in=rallyStories.keys()) dbStoryMap = {} for dbstory in dbstories: dbStoryMap[dbstory.rally_id] = dbstory for story in rallyStories.values(): dbstory = story if story.rally_id in dbStoryMap: #logger.debug('Updating [' + story.rally_id + ']') # Override with database version if it exists dbstory = dbStoryMap[story.rally_id] dbstory.name = story.name #else: #logger.debug('Creating [' + story.rally_id + ']') dbstory.sprint = story.sprint dbstory.save()
def stories(request): if request.method == u'POST' and request.POST.__contains__('releaseid'): release = Release.objects.get(id=request.POST['releaseid']) if request.POST.__contains__('storyId'): ids = request.POST.getlist('storyId') sprint_name = request.POST['cboSprints'] print('sprint_name ' + sprint_name) if sprint_name != '': for story in release.stories.all(): if story.sprint == sprint_name: print('removing ' + story.name) release.stories.remove(story) else: release.stories.clear() stories = Story.objects.filter(id__in=ids) for s in stories.all(): if s not in release.stories.all(): # this print was causing a unicode issue adding a story, so commented out # print 'adding ' + s.name release.stories.add(s) release.save() return redirect('/release/' + str(release.id)) if request.method == u'GET' and request.GET.__contains__('delete'): story = Story.objects.get(id=request.GET['delete']) objects = DeployableObject.objects.filter(pending_stories=story) for object in objects: object.pending_stories.remove(story) object.save() story.delete() if request.method == u'GET' and request.GET.__contains__('refresh'): if ConfigCache.get_config_value('agilezen.enabled') == '1': agilezenintegration.refresh() if ConfigCache.get_config_value('rally.enabled') == '1': rallyintegration.refresh() releaseid = '' in_release = {} if request.method == u'GET' and request.GET.__contains__('releaseid'): releaseid = request.GET['releaseid'] if len(releaseid) > 0: release = Release.objects.get(id=request.GET['releaseid']) for story in release.stories.all(): in_release[story.id] = True sprint = '' if request.method == u'GET' and request.GET.__contains__('sprint'): sprint = request.GET['sprint'] sprintList = [] oneYear = timedelta(days=365) oneYearAgo = datetime.now() - oneYear if request.method == u'GET' and request.GET.__contains__('history'): sprints = Story.objects.values('sprint').filter( sprint__isnull=False).order_by('sprint').distinct() else: sprints = Story.objects.values('sprint').filter( sprint__isnull=False, date_added__gte=oneYearAgo).order_by('sprint').distinct() for sprintName in sprints: if len(sprintName['sprint']) > 0 and not sprintList.__contains__( sprintName['sprint']): sprintList.append(sprintName['sprint']) if request.method == u'GET' and request.GET.__contains__('history'): stories = Story.objects.all() else: stories = Story.objects.filter(date_added__gte=oneYearAgo) if len(sprint) > 0: stories = stories.filter(sprint=sprint) stories = stories.order_by('sprint', 'rally_id', 'name') # Need to cast the rally_id to prevent duplicate stories from coming over # different SQL needed for mySQL and SQLite ## MySQL compatible call if ConfigCache.get_config_value('agilezen.enabled') == '1': stories = stories.extra(select={ 'rally_id': 'CAST(rally_id AS SIGNED)' }).extra(order_by=['rally_id']) ## SQLite compatible call # stories = stories.extra(select={'rally_id': 'CAST(rally_id AS INTEGER)'}).extra(order_by = ['rally_id']) stories.select_related() stories_refresh_enabled = ( ConfigCache.get_config_value('rally.enabled') == '1') or (ConfigCache.get_config_value('agilezen.enabled') == '1') data = { 'stories': stories, 'rally_refresh': stories_refresh_enabled, 'releaseid': releaseid, 'in_release': in_release, 'sprintList': sprintList, 'sprint': sprint } return render(request, 'stories.html', data)
def connect(): rally_user = ConfigCache.get_config_value('rally.login') rally_pass = ConfigCache.get_config_value('rally.password') session = Rally(settings.RALLY_SERVER, rally_user, rally_pass) logger.debug('Logging in with username ' + rally_user) return session
def unreleased(request, repo_name, branch_name): branch = Branch.objects.get(repo__name=repo_name, name=branch_name) if request.method == u'GET' and request.GET.__contains__( 'releaseAll') and request.GET['releaseAll'] == 'true': deltas = Delta.objects.exclude(object__release_status='r').filter( object__branch=branch) deltas.select_related() for delta in deltas.all(): delta.object.release_status = 'r' delta.object.save() go = '' search = '' username = '' typeFilter = '' endDate = date.today() startDate = endDate + timedelta(days=-14) objectTypesData = DeployableObject.objects.values('type').order_by( 'type').distinct() objectTypes = list() for type in objectTypesData: if type['type'] != '': objectTypes.append(type['type']) if request.method == u'GET': if request.GET.__contains__('go'): go = 'true' if request.GET.__contains__('search'): search = request.GET['search'] if request.GET.__contains__('username'): username = request.GET['username'] if request.GET.__contains__('startDate'): startDate = datetime.strptime(request.GET['startDate'], "%m/%d/%Y") if request.GET.__contains__('endDate'): endDate = datetime.strptime(request.GET['endDate'], "%m/%d/%Y") if request.GET.__contains__('type'): typeFilter = request.GET['type'] uiEndDate = endDate endDate = endDate + timedelta(days=1) deltas = [] objects = [] deltaMap = {} user = '' changeDate = '' if request.GET.__contains__('go'): deltas = Delta.objects.filter(object__branch=branch).filter( commit__date_added__gte=startDate).filter( commit__date_added__lte=endDate) if len(username) > 0: deltas = deltas.filter(user_change__sfuser__name=username) if len(search) > 0: deltas = deltas.extra(where=[ '(filename LIKE \'%%' + search + '%%\' or type LIKE \'%%' + search + '%%\' or el_type LIKE \'%%' + search + '%%\' or el_subtype LIKE \'%%' + search + '%%\' or el_name LIKE \'%%' + search + '%%\')' ]) if len(typeFilter) > 0: deltas = deltas.extra(where=['type = \'' + typeFilter + '\'']) deltas = deltas.order_by('object__type', 'object__filename', 'object__el_type', 'object__el_subtype', 'object__el_name', 'commit__date_added') logger.debug('Deltas SQL ' + str(deltas.query)) deltas.select_related() for delta in deltas.all(): changelog = deltaMap.get(delta.object) if delta.user_change and delta.user_change.sfuser.name != '': user = '******' + delta.user_change.sfuser.name changeDate = ' at ' + str(delta.user_change.last_update)[:16] else: user = '' changeDate = '' if changelog: if not changelog.endswith(delta.getDeltaType() + user + changeDate): changelog += '\n' + delta.getDeltaType( ) + user + changeDate deltaMap[delta.object] = changelog else: objects.append(delta.object) deltaMap[ delta.object] = delta.getDeltaType() + user + changeDate userList = SalesforceUser.objects.values('name').order_by( 'name').distinct() users = [u['name'] for u in userList] annotations = [] if ConfigCache.get_config_value('show.todo') == '1': todofile = os.path.join(branch.repo.location, '..', 'annotations_' + branch.name + '.txt') try: if os.path.exists(todofile): with open(todofile, 'r') as f: annotations = json.loads(f.read())['annotations'] except: pass data = { 'branch_name': branch_name, 'repo_name': branch.repo.name, 'objects': objects, 'startDate': startDate, 'endDate': uiEndDate, 'deltaMap': deltaMap, 'namestl': namestl, 'users': users, 'search': search, 'username': username, 'go': go, 'objectTypes': objectTypes, 'selectedType': typeFilter, 'todos': annotations } return render(request, 'unreleased.html', data)
def connect(): rally_user = ConfigCache.get_config_value('rally.login') rally_pass = ConfigCache.get_config_value('rally.password') session = Rally(settings.RALLY_SERVER, rally_user, rally_pass) logger.debug('Logging in with username ' + rally_user) return session
def unreleased(request, repo_name, branch_name): branch = Branch.objects.get(repo__name=repo_name, name=branch_name) if request.method == u"GET" and request.GET.__contains__("releaseAll") and request.GET["releaseAll"] == "true": deltas = Delta.objects.exclude(object__release_status="r").filter(object__branch=branch) deltas.select_related() for delta in deltas.all(): delta.object.release_status = "r" delta.object.save() go = "" search = "" username = "" typeFilter = "" endDate = date.today() startDate = endDate + timedelta(days=-14) objectTypesData = DeployableObject.objects.values("type").order_by("type").distinct() objectTypes = list() for type in objectTypesData: if type["type"] != "": objectTypes.append(type["type"]) if request.method == u"GET": if request.GET.__contains__("go"): go = "true" if request.GET.__contains__("search"): search = request.GET["search"] if request.GET.__contains__("username"): username = request.GET["username"] if request.GET.__contains__("startDate"): startDate = datetime.strptime(request.GET["startDate"], "%m/%d/%Y") if request.GET.__contains__("endDate"): endDate = datetime.strptime(request.GET["endDate"], "%m/%d/%Y") if request.GET.__contains__("type"): typeFilter = request.GET["type"] uiEndDate = endDate endDate = endDate + timedelta(days=1) deltas = [] objects = [] deltaMap = {} user = "" changeDate = "" if request.GET.__contains__("go"): deltas = ( Delta.objects.filter(object__branch=branch) .filter(commit__date_added__gte=startDate) .filter(commit__date_added__lte=endDate) ) if len(username) > 0: deltas = deltas.filter(user_change__sfuser__name=username) if len(search) > 0: deltas = deltas.extra( where=[ "(filename LIKE '%%" + search + "%%' or type LIKE '%%" + search + "%%' or el_type LIKE '%%" + search + "%%' or el_subtype LIKE '%%" + search + "%%' or el_name LIKE '%%" + search + "%%')" ] ) if len(typeFilter) > 0: deltas = deltas.extra(where=["type = '" + typeFilter + "'"]) deltas = deltas.order_by( "object__type", "object__filename", "object__el_type", "object__el_subtype", "object__el_name", "commit__date_added", ) logger.debug("Deltas SQL " + str(deltas.query)) deltas.select_related() for delta in deltas.all(): changelog = deltaMap.get(delta.object) if delta.user_change and delta.user_change.sfuser.name != "": user = "******" + delta.user_change.sfuser.name changeDate = " at " + str(delta.user_change.last_update)[:16] else: user = "" changeDate = "" if changelog: if not changelog.endswith(delta.getDeltaType() + user + changeDate): changelog += "\n" + delta.getDeltaType() + user + changeDate deltaMap[delta.object] = changelog else: objects.append(delta.object) deltaMap[delta.object] = delta.getDeltaType() + user + changeDate userList = SalesforceUser.objects.values("name").order_by("name").distinct() users = [u["name"] for u in userList] annotations = [] if ConfigCache.get_config_value("show.todo") == "1": todofile = os.path.join(branch.repo.location, "..", "annotations_" + branch.name + ".txt") try: if os.path.exists(todofile): with open(todofile, "r") as f: annotations = json.loads(f.read())["annotations"] except: pass data = { "branch_name": branch_name, "repo_name": branch.repo.name, "objects": objects, "startDate": startDate, "endDate": uiEndDate, "deltaMap": deltaMap, "namestl": namestl, "users": users, "search": search, "username": username, "go": go, "objectTypes": objectTypes, "selectedType": typeFilter, "todos": annotations, } return render(request, "unreleased.html", data)
def stories(request): if request.method == u"POST" and request.POST.__contains__("releaseid"): release = Release.objects.get(id=request.POST["releaseid"]) if request.POST.__contains__("storyId"): ids = request.POST.getlist("storyId") sprint_name = request.POST["cboSprints"] print("sprint_name " + sprint_name) if sprint_name != "": for story in release.stories.all(): if story.sprint == sprint_name: print("removing " + story.name) release.stories.remove(story) else: release.stories.clear() stories = Story.objects.filter(id__in=ids) for s in stories.all(): if s not in release.stories.all(): # this print was causing a unicode issue adding a story, so commented out # print 'adding ' + s.name release.stories.add(s) release.save() return redirect("/release/" + str(release.id)) if request.method == u"GET" and request.GET.__contains__("delete"): story = Story.objects.get(id=request.GET["delete"]) objects = DeployableObject.objects.filter(pending_stories=story) for object in objects: object.pending_stories.remove(story) object.save() story.delete() if request.method == u"GET" and request.GET.__contains__("refresh"): if ConfigCache.get_config_value("agilezen.enabled") == "1": agilezenintegration.refresh() if ConfigCache.get_config_value("rally.enabled") == "1": rallyintegration.refresh() releaseid = "" in_release = {} if request.method == u"GET" and request.GET.__contains__("releaseid"): releaseid = request.GET["releaseid"] if len(releaseid) > 0: release = Release.objects.get(id=request.GET["releaseid"]) for story in release.stories.all(): in_release[story.id] = True sprint = "" if request.method == u"GET" and request.GET.__contains__("sprint"): sprint = request.GET["sprint"] sprintList = [] oneYear = timedelta(days=365) oneYearAgo = datetime.now() - oneYear if request.method == u"GET" and request.GET.__contains__("history"): sprints = Story.objects.values("sprint").filter(sprint__isnull=False).order_by("sprint").distinct() else: sprints = ( Story.objects.values("sprint") .filter(sprint__isnull=False, date_added__gte=oneYearAgo) .order_by("sprint") .distinct() ) for sprintName in sprints: if len(sprintName["sprint"]) > 0 and not sprintList.__contains__(sprintName["sprint"]): sprintList.append(sprintName["sprint"]) if request.method == u"GET" and request.GET.__contains__("history"): stories = Story.objects.all() else: stories = Story.objects.filter(date_added__gte=oneYearAgo) if len(sprint) > 0: stories = stories.filter(sprint=sprint) stories = stories.order_by("sprint", "rally_id", "name") # Need to cast the rally_id to prevent duplicate stories from coming over # different SQL needed for mySQL and SQLite ## MySQL compatible call if ConfigCache.get_config_value("agilezen.enabled") == "1": stories = stories.extra(select={"rally_id": "CAST(rally_id AS SIGNED)"}).extra(order_by=["rally_id"]) ## SQLite compatible call # stories = stories.extra(select={'rally_id': 'CAST(rally_id AS INTEGER)'}).extra(order_by = ['rally_id']) stories.select_related() stories_refresh_enabled = (ConfigCache.get_config_value("rally.enabled") == "1") or ( ConfigCache.get_config_value("agilezen.enabled") == "1" ) data = { "stories": stories, "rally_refresh": stories_refresh_enabled, "releaseid": releaseid, "in_release": in_release, "sprintList": sprintList, "sprint": sprint, } return render(request, "stories.html", data)