Example #1
0
def returnTicket(ticket_num, option, config):
	fb = FogBugz(config['FOGBUGZ_URL'], config['FOGBUGZ_TOKEN'])

	if option == "short":
	
		retrieve_ticket = fb.search(q=ticket_num, cols='ixBug,sTitle,sProject')

		if retrieve_ticket.cases['count'] == str(1):
		
			ticket_title = retrieve_ticket.cases.case.stitle.string
			ticket_project = retrieve_ticket.cases.case.sproject.string
			ticket_URL   = "https://tenthwave.fogbugz.com/f/cases/"+ticket_num
		
			ticket = "Ticket: " + ticket_num + "  |  " + ticket_title + "\n\n" + ticket_URL

			return ticket
		else:
			return "Something went wrong! Either Fogbugz is down, you're a magician calling a number that does not exist yet, or it somehow returned more than one ticket."
	else:
		
		retrieve_ticket = fb.search(q=ticket_num, cols="ixBug,sTitle,sLatestTextSummary,sArea,sProject")

		if retrieve_ticket.cases['count'] == str(1):
		
			ticket_title = retrieve_ticket.cases.case.stitle.string
			ticket_area = retrieve_ticket.cases.case.sarea.string
			ticket_project = retrieve_ticket.cases.case.sproject.string
			ticket_URL   = "https://tenthwave.fogbugz.com/f/cases/"+ticket_num
			ticket_last_update = retrieve_ticket.cases.case.slatesttextsummary.string
	
			ticket = ticket_URL + "\n\nTicket: " + ticket_num + "\n" + ticket_project + " : " + ticket_area + "\n*" + ticket_title + "*\n\n" + ticket_last_update
		
			return ticket
		else:
			return "Something went wrong! Either Fogbugz is down, you're a magician calling a number that does not exist yet, or it somehow returned more than one ticket."
Example #2
0
def cgi_callback():
    ## Begin sample data loading ##
    ## Customize with your own logic ##
    fb = FogBugz(fbsettings.URL, fbsettings.TOKEN)
    resp = fb.search(
        q='project:inbox area:* status:active due:today orderby:due',
        cols="dtDue,sTitle")

    cases = []
    for case in resp.cases:
        date = datetime.strptime(case.dtdue.string,
                                 '%Y-%m-%dT%H:%M:%SZ').strftime('%m/%d/%Y')
        time = case.dtdue.string[11:16]
        departure = case.stitle.string.encode('UTF-8').replace('\"', '')
        track = random.randrange(0, 100)
        if (datetime.strptime(case.dtdue.string, '%Y-%m-%dT%H:%M:%SZ') -
                datetime.now()).days < 0:
            status = 3
        else:
            status = 2
        cases.append({
            'sDate': date,
            'sTime': time,
            'sDeparture': departure,
            'nStatus': status,
            'nTrack': track,
            'bLight': False
        })
Example #3
0
def get_requirements_cases(project_name):
    """
    Looks for all cases of category:"Requirement" in Fogbugz

    Returns a list of case dictionary objects with the following of a case:
    [
        {
            "id"      : FogBugz ID of case,
            "title"   : Title of case,
            "status"  : FogBugz status (i.e. 'proposed', 'approved', etc),
            "event"   : Description of requirement,
            "area"    : FogBugz area of case (Front End, Support, etc),
            "url"     : URL to actual case in FogBugz,
            "children": Subcases attached to current case
        }
    ]
    """

    fb = FogBugz(FB_URL, FB_TOKEN)

    print "Requesting Data"

    resp = fb.search(q='category:"Requirement" orderby:"ixBug" project:"' + project_name + '"',
                     cols="sTitle,sArea,ixBug,sLatestTextSummary,sFixFor,sStatus,ixBugChildren")

    return get_cases_from_XML(resp)
def main():

    if len(sys.argv) != 3:
        sys.exit("Incorrect number of arguments")

    c = readcFile(sys.argv[1])

    c['test.build'] = sys.argv[2]
    rawCrashes = getCrashesFromDirectory(c['test.separator'], c['test.dir'])
    crashes = parseCrashes(rawCrashes, c)

    if (len(crashes) != 0):

        fb = FogBugz(c['fogbugz.url'])
        fogbugzQuery = 'project:\"' + c['fogbugz.project'] + '"'
        fb.logon(c['fogbugz.user'], c['fogbugz.pass'])
        fogBugzResp = fb.search(q=fogbugzQuery,
                                cols='ixBug,sTitle,fOpen,events')
        crashes = flagExcludeList(c, crashes)
        crashes = flagFBDuplicates(fogBugzResp, crashes, c)
        logCrashesToFogbugz(fb, c, crashes)

    emailReport(c, crashes)

    print 'Done'
Example #5
0
def get_wiki_content(wiki_id, sections):
    """
    Grabs wiki pages from FogBugz that match a section listed in 'sections'.

    Returns a list of wiki dictionary objects:

    [
        {
            "page_id"   : FogBugz ID of wiki page,
            "name"      : Title of page,
            "url"       : URL to actual wiki page in FogBugz,
            "content"   : Raw HTML of Wiki Content
        }
    ]

    """
    fb = FogBugz(FB_URL, FB_TOKEN)

    wiki_articles = fb.listArticles(ixWiki=wiki_id)

    article_list = []

    for page in wiki_articles.articles.childGenerator():
        if page.sheadline.text.encode('UTF-8') in sections:
            wiki_url = "%s/default.asp?W%s" % (FB_URL, page.ixwikipage.text)
            article_dict = {"page_id": page.ixwikipage.text,
                            "name"   : page.sheadline.text.encode('UTF-8'),
                            "url"    : wiki_url}
            content = fb.viewArticle(ixWikiPage=article_dict["page_id"])
            article_dict['content'] = Markup(content.wikipage.sbody.text.encode('UTF-8'))
            article_list.append(article_dict)

    return article_list
Example #6
0
def get_list_of_projects():
    """
    Gets a list of projects from FogBugz.

    Returns a list of project dictionary objects:
    [
        {
            "project": project name,
            "owner"  : project contact name,
            "email"  : owner's email
        }
    ]
    """
    try:
        fb = FogBugz(FB_URL, FB_TOKEN)
    except:
        return "Cannot connect"

    project_xml = fb.listProjects()

    projects = []

    for project in project_xml.projects.childGenerator():

        project_dict = {'project': project.sproject.text.encode('UTF-8'),
                        # 'id': project.ixproject.text,
                        'owner': project.spersonowner.text,
                        'email': project.semail.text}

        projects.append(project_dict)

    return projects
def getData(fogBugzUrl, userName, password, today):
    oneMonthAgo = today - timedelta(days=28)
    fb = FogBugz(fogBugzUrl)
    fb.logon(userName, password)
    resp = fb.listIntervals(dtStart=asIso8601zDateString(oneMonthAgo),
                            dtEnd=asIso8601zDateString(today))
    return resp
