Exemplo n.º 1
0
    def prep_sprint(self):
        # incoming sprint: snapshot_phase=1 (start), from_roadmap=1
        print "Preparing Sprint %s" % self.cur_sprint_id

        self.ensure_not('prepared', self.cur_sprint_id)

        ## change title to todays date
        board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
        # no method for setting name, use client directly
        board.client.fetch_json(
            '/boards/' + board.id + '/name',
            http_method='PUT',
            post_args={'value': 'Current Sprint %s' % self.cur_sprint_id, }, )

        ## right shift sprint roadmap, bring into current sprint
        rm_board = Board(self.client, board_id=self.SPRINT_RM_BOARD_ID)
        rm_lists = rm_board.open_lists()
        rm_list_map = {l.name: l.id for l in rm_lists}
        from_rm_cards = []
        for l in reversed(rm_lists):
            # leave any non S + N lists alone
            if not l.name.startswith('S +'):
                continue
            if l.name == 'S + 1':
                # capture this card list so we can mark from_roadmap correctly
                from_rm_cards = l.list_cards()
                # send to sprint
                board_id = self.SPRINT_BOARD_ID
                list_id = self.list_ids['New']
            else:
                # send to next col
                board_id = self.SPRINT_RM_BOARD_ID
                n_id = int(l.name[-1:])
                list_id = rm_list_map['S + %s' % str(n_id-1)]
            l.client.fetch_json(
                '/lists/' + l.id + '/moveAllCards',
                post_args={'idBoard': board_id, 'idList': list_id},
                http_method='POST')

        ## capture tickets coming in from roadmap (so we can figure out which were added ad hoc after sprint start)
        c = self._db.cursor()
        try:
            for card in from_rm_cards:
                card.fetch(True)
                # if we are doing default due dates, add now if it doesn't exist
                if card.due is None and DEFAULT_DUE_DATE:
                    card.set_due(self.cur_sprint_start + DEFAULT_DUE_DATE)
                self.write_card(card)
                # write them to state
                c.execute('''insert into sprint_state values (?, ?, ?, ?, ?)''',
                          (self.cur_sprint_id, card.list_id, card.id, 1, 1))
        except Exception as e:
            print "ROLLING BACK"
            self._db.rollback()
            raise e

        c.close()

        self.set_sprint_flag('prepared', self.cur_sprint_id)
        self._db.commit()
Exemplo n.º 2
0
def create_cowley_trello(board: trello.Board):
    ward_name = 'Cowley'
    # board.add_list('Resources')
    # board.add_list('Done')
    # board.add_list('Help Needed!')
    # board.add_list('On Going')
    # board.add_list('This Week')
    # board.add_list('Backlog')
    #
    # board.add_label('Goal', 'green')
    # board.add_label('Date', 'black')
    board.add_label('Event', 'red')

    # create_dates.create_dates(board, datetime.date(year=2019, month=8, day=19), datetime.date(2020, 5, 7), 7)
    #
    # sorry_we_missed_you_card.produce_sorry_we_missed_you_card(board)
    #
    # ward_newsletter.create_ward_newsletter(datetime.date(year=2019, month=9, day=8), board, 'Cowley')
    # ward_newsletter.create_ward_newsletter(datetime.date(year=2019, month=10, day=27), board, 'Cowley')
    # ward_newsletter.create_ward_newsletter(datetime.date(year=2019, month=12, day=1), board, 'Cowley')
    # ward_newsletter.create_ward_newsletter(datetime.date(year=2020, month=1, day=26), board, 'Cowley')
    #
    # targetted_letter.create_targetted_letter(datetime.date(year=2019, month=12, day=10), board, 'Cowley')

    action_day.create_action_day(datetime.date(year=2019, month=8, day=24),
                                 board, 'Cowley')
    action_day.create_action_day(datetime.date(year=2019, month=10, day=19),
                                 board, 'Cowley')
    action_day.create_action_day(datetime.date(year=2020, month=1, day=18),
                                 board, 'Cowley')

    create_dates.sort_board(board)