Example #8
0
def handle_github_payload(request):
    if request.method == 'POST':
        payload = json.loads(request.POST.get('payload'))

        fb = FogBugz(settings.FOGBUGZ_URL)
        fb._token = None

        commits = payload['commits']

        if commits:
            for c in commits:
                user = FogBugzLogin.objects.filter(
                    email = c['author']['email'])
                if user:
                    user = user[0]

                    fb._token = user.fogbugz_token

                    message = c['message']
                    commit_hash = c['id']
                    case_ids, fb_message = parse_commit_message(message,
                                                                commit_hash)

                    try:
                        for case_id in case_ids:
                            post_message(fb, case_id, fb_message, commit_hash)
                    except FogBugzAPIError as e:
                        send_error_email(e.message)
                        break

        return HttpResponse('Thanks, GitHub!')

    # we don't want any GET requests on this page.  Only POST
    return HttpResponse('Move along. Nothing to see here.')
Example #9
0
def cgi():
    fb = FogBugz(fbsettings.URL, fbsettings.TOKEN)
    resp = fb.search(q='project:inbox area:* status:active due:today orderby:due',
                     cols="dtDue,sTitle")

    cases = []

    for case in resp.cases:
        date = datetime.strptime(case.dtdue.string, '%Y-%m-%dT%H:%M:%SZ').strftime('%m/%d/%Y')
        time = case.dtdue.string[11:16]
        departure = case.stitle.string.encode('UTF-8').replace('\"', '')
        track = random.randrange(0, 100)
        if (datetime.strptime(case.dtdue.string, '%Y-%m-%dT%H:%M:%SZ') - datetime.now()).days < 0:
           status = 3
        else:
           status = 2
        cases.append({'sDate': date,
                      'sTime': time,
                      'sDeparture': departure,
                      'nStatus': status,
                      'nTrack': track,
                      'bLight': False})

    #turn on the top light
    try:
        cases[0]['bLight'] = True
    except:
        pass

    print("Content-Type: application/json", end='\n\n')
    json.dump(cases, sys.stdout)
Example #10
0
def run():
    parser = argparse.ArgumentParser(description="JIRA to FogBugz importer")
    parser.add_argument('jira_url',
                        help="JIRA URL, ex. http://jira.example.com")
    parser.add_argument('jira_username', help="JIRA username")
    parser.add_argument('jira_password', help="JIRA password")
    parser.add_argument('fogbugz_url',
                        help="FogBugz URL, ex. http://example.fogbugz.com")
    parser.add_argument('fogbugz_username', help="FogBugz username")
    parser.add_argument('fogbugz_password', help="FogBugz password")
    parser.add_argument('default_assignee', help="The email of the default assignee")
    # TODO: dynamically create projects based on JIRA data
    parser.add_argument('project', help="Which FogBugz project to put cases in")
    parser.add_argument('-v', '--verbose',
                        dest="verbose",
                        action="store_true",
                        default=False,
                        help="Get more verbose output")
    args = parser.parse_args()

    try:
        try:
            jira = JIRA(options={'server': args.jira_url},
                        basic_auth=(args.jira_username,
                                    args.jira_password))
        except JIRAError, e:
            if e.status_code == 403:
                sys.stderr.write('Cannot connect to JIRA. Check username/password\n')
                sys.exit(1)
            else:
                msg = "Cannot connect to JIRA  (return code={0})".format(e.status_code)
                if args.verbose:
                    msg += "\n{0}".format('Response from JIRA:\n{0}'.format(e.text))
                sys.stderr.write(msg+'\n')
                sys.exit(1)
        try:
            fb = FogBugz(args.fogbugz_url)
            fb.logon(args.fogbugz_username, args.fogbugz_password)
        except FogBugzConnectionError:
            sys.stderr.write('Cannot connect to FogBugz\n')
            sys.exit(1)
        except FobBugzLogonError:
            sys.stderr.write('Cannot login to FogBugz. Check username/password')
            sys.exit(1)

        # initialize an email to fogbugz User ID mapping
        email_map = {}
        resp = fb.listPeople()
        for person in resp.people.childGenerator():
            email_map[person.semail.string] = int(person.ixperson.string)
        try:
            default_assignee = email_map[args.default_assignee]
        except KeyError:
            parser.error("Default assignee {0} does not exist in FogBugz".format(args.default_assignee))

        for issue in get_jira_issues(jira, query):
            create_issue(fb, issue, project_name, email_map, default_assignee)
Example #11
0
def cgi_callback():
    ## Begin sample data loading ##
    ## Customize with your own logic ##
    fb = FogBugz(fbsettings.URL, fbsettings.TOKEN)
    resp = fb.search(q='project:inbox area:* status:active due:today orderby:due',
                     cols="dtDue,sTitle")

    cases = []
    for case in resp.cases:
        date = datetime.strptime(case.dtdue.string, '%Y-%m-%dT%H:%M:%SZ').strftime('%m/%d/%Y')
        time = case.dtdue.string[11:16]
        departure = case.stitle.string.encode('UTF-8').replace('\"', '')
        track = random.randrange(0, 100)
        if (datetime.strptime(case.dtdue.string, '%Y-%m-%dT%H:%M:%SZ') - datetime.now()).days < 0:
           status = 3
        else:
           status = 2
        cases.append({'sDate': date,
                      'sTime': time,
                      'sDeparture': departure,
                      'nStatus': status,
                      'nTrack': track,
                      'bLight': False})

    # turn on the top light
    try:
        cases[0]['bLight'] = True
    except:
        pass

    ## End sample data loading ##

    # save json data to be read by liveFogbugz.py
    f = open('fogbugz.json','w')
    f.write(json.dumps(cases, sys.stdout))
    f.close()

    # this page doesn't return the json, but might as well return some stats
    stats = {'error': False, 'cases': len(cases)}

    # support a callback param, or default to "void"
    params = cgi.parse_qs(os.environ['QUERY_STRING'])
    callback = 'void'
    if params.has_key('callback'):
        callback = params['callback'][0]

    print('Content-Type: application/javascript\n')
    print('%s(%s);' % (callback,json.dumps(stats, sys.stdout)))
 def fogbugzOnFail(self,logfp):
     print "Creating FogBuz Ticket"
     cfp=Config(self.__fpath)
     attempts=0
     run=True
     while run is True and attempts < 3: 
         try:
             site=FogBugz(cfp.getVar("fogbugz","site","string"))
             try:
                 site.logon(cfp.getVar("fogbugz","user","string"), cfp.getVar("fogbugz","pass","string"))
                 cfp=Config(self.__fpath)
                 with open(logfp,'rb') as fp:
                     print site.new(sTitle="The Parser "+os.path.join(self.__logbase,self.__execute)+" Failed",ixPersonAssignedTo="Andy",Files={"faillog.txt":fp})
                 attempts+=1
                 run=False
             except Exception,e:
                 print str(e)
                 for frame in traceback.extract_tb(sys.exc_info()[2]):
                     print '\n'.join([str(x) for x in frame])
             finally:
                 site.logoff()
         except Exception,e:
             print str(e)
             for frame in traceback.extract_tb(sys.exc_info()[2]):
                 print '\n'.join([str(x) for x in frame])
Example #13
0
 def doPrivmsg(self, irc, msg):
     if(self.registryValue('enable', msg.args[0])):
         match = re.search('.*Bug[sz]id *: *(\d{1,5})', msg.args[1], re.IGNORECASE)
         if match:
             fb = FogBugz(fbSettings.fb_url)
             fb.logon(fbSettings.fb_user, fbSettings.fb_pass)
             query_cols='sTitle,sStatus,sPriority'
             resp = fb.search(q=match.group(1), cols = query_cols)
             if len(resp.findAll('case')) > 0 :
                 for cur_case in resp.cases.childGenerator():
                     # Dump Title
                     title_message = '[BugzID ' + match.group(1) + '] ' + ircutils.bold(str(cur_case.stitle.string).replace('<![CDATA[','').replace(']]>','')) + ' (' + cur_case.sstatus.string  + ', ' + cur_case.spriority.string  +')'
                     irc.queueMsg(ircmsgs.privmsg(msg.args[0], title_message))
                     # Dump URL to ticket
                     url_message = fbSettings.fb_url + '/default.asp?' + match.group(1)
                     irc.queueMsg(ircmsgs.privmsg(msg.args[0], url_message))
             else :
                 irc.queueMsg(ircmsgs.privmsg(msg.args[0], 'Sorry, ' + ircutils.bold(match.group(1))  + ' is not a known BugID.'))
Example #14
0
def update_tickets(args):
    cols = [
        "ixBug", "sStatus", "sTitle", 'sTags', "ixPersonOpenedBy", "dtOpened",
        "sProject", 'plugin_customfields', "latestEvent"
    ]
    fb = FogBugz('https://daily.manuscript.com/')
    fb.logon(args.email, args.password)
    query = {"status": "Active", "AssignedTo": "Unassigned"}
    querystring = " ".join(["{}:{}".format(k, v) for k, v in query.items()])
    resp = fb.search(q=querystring, cols=",".join(cols))
    for casexml in resp.cases.childGenerator():
        #logger.info("case:##{}".format(casexml))
        logger.debug(casexml['ixBug'])
        id = casexml['ixBug']
        question = casexml.sTitle.getText()
        latest_event = casexml.events
        event_id = latest_event.ixBugEvent.getText()
        message_body = latest_event.s.getText()

        answers_string = ""
        pdb.set_trace()
        if message_body == "":
            answers = googler(question)
            for ele in answers:
                answers_string += "\n".join(
                    [ele['title'], ele['url'], ele['abstract']])
                answers_string += '\n\n'
            fb.edit(ixBug=id,
                    sEvent=answers_string,
                    ixPersonAssignedTo=casexml.ixPersonOpenedBy.getText())
        else:
            for line in [i for i in message_body.split('\n') if i != '']:
                answers_string = ""
                if line.startswith("##"):
                    answers_string += '**' + line[3:].encode('utf-8')
                    answers_string += '\n'
                    answers = googler(line[3:])
                    for ele in answers:
                        answers_string += "\n".join(
                            [ele['title'], ele['url'], ele['abstract']])
                        answers_string += '\n\n'
                    fb.edit(
                        ixBug=id,
                        ixPersonAssignedTo=casexml.ixPersonOpenedBy.getText(),
                        sEvent=answers_string)
                    #fb.edit(ixBug=id,ixBugEvent=event_id,sEvent=answers_string,ixPersonAssignedT=casexml.ixPersonOpenedBy.getText())
                else:
                    break
Example #15
0
def editFBCase(site, username, password, case, change, changetext):
    fb = FogBugz('https://' + site + '.fogbugz.com/')
    fb.logon(username, password)

    logging.info('Updating fogbugz cases')

    fb.edit(ixBug=case, sEvent=changetext)

    fb.logoff()
Example #16
0
def fogbugz(fogbugz_uri):
    """Test fogbugz instance."""
    httpretty.enable()
    httpretty.register_uri(httpretty.GET,
                           fogbugz_uri + 'api.xml',
                           body="""<response>
<version>8</version>
<minversion>1</minversion>
<url>api.asp?</url>
</response>""")
    yield FogBugz(fogbugz_uri)
    httpretty.disable()
Example #17
0
def updateFogbugzCases(site, username, password, ordered_changes, changemap,
                       casemap, releasenotesmap):
    logging.info('Logging on to site ' + site + ' as user ' + username)

    fb = FogBugz('https://' + site + '.fogbugz.com/')
    fb.logon(username, password)

    logging.info('Updating fogbugz cases')

    for change in ordered_changes:
        logging.info('    Commit: ' + change)
        changetext = changemap[change]
        cases = casemap[change]
        #        releasenotes = releasenotesmap[change]

        logging.info('        Cases: ' + str(cases))
        logging.info('        Text:  ' + changetext)
        #        logging.info('        Release notes: ' + releasenotes)

        if cases:
            for case in cases:
                if hasChange(fb, case, change) == False:
                    logging.info('        Updating case ' + str(case))
                    fb.edit(ixBug=case, sEvent=changetext)


#                    fb.edit(ixBug=case, sReleaseNotes=releasenotes)
                else:
                    logging.info('        Skipping case ' + str(case))
Example #18
0
def login(request):
    fogbugz_error = None
    if request.method == 'POST':
        form = LoginForm(request.POST)

        if form.is_valid():
            email_address = str(request.POST.get('email_address',''))
            password = str(request.POST.get('password',''))
            fb = FogBugz(settings.FOGBUGZ_URL)
            try:
                fb.logon(email_address, password)
            except FogBugzAPIError as e:
                fogbugz_error = e.message
                mail_error = 'Error on login:\n\n' + e.message
                send_error_email(mail_error)


            fb_token = fb._token        # pylint: disable=W0212

            # save token into model
            if fb_token:
                login = FogBugzLogin.objects.filter(email=email_address)

                if not login:
                    login = FogBugzLogin(email=email_address,
                                         fogbugz_token=fb_token)
                    login.save()
                else:
                    login.update(fogbugz_token=fb_token)

                return render_to_response('fogbugz_login_complete.html')

    else:
        form = LoginForm()

    return render_to_response('login.html',
                              {'login_form': form,
                               'fogbugz_error': fogbugz_error,
                               'fogbugz_site': settings.FOGBUGZ_URL})
Example #19
0
def get_project_data(project_name):
    """
    Gets data regarding specific project from FogBugz.

    Returns a project dictionary object:
    {
        "project": project name,
        "id"     : FogBugz ID of project,
        "owner"  : project contact name,
        "email"  : owner's email,
        "wiki_id": FogBugz ID of the wiki with the same name as project
    }
    """
    try:
        fb = FogBugz(FB_URL, FB_TOKEN)
    except:
        return "Cannot connect"

    project_xml = fb.viewProject(sProject=project_name)

    person_xml = fb.viewPerson(ixPerson=project_xml.ixpersonowner.text)

    project_dict = {
                        'project': project_xml.sproject.text.encode('UTF-8'),
                        'id': project_xml.ixproject.text,
                        'owner': person_xml.sfullname.text,
                        'email': person_xml.semail.text,
                        'wiki_id': None
                    }

    wiki_list = fb.listWikis()

    for wiki in wiki_list.wikis.childGenerator():
            if project_dict['project'] == wiki.swiki.text.encode('UTF-8'):
                wiki_id = wiki.ixwiki.text

    project_dict['wiki_id'] = wiki_id

    return project_dict