Exemplo n.º 3
0
def collect_cards(requester, db_board, board_name, board_members, all_lists):
    trello_client = init_trello_client(requester)
    # make an instance of py-trello's Board object to have access to relevant api calls
    board = Board(client=trello_client, board_id=db_board.trello_board_id)
    board.name = board_name
    # load all checklists
    checklists = defaultdict(list)
    for cl in board.get_checklists():
        checklists[cl.card_id].append(cl)
    open_cards = collect_cards_internal(requester, board, board_members, checklists, all_lists, card_status='open')
    # request closed cards separately to have a better chance to index all open cards
    # (thus avoiding hitting rate limits already in open cards indexing)
    collect_cards_internal(requester, board, board_members, checklists, all_lists, card_status='closed')

    # update board lists with a list of cards
    lists_with_cards = defaultdict(list)
    for ac in open_cards:
        lists_with_cards[ac.idList].append({
            'id': ac.id,
            'name': ac.name,
            'pos': ac.pos,
            'url': ac.url
        })
    board_lists = db_board.trello_content.get('lists', [])
    for bl in board_lists:
        bl.update({
            'cards': sorted(lists_with_cards[bl['id']], key=itemgetter('pos'))
        })
    db_board.trello_content = {
        'description': db_board.trello_content.get('description'),
        'lists': board_lists
    }
    db_board.save()
    algolia_engine.sync(db_board, add=False)
Exemplo n.º 4
0
 def show(self):
     board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
     lists = board.open_lists()
     list_map = {}
     for l in lists:
         cards = l.list_cards()
         list_map[l.name] = [c.name for c in cards]
     print list_map
Exemplo n.º 5
0
 def show(self):
     board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
     lists = board.open_lists()
     list_map = {}
     for l in lists:
         cards = l.list_cards()
         list_map[l.name] = [c.name for c in cards]
     print list_map
Exemplo n.º 6
0
 def new_board(self, board):
     # Connect to Trello and save the new board
     trello_board = TrelloBoard(client=self.trello_client)
     trello_board.name = board.name
     trello_board.description = board.description
     trello_board.save()
     board.uuid = trello_board.id
     return board
Exemplo n.º 7
0
def clear_board(board: trello.Board):
    for list in board.get_lists('all'):
        list.archive_all_cards()
        list.close()

    preexisting_labels = board.get_labels()
    if preexisting_labels:
        for label in preexisting_labels:
            board.delete_label(label.id)
Exemplo n.º 8
0
 def extract_board_info(board: Board):
   print('== Members')
   for member in board.all_members():
     print('{0}({1}) : {2}'.format(member.full_name, member.username, member.id))
   print('== Labels')
   for label in board.get_labels():
     print('[{0}]{1} : {2}'.format(label.color, label.name, label.id))
   print('== Lists')
   for list in board.list_lists():
     print('{0} : {1}'.format(list.name, list.id))
Exemplo n.º 9
0
 def capture_sprint(self, sprint_id, snapshot_phase):
     board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
     cards = board.open_cards()
     c = self._db.cursor()
     # make sure cards exist
     for card in cards:
         self.write_card(card)
         # write them to state
         c.execute('''insert or ignore into sprint_state values (?, ?, ?, ?, ?)''',
                   (sprint_id, card.list_id, card.id, snapshot_phase, 0))
     c.close()
Exemplo n.º 10
0
Arquivo: tix.py Projeto: nsone/trello
 def list_tix(self):
     board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
     cards = board.open_cards()
     lists = board.open_lists()
     list_names = {l.id: l.name for l in lists}
     for c in cards:
         c.fetch(True)
         if self.me.id in c.member_ids:
             feature_id = c.shortUrl[-8:]
             print "%s | %s: %s | %s | %s" % (feature_id, c.name, c.desc[0:30],
                                              list_names[c.list_id], c.shortUrl)