Example #20
0
def main():
    # Program start and timer
    print("Started the program... ")
    print(str(datetime.now().strftime(FORMAT_OF_DATE)))
    start = time.time()

    # Fogbugz init
    fb = FogBugz(getpath(), getapikeyassistant(), api_version=8)
    bugcases = getcaseslist(fb, query=yes())
    findowner(fb, bugcases)

    # Finish time
    end = time.time()
    print('Finished program. Time spent: ' + str(end - start))
    print(str(datetime.now().strftime(FORMAT_OF_DATE)))
def main():
    
        if len(sys.argv) != 3:  
            sys.exit("Incorrect number of arguments")
            
        c = readcFile(sys.argv[1])
        
        c['test.build']=sys.argv[2]
        rawCrashes = getCrashesFromDirectory(c['test.separator'], c['test.dir'])
        crashes = parseCrashes(rawCrashes, c)
        
        if (len(crashes) != 0):
                         
            fb = FogBugz(c['fogbugz.url'])
            fogbugzQuery='project:\"' + c['fogbugz.project'] + '"'
            fb.logon(c['fogbugz.user'], c['fogbugz.pass'])
            fogBugzResp = fb.search(q=fogbugzQuery,cols='ixBug,sTitle,fOpen,events')
            crashes = flagExcludeList(c, crashes)
            crashes = flagFBDuplicates(fogBugzResp, crashes, c)
            logCrashesToFogbugz(fb, c, crashes)
            
        emailReport(c, crashes)
        
        print 'Done'
Example #22
0
def findinguserbyevents(case):
    fb = FogBugz(getpath(), getapikeyassistant(), api_version=8)
    bugevents = particularcaseevents(fb, case)

    for event in bugevents['events']:
        s = event['sChanges']

        # Looking for "Status changed from 'xxxxx' to 'Active'
        statuslines = [
            sentence for sentence in s.split('\r\n')
            if 'Status changed' in sentence
        ]
        if statuslines:
            fromtostring = statuslines[0].split('\'')
            if fromtostring[3] == 'Active':
                if str(event['sPerson']) is not None:
                    # print(str(bugevents['ixBug']) + " " + str(event['sPerson']) + " " + " to " + fromtostring[3])
                    return str(event['sPerson'])

        # If there is no status change, let's say a case was Active already, because reported internally
        # Looking for "Category changed from 'xxxxx' to 'Unity'
        statuslines = [
            sentence for sentence in s.split('\r\n')
            if 'Project changed' in sentence
        ]
        if statuslines:
            fromtostring = statuslines[0].split('\'')
            if fromtostring[3] == 'Unity':
                if str(event['sPerson']) is not None:
                    # print(str(bugevents['ixBug']) + " " + str(event['sPerson']) + " " + " to " + fromtostring[3])
                    return str(event['sPerson'])

    # If we cannot find a person by Status or Category, look for the case opener
    # Looking for "Opened by"
    for event in bugevents['events']:
        s = event['evtDescription']
        statuslines = [
            sentence for sentence in s.split('\r\n') if 'Opened by' in sentence
        ]
        if statuslines:
            if str(event['sPerson']) is not None:
                # print(str(event['sPerson']))
                return str(event['sPerson'])
Example #23
0
from fogbugz import FogBugz
import fbSettings
import argparse, sys
import pprint

fogbugz = FogBugz(fbSettings.URL)
fogbugz.logon(fbSettings.LOGIN, fbSettings.PW)
parser = argparse.ArgumentParser(description='I fix this later')
parser.add_argument('-m','--milestone', metavar='A list of Milestones by name, seperated by space(ie: ui release/9.0 link-php release/9.0)',
                    nargs ='+',
                    help='Milestone Names', required=False)
parser.add_argument('-l','--list',action='store_true', default=False,
                    help='List the available milestones')

args = parser.parse_args()
pp = pprint.PrettyPrinter(indent=4)

milestone_map = {}
milestones = fogbugz.listFixFors()
for item in milestones.findAll('fixfor'):
     number =  item.ixfixfor.string.encode('UTF-8')
     name = item.sfixfor.string.encode('UTF-8')
     milestone_map.update({name:number})

if args.list:
    pp.pprint(milestone_map)

ms = "test1"
tickets_per_milestone = {}
#print args.milestone
if args.milestone:
Example #24
0
from fogbugz import FogBugz
from datetime import datetime, timedelta
import csv

S_FOGBUGZ_URL = 'https://fogbugz.com/'
S_EMAIL = ''
S_PASSWORD = ''

fb = FogBugz(S_FOGBUGZ_URL)
fb.logon(S_EMAIL, S_PASSWORD)

resp = fb.search(
    q='sFixFor="2018.2"',
    cols=
    'ixBug, ixBugParent, fOpen, sTitle, ixProject, ixArea, sArea, ixStatus, ixPriority,sFixFor, dtFixFor, sVersion, sComputer, c, ixCategory, dtOpened, dtClosed'
)

filename = "fogbugzData.csv"

csv = open(filename, "w")

columnTitleRow = "ixBug,ixBugParent,fOpen,sTitle,dtDue"
csv.write(columnTitleRow)

for case in resp.cases:
    bugID = case.ixBug.string
    title = case.sTitle.string
    open = case.fOpen.string
    version = case.ixProject.string
    priority = case.ixPriority.string
    status = case.ixStatus.string
Example #25
0
from fogbugz import FogBugz
import csv
import sys

# Fill in the following values as appropriate to your installation
S_FOGBUGZ_URL   = 'https://fogbugz.unity3d.com'
TOKEN			= ""
S_EMAIL         = ''
S_PASSWORD      = ''

fb = FogBugz(S_FOGBUGZ_URL, TOKEN)
#fb.logon(S_EMAIL, S_PASSWORD)

#Get all cases in milestone 2018.2
resp = fb.search(q='version:"'+ sys.argv[1] +'*"',cols="ixBug,ixBugParent,fOpen,sTitle,sProject,ixArea,sArea,sStatus,ixPriority,sFixFor,sVersion,sComputer,dtOpened,dtClosed,plugin_customfields_at_fogcreek_com_userxpainr32d")
#print resp
print "Started on version" + sys.argv[1]
filename = "fogbugzData.csv"

csv = open(filename, "w")

columnTitleRow = "Bug ID,Bug Parent ID,is Open,Title,Project,Area ID,Area,Status,Priority,Fix For,Version,Computer,User Pain, Date Opened, Date Closed"

csv.write(columnTitleRow)
csv.write("\n")

for case in resp.cases.childGenerator():
	#assign the cols to variables
	if case.ixBug.string != None:
		bugID = case.ixBug.string
Example #26
0
# Get FogBugz API connection information
print fbSettings.URL
print fbSettings.TOKEN


# --------------------------------------------------------------
# SECTION: System settings
# --------------------------------------------------------------


SETTINGSFILE='fbSettings.py' # if this changes, also change the "import fbSettings" abvoe
SERVER='PC-Longphi'
DATABASE='FogBugz'

fb = FogBugz(fbSettings.URL, fbSettings.TOKEN)

'''
#Get all cases assigned to me
resp = fb.search(cols='ixBug,sTitle,dtDue')

print 'The following cases are overdue:'

for case in resp.cases.childGenerator():
    #Check to see if we have a due date
    if case.dtdue.string: 
        #All dates returned are UTC, so parse the due date
        #into a datetime object.
        dtDueUtc = datetime.strptime(case.dtdue.string,'%Y-%m-%dT%H:%M:%SZ')
        fOverdue = dtDueUtc <= datetime.utcnow()
        if fOverdue:
import fbSettings

def compare(a, b):
# standard custom compare-two-value routine for use by built-in sort function
  return cmp(int(a), int(b)) # compare as integers
        
# user input
sProject = raw_input('Project to get: ')
sMilestone = raw_input('Milestone to get: ')
sFilename = "releasenotes_" + sProject + "_" + sMilestone + ".txt"

# FogBugz search string
sSearch = "project:\"" + sProject + "\" milestone:\"" + sMilestone + "\""

# open session with FogBugz using our API token
fb = FogBugz(fbSettings.URL, fbSettings.TOKEN)

# run the search
resp = fb.search(q=sSearch,cols='ixBug,sArea,sTitle,sReleaseNotes')

# list that we will read cases into
L = list()

# iterate over the returned list of cases and add those with release notes to the list
for case in resp.cases.childGenerator():
  myReleaseNote = case.sreleasenotes.string
  
  # just capture cases with release notes attached ('None' is the null result)
  if myReleaseNote != None:
    # add the case to the list
    L.append((case.sarea.string, case.ixbug.string, case.stitle.string.encode('UTF-8'), case.sreleasenotes.string.encode('UTF-8'))) #tuple
Example #28
0
    if branchPos is not -1:
        formattedText = formattedText[
            0:
            branchPos] + '<a href="' + gitweburl + '/gitweb/?p=' + reponame + ';a=shortlog;h=' + branchname + '">' + branchname + '</a>' + formattedText[
                branchPos + len(branchname):]
    return formattedText


def testFormatDescription():
    test1 = formatDescription(
        'quasar.git', 'https://gitweb.aphelion.se',
        'commit 3b22351959e1e0e7a5ef6d1c067ab3ca4b6d6c94\nAuthor: Patrik Hoglund <*****@*****.**>\nDate:  Mon Oct 1 13:06:34 2012 +0200\n\n    case 4669: Added cvs export to Fx Report view\n\nBranch: refs/heads/develop',
        '3b22351959e1e0e7a5ef6d1c067ab3ca4b6d6c94', 'refs/heads/develop')
    return test1


def editFBCase(site, username, password, case, change, changetext):
    fb = FogBugz('https://' + site + '.fogbugz.com/')
    fb.logon(username, password)

    logging.info('Updating fogbugz cases')

    fb.edit(ixBug=case, sEvent=changetext)

    fb.logoff()


desciption = testFormatDescription()
editFBCase('apehlion', '*****@*****.**', '#01APhelion', '4675',
           '3b22351959e1e0e7a5ef6d1c067ab3ca4b6d6c94', desciption)
Example #29
0
# Fill in the following values as appropriate to your installation
#S_FOGBUGZ_URL   = 'https://vsg.fogbugz.com/'
#S_EMAIL         = '*****@*****.**'
#S_PASSWORD      = '******'

#fb = FogBugz(S_FOGBUGZ_URL)
#fb.logon(S_EMAIL, S_PASSWORD)
'''
print fbSettings.URL
print fbSettings.TOKEN

SETTINGSFILE='fbSettings.py' # if this changes, also change the "import fbSettings" abvoe
SERVER='PC-Longphi'
DATABASE='FogBugz'

fb = FogBugz(fbSettings.URL, fbSettings.TOKEN)