Exemplo n.º 11
0
Arquivo: tix.py Projeto: nsone/trello
 def list_tix(self):
     board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
     cards = board.open_cards()
     lists = board.open_lists()
     list_names = {l.id: l.name for l in lists}
     for c in cards:
         c.fetch(True)
         if self.me.id in c.member_ids:
             feature_id = c.shortUrl[-8:]
             print "%s | %s: %s | %s | %s" % (
                 feature_id, c.name, c.desc[0:30], list_names[c.list_id],
                 c.shortUrl)
def main(api_key, token, board_id):
    """List out the board lists for our client"""
    trello_client = TrelloClient(
        api_key=api_key,
        token=token,
    )
    board = Board(client=trello_client, board_id=board_id)
    print('Lists')
    print('-----')
    print('Name: Id')
    for card_list in board.all_lists():
        print('{card_list.name}: {card_list.id}'.format(card_list=card_list))
Exemplo n.º 13
0
def main(api_key, token, board_id):
    """List out the board lists for our client"""
    trello_client = TrelloClient(
        api_key=api_key,
        token=token,
    )
    board = Board(client=trello_client, board_id=board_id)
    print('Lists')
    print('-----')
    print('Name: Id')
    for card_list in board.all_lists():
        print('{card_list.name}: {card_list.id}'.format(card_list=card_list))
Exemplo n.º 14
0
def get_list_id(list_name):
    board = Board(TRELLO_CLIENT, BOARD_ID_LONG_IDEAS)
    lists = board.all_lists()
    for x in lists:
        if x.name.lower() == list_name.lower():
            return x.id
    board = Board(TRELLO_CLIENT, BOARD_ID_LONG_OBSV)
    lists = board.all_lists()
    for x in lists:
        if x.name.lower() == list_name.lower():
            return x.id
    return None
Exemplo n.º 15
0
 def capture_sprint(self, sprint_id, snapshot_phase):
     board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
     cards = board.open_cards()
     c = self._db.cursor()
     # make sure cards exist
     for card in cards:
         self.write_card(card)
         # write them to state
         c.execute(
             '''insert or ignore into sprint_state values (?, ?, ?, ?, ?)''',
             (sprint_id, card.list_id, card.id, snapshot_phase, 0))
     c.close()
Exemplo n.º 16
0
def setup(trello_key, trello_secret, board_id, out, delimiter, card_extractors,
          filters):
    # validate inputs

    if not trello_key or not trello_secret:
        raise click.BadParameter('trello_secret and trello_key are required')

    if not board_id:
        raise click.BadParameter('board_id is required')

    trello_client = TrelloClient(
        api_key=trello_key,
        api_secret=trello_secret,
    )
    data_provider = DataProvider(Board(
        trello_client,
        board_id=board_id,
    ))
    print(data_provider.board.name)  # TODO: add logging
    database = DataBase(delimiter=delimiter)
    runner = Runner(data_provider,
                    database,
                    card_extractors_parameter=[
                        Parameter(x.strip())
                        for x in card_extractors.split(',')
                    ],
                    filters=[Parameter(x.strip())
                             for x in filters.split(',')] if filters else [])
    runner.run()
    database.export(out)
Exemplo n.º 17
0
def get_lists(names: List[str], board: trello.Board) -> List[trello.List]:
    """returns the Trello lists from the Trello board"""
    lists: List[trello.List] = []
    for t_list in board.list_lists():
        if t_list.name in names:
            lists.append(t_list)
    return lists
Exemplo n.º 18
0
def make_trello_card(*args, **kwargs):
    """Generate a new Trello card"""
    # Generate our card board and list
    # DEV: board is never used...
    # TODO: This is very backwards with needing a board to get a client...
    #   Might move to another lib
    # https://github.com/sarumont/py-trello/blob/0.4.3/trello/trellolist.py#L11-L20
    # https://github.com/sarumont/py-trello/blob/0.4.3/trello/trellolist.py#L48-L63
    board = Board(client=trello_client, board_id=TRELLO_BOARD_ID)
    card_list = List(board=board, list_id=TRELLO_LIST_ID)
    return card_list.add_card(*args, **kwargs)
Exemplo n.º 19
0
def get_list(name: str, board: trello.Board) -> trello.List:
    """
    Find  an open Trello list of the specified name
    :param name: The name of the list
    :param board: The board
    :return: The list
    """
    for trello_list in board.get_lists('open'):
        if trello_list.name == name:
            return trello_list
    return None
Exemplo n.º 20
0
def archive_cards(board_name="Private", list_name="Done", days=1):
    """ archive cards """
    username, key, token = util.get_credential()

    client = TrelloClient(key, token)

    # Get board
    boards = get_boards(username, client)
    board_id = boards[board_name]
    board = Board(board_id, client)

    # Get board
    lists = board.get_lists()
    list_done = [x for x in lists if x.name == list_name][0]
    cards = list_done.get_cards()

    target = datetime.datetime.now(pytz.utc) - datetime.timedelta(days=days)

    for card in _filter_cards(cards, target):
        card.set_closed("true")
        logger.debug(card)
Exemplo n.º 21
0
    def finish_sprint(self):

        print "Finishing Sprint %s" % self.last_sprint_id

        self.ensure('prepared', self.last_sprint_id)
        self.ensure('started', self.last_sprint_id)
        self.ensure_not('finished', self.last_sprint_id)

        # outgoing sprint: snapshot_phase=2 (finish)
        try:
            self.capture_sprint(self.last_sprint_id, snapshot_phase=FINISH)
        except Exception as e:
            print "ROLLING BACK"
            self._db.rollback()
            raise e
        self.set_sprint_flag('finished', self.last_sprint_id)
        self._db.commit()

        # archive all cards in Done column
        board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
        done_list = board.get_list(self.list_ids['Done'])
        done_list.archive_all_cards()
Exemplo n.º 22
0
    def finish_sprint(self):

        print "Finishing Sprint %s" % self.last_sprint_id

        self.ensure('prepared', self.last_sprint_id)
        self.ensure('started', self.last_sprint_id)
        self.ensure_not('finished', self.last_sprint_id)

        # outgoing sprint: snapshot_phase=2 (finish)
        try:
            self.capture_sprint(self.last_sprint_id, snapshot_phase=FINISH)
        except Exception as e:
            print "ROLLING BACK"
            self._db.rollback()
            raise e
        self.set_sprint_flag('finished', self.last_sprint_id)
        self._db.commit()

        # archive all cards in Done column
        board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
        done_list = board.get_list(self.list_ids['Done'])
        done_list.archive_all_cards()
Exemplo n.º 23
0
 def populate_tables(self):
     c = self._db.cursor()
     # version the db
     c.execute('insert or replace into version values (1)')
     # ensure we have all the lists
     board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
     lists = board.open_lists()
     for l in lists:
         c.execute('''insert or replace into lists values (?, ?)''',
                   (l.id, l.name))
         self.list_ids[l.name] = l.id
         self.list_names_by_id[l.id] = l.name
     # make sure this and next sprint are in sprints table
     c.execute(
         '''insert or ignore into sprints values (?, ?, ?, 0, 0, 0)''',
         (self.cur_sprint_id, self.cur_sprint_start,
          self.next_sprint_start - datetime.timedelta(days=1)))
     c.execute(
         '''insert or ignore into sprints values (?, ?, ?, 0, 0, 0)''',
         (self.next_sprint_id, self.next_sprint_start,
          self.next_sprint_end))
     self._db.commit()
     c.close()