'''
#Get all cases assigned to me
resp = fb.search(cols='ixBug,sTitle,dtDue')

print 'The following cases are overdue:'

for case in resp.cases.childGenerator():
    #Check to see if we have a due date
    if case.dtdue.string: 
        #All dates returned are UTC, so parse the due date
        #into a datetime object.
        dtDueUtc = datetime.strptime(case.dtdue.string,'%Y-%m-%dT%H:%M:%SZ')
        fOverdue = dtDueUtc <= datetime.utcnow()
        if fOverdue:
Example #30
0
    for ticket in db_entry:
        return ticket["related_to"]

def checkDupe(db_field,ticket_related):
    if db_field == ticket_related:
        print  "halt, this has happened before"
        return True
    else:
        print "no, update with the new db field"
        return False
"""

def updateRelated(new_ticket,ticket_related,editor,title):
    colorPrint(1, "updating " + ticket_related + " with " + new_ticket)
    response = fogbugz.edit(ixBug=ticket_related,sEvent=('case %s (%s) has been opened by %s' % (new_ticket, title, editor)))
    addRelated(new_ticket,ticket_related)

def addRelated(new_ticket,ticket_related):
    db['related_ticket'].update({"case_number":new_ticket},{'$set':{"related_to":ticket_related}}) 
    colorPrint(1,"Update the db")

if hasattr(fbSettings,'TOKEN'):
    fogbugz = FogBugz(fbSettings.URL, fbSettings.TOKEN)
else:
    fogbugz = FogBugz(fbSettings.URL)
    fogbugz.logon(fbSettings.LOGIN, fbSettings.PW)

if __name__ == '__main__':
   init()
   getTicketInfo()
Example #31
0
def main():
    fb = FogBugz(S_FOGBUGZ_URL)
    fb.logon(S_EMAIL, S_PASSWORD)

    # how ugly is this, do we export one bug or all?
    if EXPORT_BUG != 0:
        resp = fb.search(q=str(EXPORT_BUG), cols='ixBug', max=MAX_BUGS)
    else:
        resp = fb.search(q='type:"Cases"', cols='ixBug', max=MAX_BUGS)

    cases = resp.cases.findAll('case')
    num_cases = len(cases)
    counter = 0
    batch = 1
    issues = []

    components = []

    BACKUP_DIR = os.getcwd() + '/' + 'attachments'

    for case in cases:
        counter += 1
        print("Processing case: " + str(counter) + " of " + str(num_cases))
        ixBug = int(case['ixBug'])
        print(ixBug)
        respBug = fb.search(
            q='%s' % ixBug,
            cols=
            'sTitle,sPersonAssignedTo,sProject,sArea,sCategory,sPriority,fOpen,events'
        )
        xmlBug = respBug.cases.findAll('case')[0]

        issue = {}
        issue['externalId'] = int(xmlBug['ixBug'])
        issue['created'] = get_date_created(xmlBug)
        issue['summary'] = get_attribute(xmlBug, 'sTitle')
        issue['assignee'] = S_USER
        issue['reporter'] = S_USER
        component = get_attribute(xmlBug, 'sProject')
        issue['components'] = [component]
        # gathering all the components (Fogbugz projects) as we ecounter them
        if component not in components:
            components.append(component)
        issue['issueType'] = "Support"
        issue['priority'] = get_attribute(xmlBug, 'sPriority')
        issue['resolution'] = get_attribute(xmlBug, 'fOpen')
        issue['attachments'] = []
        issue['comments'] = get_events(xmlBug, issue, BACKUP_DIR)

        print(issue)
        print("Long body running count = " + str(len(LONG_BODY_COMMENTS)))
        print("Long body issues = " + str([c for c in LONG_BODY_COMMENTS]))

        issues.append(issue)

        if counter % BATCH_SIZE == 0:
            dump_json(batch, counter, components, issues)
            issues = []
            batch += 1

    # one last dump
    dump_json(batch, counter, components, issues)
Example #32
0
#Usage: python fogbugz_milestone.py --o old milestone -n new milestone
from fogbugz import FogBugz
import datetime
import re
import argparse
import json


parser = argparse.ArgumentParser(description='Docs docs docs these are my docs')
parser.add_argument('-o','--o_variable', type=str, help='Old Milestone name', required=True)
parser.add_argument('-n','--n_variable', type=str, help='New Milestone name', required=True)
args = parser.parse_args()


fb = FogBugz("https://sailthru.fogbugz.com/") 

# To run this needs a d.txt file that contains the json of: {"login":"******","pass":"******"}

with open('../d.txt') as json_data:
	data = json.load(json_data)
	login = data["login"]
	passw = data["pass"]
fb.logon(login,passw)


milestones = fb.listFixFors()

#this is not being used now ... it gets the most current milestone... i could probably trash it..
milestone_dates, sep, tail = milestones.sfixfor.renderContents().partition('T')
miled =  milestones.findAll('dt',limit=2)[1]
work = miled.renderContents().partition('T')
Example #33
0
 def __init__(self):
     self.config = yaml.load(file('bugzbot.conf', 'r'))
     self.fb = FogBugz(self.config['FOGBUGZ_URL'],
         self.config['FOGBUGZ_TOKEN'])
Example #34
0
            URL_FROM = raw_input(
                'set url from (eg. https://from.fogbugz.com): ')

        if EMAIL_FROM:
            print 'email from: ' + EMAIL_FROM
        else:
            EMAIL_FROM = raw_input('set email from (eg. [email protected]): ')

        if PASSWORD_FROM:
            print 'password from: ok'
        else:
            PASSWORD_FROM = raw_input('set password from: ')

        print '-----------------------------------------------------------'
        print 'Trying to login ........'
        fbz_from = FogBugz(URL_FROM)
        fbz_from.logon(EMAIL_FROM, PASSWORD_FROM)
        print 'ok'
    except BaseException or Exception:
        print '*** Cannot login to [{0}] ***'.format(URL_FROM)
        print 'copy aborted'
        sys.exit()

    print '-----------------------------------------------------------'

    try:
        print '** LOGIN DATA FOR ACCOUNT TO WHICH CASES WILL BE PASTED ***'
        if URL_TO:
            print 'url to: ' + URL_TO
        else:
            URL_TO = raw_input('set url to (eg. https://to.fogbugz.com): ')
# get the list of filters from FogBugz

from fogbugz import FogBugz
import fbSettings

# login
fb = FogBugz(fbSettings.URL, fbSettings.TOKEN)

# Get list of all filters
resp = fb.listFilters()

print "Raw response:"
print resp

print "\nPrettified response:"
print resp.prettify()
    
Example #36
0
def run():
    parser = argparse.ArgumentParser(description="JIRA to FogBugz importer")
    parser.add_argument('--jira-server',
                        help="JIRA server URL, ex. http://jira.example.com",
                        required=True)
    parser.add_argument('--jira-username', help="JIRA username", required=True)
    parser.add_argument('--jira-password', help="JIRA password", required=True)
    parser.add_argument('--jira-project',
                        help="Which jira project to read cases",
                        required=True)
    parser.add_argument('--jira-query',
                        help="Jql query filter (in addition to the project)",
                        required=False)
    parser.add_argument(
        '--fogbugz-server',
        help="FogBugz server URL, ex. http://example.fogbugz.com",
        required=True)
    parser.add_argument('--fogbugz-token',
                        help="FogBugz access token",
                        required=True)
    parser.add_argument('--fogbugz-project',
                        help="Which FogBugz project to put cases in",
                        required=True)
    parser.add_argument('--default-assignee',
                        help="The email of the default assignee",
                        required=True)
    # TODO: dynamically create projects based on JIRA data
    parser.add_argument('-v',
                        '--verbose',
                        dest="verbose",
                        action="store_true",
                        default=False,
                        help="Get more verbose output")
    args = parser.parse_args()

    try:
        try:
            jira = JIRA(options={'server': args.jira_server},
                        basic_auth=(args.jira_username, args.jira_password))
        except JIRAError as e:
            if e.status_code == 403:
                sys.stderr.write(
                    'Cannot connect to JIRA. Check username/password\n')
                sys.exit(1)
            else:
                msg = "Cannot connect to JIRA  (return code={0})".format(
                    e.status_code)
                if args.verbose:
                    msg += "\n{0}".format('Response from JIRA:\n{0}'.format(
                        e.text))
                sys.stderr.write(msg + '\n')
                sys.exit(1)
        try:
            fb = FogBugz(args.fogbugz_server, token=args.fogbugz_token)
        except FogBugzConnectionError as e:
            sys.stderr.write('Cannot connect to FogBugz {}\n'.format(e))
            sys.exit(1)
        except FobBugzLogonError:
            sys.stderr.write('Cannot login to FogBugz. Check token')
            sys.exit(1)

        # initialize an email to fogbugz User ID mapping
        email_map = {}
        resp = fb.listPeople(fIncludeActive=1,
                             fIncludeNormal=1,
                             fIncludeDeleted=1,
                             fIncludeVirtual=1)
        for person in resp.people.childGenerator():
            logging.debug("Found Fogbugz user {}".format(
                person.ixPerson.string))
            email_map[person.sEmail.string.lower()] = int(
                person.ixPerson.string)
        try:
            default_assignee = email_map[args.default_assignee.lower()]
        except KeyError:
            parser.error(
                "Default assignee {0} does not exist in FogBugz".format(
                    args.default_assignee))

        query = 'project = "{}"'.format(args.jira_project)
        if args.jira_query:
            query += "AND " + args.jira_query
        logging.debug("Using Jira query: '{}'".format(query))
        issues = get_jira_issues(jira, query)
        for issue in issues:
            fb_create_issue(fb, jira, issue, args.fogbugz_project, email_map,
                            default_assignee)
    except SystemExit:
        raise
    except:
        sys.stderr.write("Unknown error occurred\n")
        traceback.print_exc(sys.stderr)
        sys.exit(1)
    return sys.exit(0)
Example #37
0
import fbSettings
from fogbugz import FogBugz
from datetime import datetime, timedelta
from pytz import timezone
from decimal import *
import pytz
import csv

fb = FogBugz(fbSettings.URL, fbSettings.TOKEN)

# Use correct timezone
userTimezone = timezone("Australia/Sydney")

# Localized dates according to user's timezones
# Midnight 14th
startDateLocal = userTimezone.localize(datetime(2012, 05, 14, 0, 0))
# 11.59pm 19th
endDateLocal = userTimezone.localize(datetime(2012, 05, 19, 23, 59))

# API expects UTC dates so convert
utc = pytz.utc
startDateUTC = utc.normalize(startDateLocal.astimezone(utc))
endDateUTC = utc.normalize(endDateLocal.astimezone(utc))

# Expected format by API
formatString = "%Y-%m-%dT%H:%M:%SZ"

# Logged-in user's timesheet
response = fb.listIntervals(dtStart=startDateUTC.strftime(formatString), dtEnd=endDateUTC.strftime(formatString))

# Reference of cases and their project
# set the current filter to a saved one
# and then retrieve all the cases associated with that filter
#
# the filter is set by number, which has to be looked up by a separate XML query (see get_filter_list.py)

from fogbugz import FogBugz
import fbSettings

# login
fb = FogBugz(fbSettings.URL, fbSettings.TOKEN)

# Set filter
resp = fb.setCurrentFilter(sFilter='65',) # filter id 65 the arbitary filter picked in this example

# Get results
resp = fb.search(cols='ixBug,sTitle,sFixFor,sArea')

print "Raw response:"
print resp

print "\nPrettified response:"
print resp.prettify()
    
print "\nParsed response via Beautiful Soup:"
for case in resp.cases.childGenerator():
  print case.ixbug.string, case.stitle.string.encode('UTF-8'), case.sfixfor.string, case.sarea.string
Example #39
0
class Bugz(object):

    def __init__(self):
        self.config = yaml.load(file('bugzbot.conf', 'r'))
        self.fb = FogBugz(self.config['FOGBUGZ_URL'],
            self.config['FOGBUGZ_TOKEN'])

    def returnUser(self, _semail):
        self.user = self.fb.viewPerson(semail=_semail)
        try:
            self.fb_user = self.user.people.person.sfullname.string
            return self.fb_user
        except AttributeError:
            return "User not found"

    def assignTicket(self, ticket_num, user, orig_user):
        self.touser = self.returnUser(user)
        print user
        print self.touser
        if self.touser != "User not found":
            self.event = "This ticket was assigned to you by slack user " + \
                orig_user[1] + " courtesy of bugzbot!"
            self.fb.edit(ixBug=ticket_num,
                sPersonAssignedTo=self.touser,
                sEvent=self.event)

            self.checker = self.fb.search(q=ticket_num, cols="ixPersonAssignedTo")
            print self.checker

            if self.checker.cases.case.ixpersonassignedto.string != "93":
                return "success"
            else:
                return "One of us screwed up. I got stuck with the ticket somehow." \
                    "Please follow up and manually assign the ticket so it does not get lost in the shuffle!"
        else:
            return "Fogbugz user was not found. Please try again."

    def returnTicket(self, option, ticket_num):
        if option:
            self.retrieve_ticket = self.fb.search(q=ticket_num,
                cols='ixBug,sTitle,sProject')

            if self.retrieve_ticket.cases['count'] == str(1):

                self.ticket_title = self.retrieve_ticket.cases.case.stitle.string
                self.ticket_project = self.retrieve_ticket.cases.case.sproject.string
                self.ticket_URL = "https://tenthwave.fogbugz.com/f/cases/" + ticket_num

                self.ticket = "Ticket: " + ticket_num + "  |  " + self.ticket_title + \
                    "\n\n" + self.ticket_URL
                print self.ticket
                return self.ticket
            else:
                msg = "Something went wrong! Either Fogbugz is down, you're a magician calling a number " \
                    "that does not exist yet, or it somehow returned more than one ticket."
                print msg
                return msg
        else:
            self.retrieve_ticket = self.fb.search(
                q=ticket_num,
                cols="ixBug,sTitle,sLatestTextSummary,sArea,sProject")

            if self.retrieve_ticket.cases['count'] == str(1):

                self.ticket_title = self.retrieve_ticket.cases.case.stitle.string
                self.ticket_area = self.retrieve_ticket.cases.case.sarea.string
                self.ticket_project = self.retrieve_ticket.cases.case.sproject.string
                self.ticket_URL = "https://tenthwave.fogbugz.com/f/cases/" + ticket_num
                self.ticket_last_update = self.retrieve_ticket.cases.case.slatesttextsummary.string

                self.ticket = self.ticket_URL + "\n\nTicket: " + ticket_num + "\n" + self.ticket_project + \
                    " : " + self.ticket_area + "\n*" + self.ticket_title + "*\n\n" + self.ticket_last_update
                print self.ticket
                return self.ticket
            else:
                msg = "Something went wrong! Either Fogbugz is down, you're a magician calling a number " \
                    "that does not exist yet, or it somehow returned more than one ticket."
                print msg
                return msg
Example #40
0
        else:
            URL_FROM = raw_input('set url from (eg. https://from.fogbugz.com): ')

        if EMAIL_FROM:
            print 'email from: ' + EMAIL_FROM
        else:
            EMAIL_FROM = raw_input('set email from (eg. [email protected]): ')

        if PASSWORD_FROM:
            print 'password from: ok'
        else:
            PASSWORD_FROM = raw_input('set password from: ')

        print '-----------------------------------------------------------'
        print 'Trying to login ........'
        fbz_from = FogBugz(URL_FROM)
        fbz_from.logon(EMAIL_FROM, PASSWORD_FROM)
        print 'ok'
    except BaseException or Exception:
        print '*** Cannot login to [{0}] ***'.format(URL_FROM)
        print 'copy aborted'
        sys.exit()

    print '-----------------------------------------------------------'

    try:
        print '** LOGIN DATA FOR ACCOUNT TO WHICH CASES WILL BE PASTED ***'
        if URL_TO:
            print 'url to: ' + URL_TO
        else:
            URL_TO = raw_input('set url to (eg. https://to.fogbugz.com): ')
# Change the specified case's milestone ("Fixfor" in fogbugz API parlance)
# This will change a case's milestone even if the case is closed
# This is a fast way to change case milestones, especially for 
# closed cases that the UI forces you to reopen before editing

from fogbugz import FogBugz
from datetime import datetime, timedelta
import fbSettings

# user input
sCase = raw_input('Case #: ')
sMilestone = raw_input('New milestone: ')

# open session with FogBugz using our API token
fb = FogBugz(fbSettings.URL, fbSettings.TOKEN)

# update the case
try:
	resp = fb.edit(ixBug=sCase, sFixFor=sMilestone)
except:
    print "Update not performed - Error from FogBugz"

print "Done"
Example #42
0
# Usage: python milestone_manager.py -p <Project> -m <Milestone Name> (optional: rm True | False (default is false))
# todo: handling of adding milestones that have been deleted.
import fbSettings
from fogbugz import FogBugz
import argparse

fogbugz = FogBugz(fbSettings.URL)
fogbugz.logon(fbSettings.Login, fbSettings.pw)

parser = argparse.ArgumentParser(
    description="Usage: python milestone_maker -p <Project> -m <Milestone Name> -rm True|False (Default is false)"
)
parser.add_argument("-p", "--project", type=str, help="Project Name", required=True)
parser.add_argument("-m", "--milestone", type=str, help="New Milestone name", required=True)
parser.add_argument("-rm", "--delete", type=bool, help="Delete the milestone", default=False, required=False)
args = parser.parse_args()

project_map = {}
projects = fogbugz.listProjects()
for item in projects.findAll("project"):
    proj_number = item.ixproject.string.encode("UTF-8")
    proj_name = item.sproject.string.encode("UTF-8")
    project_map.update({proj_name: proj_number})

milestone_map = {}
milestones = fogbugz.listFixFors()
for item in milestones.findAll("fixfor"):
    milestone_number = item.ixfixfor.string.encode("UTF-8")
    milestone_name = item.sfixfor.string.encode("UTF-8")
    milestone_map.update({milestone_name: milestone_number})
try:
Example #43
0
        article_ids = get_article_ids(fb, wiki_id)
        for article_id in article_ids:
            article = fb.viewArticle(ixWikiPage=article_id)

            headline = article.wikipage.sHeadline.string
            body = article.wikipage.sBody.string
            print(headline)

            filename = headline.replace('/', '') + '.html'
            path = os.path.join(wiki_name, filename)

            # Block for just writing out HTML
            if False:
                with open(path, 'w') as f:
                    try:
                        f.write(body)
                    except:
                        print("Unable to write {} - {}".format(wiki_name, headline))

            # Convert to markdown and write
            try:
                output = pypandoc.convert_text(body, to='md', format='html',
                                               outputfile=path)
            except:
                print("Unable to write {} - {}".format(wiki_name, headline))

if __name__ == '__main__':
    fb = FogBugz(fbSettings.URL, fbSettings.TOKEN)
    download_wikis(fb)
Example #44
0
import FbNotifier_UI
from tactic_client_lib import TacticServerStub
import Skype4Py
from PySide import QtCore, QtGui

server = TacticServerStub(setup=False)

tactic_server_ip = socket.gethostbyname("vg.com")

server.set_server(tactic_server_ip)
server.set_project("simpleslot")
ticket = server.get_ticket("julio", "1234")
server.set_ticket(ticket)

fb = FogBugz("https://fb.vir888.com")
fb.logon("ART-Julio", "chicago")


class MainWindow(QtGui.QDialog):
    def __init__(self, parent=None):
        super(MainWindow, self).__init__(parent)
        self.ui = FbNotifier_UI.Ui_FbNotifier()
        self.ui.setupUi(self)
        self.ui.pushButton.clicked.connect(self.listen)
        self.ui.tableWidget.setColumnWidth(0, 150)
        self.ui.tableWidget.setColumnWidth(1, 390)
        self.ui.tableWidget.setColumnWidth(2, 80)
        self.ui.tableWidget.setColumnWidth(3, 80)
        self.ui.tableWidget.setColumnWidth(4, 80)
Example #45
0
import settings

from optparse import OptionParser

parser = OptionParser()
parser.add_option('-s', '--search', dest='search',
        help="Search for the given keywords", metavar="KEYWORDS")

(options, args) = parser.parse_args()

print options
print args

from fogbugz import FogBugz

fb = FogBugz(settings.url)
fb.logon(settings.user_email, settings.user_pass)

if options.search:
    resp = fb.search(q=settings.default_search_prefix + options.search,
                     cols="sTitle,ixPriority,hrsOrigEst,hrsCurrEst,hrsElapsed,ixBugParent"
           )

    for case in resp.cases.childGenerator():
        print case['ixbug'], case.stitle.string
        print case
Example #46
0
import fbSettings
from fogbugz import FogBugz
from random import choice
from random import shuffle
from time import sleep
from time import strftime

IX_PERSON_UP_FOR_GRABS = 53 # the ixPerson value of the Up For Grabs user
IX_AREA_SUPPORT        = 36 # the ixArea value of the cases in your support queue
REPS = { 25 : ['Danny Test',1],     # a list of team members, using this format:
     52 : ['Eric Test', 1]}       # { ixPerson : [name, weight]...

#Log onto FogBugz 
print "Logging in..."
fogbugz = FogBugz(fbSettings.URL)
fogbugz.logon(fbSettings.Login, fbSettings.pw)
assignment = {}
#Add users and current assignment count to dictionary.
for rep in REPS:
  searchString = 'assignedto: "=%s" status:"Reviewed"' % (rep)
  num = str(fogbugz.search(q=searchString)).split('"')
  assignment[rep] = num[1]
for user in assignment:
  print user, "has", assignment[user], "assignment(s)!"
#Code for assignment is only scaleable up to this point. Per convo w/ Danny, we will review this and make necessary edits once we hire more automation engineers.
sum = int(assignment.values()[0])-int(assignment.values()[1])
#Obtain all tickets assigned to our main QA user.
searchString = 'assignedto: "=%s"' % (IX_PERSON_UP_FOR_GRABS)
grabs = fogbugz.search(q=searchString)
tickets = []
Example #47
0
def getFogBugzConnection(url, token):
    return FogBugz(url, token)
Example #48
0
def main():
    print("Started the program... ")
    print(str(datetime.now().strftime(FORMAT_OF_DATE)))
    start = time.time()
    sheets = initgooglesheets()

    # Fogbugz stuff
    fb = FogBugz(getpath(), getapikey(), api_version=8)

    # ----------------------------------------------------------------------------------------------------------
    # Getting Day0
    print('Query set to day0')
    query = getday0()
    resultListOfCases = getcaseslist(fb, query)

    firstTimeWriting = False
    listLength = str(len(resultListOfCases))
    oldestCaseDate = resultListOfCases[0].lastUpdated

    # Calling all the information gathering functions
    writeoldestcases(sheets, resultListOfCases, 3, 1)
    writefiltercount(firstTimeWriting, sheets, datetime.now(), listLength, 10,
                     1, 500)
    writeday0age(sheets, oldestCaseDate, 10, 1, 7)
    print('Day 0 query finished')
    # ----------------------------------------------------------------------------------------------------------

    # ----------------------------------------------------------------------------------------------------------
    # Continuing non day0 queues
    # -----------------------------------------------------------------------------------------------------------
    # Getting oldest cases assigned to us without update
    print('Query set to oldest case without update')
    query = getoldestcasesnoupdate()
    resultListOfCases = getcaseslist(fb, query)
    oldestCaseDate = resultListOfCases[0].lastUpdated

    # Calling all the information gathering functions
    writeoldestcases(sheets, resultListOfCases, 3, 8)
    writeoldestcasenoupdateage(sheets, oldestCaseDate, 10, 8, 10)
    print('Oldest cases without an update query finished')
    # ----------------------------------------------------------------------------------------------------------

    # ----------------------------------------------------------------------------------------------------------
    # Getting pro filter cases
    print('Query set to pro filter')
    query = getprofilter()
    resultListOfCases = getcaseslist(fb, query)
    listLength = str(len(resultListOfCases))

    # Calling all the information gathering functions
    # writeoldestcases(sheets, resultListOfCases, 3, 15)
    writefiltercount(True, sheets, datetime.now(), listLength, 10, 15, 0)
    print('Pro filter query finished')
    # ----------------------------------------------------------------------------------------------------------
    # Getting oldest resolved cases assigned to us
    print('Query set to oldest cases resolved and assigned to us')
    query = getoldestresolvedcases()
    resultListOfCases = getcaseslist(fb, query)
    oldestCaseDate = resultListOfCases[0].lastUpdated

    # Calling all the information gathering functions
    writeoldestcases(sheets, resultListOfCases, 3, 22)
    writeoldestcasenoupdateage(sheets, oldestCaseDate, 10, 22, 30)
    print('Oldest resolved cases without an update query finished')
    # ----------------------------------------------------------------------------------------------------------
    writecrashnoncrashteams(sheets, fb, 3, 30)
    # ----------------------------------------------------------------------------------------------------------
    # ----------------------------------------------------------------------------------------------------------

    print('Data writing to Sheets finished')
    end = time.time()
    print('Finished program. Time spent: ' + str(end - start))
    print(str(datetime.now().strftime(FORMAT_OF_DATE)))