Exemplo n.º 24
0
 def populate_tables(self):
     c = self._db.cursor()
     # version the db
     c.execute('insert or replace into version values (1)')
     # ensure we have all the lists
     board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
     lists = board.open_lists()
     for l in lists:
         c.execute('''insert or replace into lists values (?, ?)''', (l.id, l.name))
         self.list_ids[l.name] = l.id
         self.list_names_by_id[l.id] = l.name
     # make sure this and next sprint are in sprints table
     c.execute('''insert or ignore into sprints values (?, ?, ?, 0, 0, 0)''',
               (self.cur_sprint_id,
                self.cur_sprint_start,
                self.next_sprint_start -
                datetime.timedelta(days=1)))
     c.execute('''insert or ignore into sprints values (?, ?, ?, 0, 0, 0)''',
               (self.next_sprint_id,
                self.next_sprint_start,
                self.next_sprint_end))
     self._db.commit()
     c.close()
Exemplo n.º 25
0
def get_counts(client, board_id, monitor_lists, done_list, start_day):
    """
    Get List data
    :param client: Trello client Object
    :param board_id: Trello Board ID
    :param monitor_lists: Trello monitor lists from PowerUp Data
    :param start_day: Start day of the Sprint. Eg: Monday
    :return: returns count of User Stories/Defects remaining and completed
    """
    stories_defects_remaining = 0
    stories_defects_done = 0
    tasks_remaining = 0
    ideal_tasks_remaining = 0

    board_object = Board(client, board_id=board_id)
    board_cards = board_object.get_cards()

    for monitor_list in monitor_lists:
        for board_card in board_cards:
            if board_card.idList == monitor_list:
                if board_card.name[:2] in 'T ':
                    tasks_remaining += 1
                elif board_card.name[:2] in ('U ', 'D ', 'C '):
                    stories_defects_remaining += 1
    else:
        for board_card in board_cards:
            if board_card.idList == done_list:
                if board_card.name[:2] in ('U ', 'D ', 'C '):
                    stories_defects_done += 1
                if current_day == start_day:
                    if board_card.name[:2] in 'T ':
                        ideal_tasks_remaining += 1

    if current_day == start_day:
        ideal_tasks_remaining += tasks_remaining

    return stories_defects_remaining, stories_defects_done, tasks_remaining, ideal_tasks_remaining
Exemplo n.º 26
0
def getRecruitmentBoard(configurationFileName='api.json'):
    api = {}

    # In[1]:
    with open(configurationFileName) as json_file:
        api = json.load(json_file)
    # In[2]:

    client = TrelloClient(api_key=api["api_key"],
                          api_secret=api["api_secret"],
                          token=api["token"])
    all_boards = client.list_boards()
    last_board = all_boards[-1]
    recruitment = Board()
    for board in all_boards:
        if board.name == api["recruitment_board_name"]:
            recruitment = board
    print(recruitment.name)
    return recruitment
Exemplo n.º 27
0
def get_cards_with_label(label: trello.Label, board: trello.Board):
    return filter(lambda card: card.labels and label in card.labels,
                  board.get_cards())
Exemplo n.º 28
0
#!/usr/bin/env PYTHONIOENCODING=UTF-8 python
# -*- coding: utf-8 -*-

from trello import TrelloClient, get_boards
from trello import Board
import util

CONFIG = "./config.cfg"

if __name__ == u"__main__":
    username, key, token = util.get_credential()

    client = TrelloClient(key, token)

    # Get "Private" board
    boards = get_boards(username, client)
    board_id = boards["Private"]
    board = Board(board_id, client)

    # Get "Doing" board
    lists = board.get_lists()

    # Get current card
    cards = lists[1].get_cards()
    try:
        print(cards[0].name)
    except:
        print("nothing :)")
Exemplo n.º 29
0
def create_holywell_campaign_board(board: trello.Board):
    clear_board(board)
    ward_name = 'Holywell'

    board.add_list('Resources')
    board.add_list('Done')
    board.add_list('Help Needed!')
    board.add_list('On Going')
    board.add_list('This Week')
    board.add_list('Backlog')

    board.add_label('Goal', 'green')
    board.add_label('Date', 'black')
    board.add_label('Event', 'red')

    # Michalemas
    create_dates.create_dates(board, datetime.date(year=2019, month=11, day=3),
                              datetime.date(year=2019, month=12, day=1), 7)
    create_dates.create_date(board, datetime.date(year=2019, month=12, day=7),
                             'End of Michaelmas (1st) Term')

    # Christmas
    create_dates.create_dates(board, datetime.date(year=2019, month=12,
                                                   day=14),
                              datetime.date(year=2020, month=1, day=12), 7)

    # Hilary
    create_dates.create_date(board, datetime.date(year=2020, month=1, day=19),
                             'Start of Hilary (2nd) Term')
    create_dates.create_dates(board, datetime.date(year=2020, month=1, day=26),
                              datetime.date(year=2020, month=3, day=7), 7)
    create_dates.create_date(board, datetime.date(year=2020, month=3, day=14),
                             'End of Hilary (2nd) Term')

    # Easter

    create_dates.create_dates(board, datetime.date(year=2020, month=3, day=21),
                              datetime.date(year=2020, month=4, day=19), 7)

    # Trinity
    create_dates.create_date(board, datetime.date(year=2020, month=4, day=26),
                             'Start of Trinity (3rd) Term')
    create_dates.create_date(board, datetime.date(year=2020, month=5, day=7),
                             'Start of Trinity (3rd) Term')

    ward_newsletter.create_student_leaflet(
        datetime.date(year=2019, month=12, day=6), board, ward_name,
        'MT Term Leaflet')
    ward_newsletter.create_student_leaflet(
        datetime.date(year=2020, month=1, day=26), board, ward_name,
        'HT Term Welcome Back Leaflet')
    ward_newsletter.create_student_leaflet(
        datetime.date(year=2020, month=2, day=23), board, ward_name,
        'HT Half-Term Leaflet')
    ward_newsletter.create_student_leaflet(
        datetime.date(year=2020, month=3, day=13), board, ward_name,
        'End of HT Leaflet')

    create_custom_card(board, 'Set up social media accounts',
                       datetime.date(year=2019, month=11, day=9),
                       datetime.date(year=2019, month=10, day=28),
                       "Set up a FB page for both candidates. ")
    create_custom_card(
        board, 'Get an approved budget for this campaign plan',
        datetime.date(year=2019, month=11, day=9),
        datetime.date(year=2019, month=10, day=28),
        "See Tim's current budget for Holywell, update with new plan and then get East Oxford and Team "
        "2020 to sign off on it")
    create_custom_card(
        board, 'Get list of Holywell colleges',
        datetime.date(year=2019, month=11, day=16),
        datetime.date(year=2019, month=10, day=28),
        "Either by looking at map of new boundaries, "
        "or asking David Newman, figure out exactly what "
        "colleges are in the new Holywell ward.")

    create_custom_card(
        board, 'Enter Trinity Term Campaign',
        datetime.date(year=2019, month=12, day=7),
        datetime.date(year=2019, month=11, day=20),
        "Agree with elections committee and East Oxford branch budget for the short campaign and "
        "update this board with the plan.\nEnsure the plan includes polling day"
    )
Exemplo n.º 30
0
    def prep_sprint(self):
        # incoming sprint: snapshot_phase=1 (start), from_roadmap=1
        print "Preparing Sprint %s" % self.cur_sprint_id

        self.ensure_not('prepared', self.cur_sprint_id)

        ## change title to todays date
        board = Board(self.client, board_id=self.SPRINT_BOARD_ID)
        # no method for setting name, use client directly
        board.client.fetch_json(
            '/boards/' + board.id + '/name',
            http_method='PUT',
            post_args={
                'value': 'Engineering: Current Sprint %s' % self.cur_sprint_id,
            },
        )

        ## right shift sprint roadmap, bring into current sprint
        rm_board = Board(self.client, board_id=self.SPRINT_RM_BOARD_ID)
        rm_lists = rm_board.open_lists()
        rm_list_map = {l.name: l.id for l in rm_lists}
        from_rm_cards = []
        for l in reversed(rm_lists):
            # leave any non S + N lists alone
            if not l.name.startswith('S +'):
                continue
            if l.name == 'S + 1':
                # capture this card list so we can mark from_roadmap correctly
                from_rm_cards = l.list_cards()
                # send to sprint
                board_id = self.SPRINT_BOARD_ID
                list_id = self.list_ids['New']
            else:
                # send to next col
                board_id = self.SPRINT_RM_BOARD_ID
                n_id = int(l.name[-1:])
                list_id = rm_list_map['S + %s' % str(n_id - 1)]
            l.client.fetch_json('/lists/' + l.id + '/moveAllCards',
                                post_args={
                                    'idBoard': board_id,
                                    'idList': list_id
                                },
                                http_method='POST')

        ## capture tickets coming in from roadmap (so we can figure out which were added ad hoc after sprint start)
        c = self._db.cursor()
        try:
            for card in from_rm_cards:
                card.fetch(True)
                # if we are doing default due dates, add now if it doesn't exist
                if card.due is None and DEFAULT_DUE_DATE:
                    card.set_due(self.cur_sprint_start + DEFAULT_DUE_DATE)
                self.write_card(card)
                # write them to state
                c.execute(
                    '''insert into sprint_state values (?, ?, ?, ?, ?)''',
                    (self.cur_sprint_id, card.list_id, card.id, 1, 1))
        except Exception as e:
            print "ROLLING BACK"
            self._db.rollback()
            raise e

        c.close()

        self.set_sprint_flag('prepared', self.cur_sprint_id)
        self._db.commit()
Exemplo n.º 31
0
def get_archived_cards(board_id):
    board = Board(TRELLO_CLIENT, board_id)
    cards = board.closed_cards()
    return cards
Exemplo n.º 32
0
def create_list_by_name(name):
    board = Board(TRELLO_CLIENT, BOARD_ID_LONG_OBSV)
    l = board.add_list(name)
    return l
Exemplo n.º 33
0
def get_cards(board_id):
    board = Board(TRELLO_CLIENT, board_id)
    cards = board.all_cards()
    return cards
Exemplo n.º 34
0
def get_list(name: str, board: trello.Board) -> Optional[trello.List]:
    """returns a trello list if it exists on the Trello board"""
    for t_list in board.list_lists():
        if t_list.name == name:
            return t_list
    return None
     return backup_list.id   
 
 def create_backup_board(self, client, member_data):
     create_backup_board = False
     if member_data.backup_board_id is None:
         create_backup_board = True
     else:
         try:
             backup_board = client.get_board(backup_board_id)
             if backup_board.closed:
                 create_backup_board = True
         except Exception, e:
             create_backup_board = True
     if create_backup_board:
         backup_board_json = client.fetch_json('/boards', http_method='POST', post_args={'name': 'Backup Board'})
         backup_board = Board.from_json(trello_client=client, json_obj=backup_board_json)
         member_data.backup_board_id = backup_board.id
         member_data.backup_board_name = backup_board.name
         member_data.save()
     return create_backup_board
 
 def get_member_data(self, member_id):
     member_data, _ = Process.objects.get_or_create(kind="trello_member_data", member_id=member_id)
     return member_data
 
 def get_trello_token(self):
     if self.trello_token is None:
         try:
             self.trello_token = Process.objects.get(kind="trello_oauth_token").token
         except:
             load_card('trello-token-save')