def get_boards(): """ Gather all boards :return: """ persistence.clear_cache() return persistence.get_all_boards()
def get_columns_by_id(board_id): persistence.clear_cache() all_columns = persistence.get_columns(force=True) matching_columns = [] for column in all_columns: if column['board_id'] == str(board_id): matching_columns.append(column) return matching_columns
def get_cards_for_board(board_id): persistence.clear_cache() all_cards = persistence.get_cards() matching_cards = [] for card in all_cards: if card['board_id'] == str(board_id): card['status_id'] = get_card_status(card['status_id']) # Set textual status for the card matching_cards.append(card) return matching_cards
def get_cards_for_board_and_status(board_id, status_id): persistence.clear_cache() all_cards = persistence.get_cards() matching_cards = [] for card in all_cards: if (card['board_id'] == str(board_id) and card['status_id'] == str(status_id) and card['archived'] == '0'): card['status_id'] = get_card_status(card['status_id']) matching_cards.append(card) return matching_cards
def save_dict_to_cards_csv(dictionary): if len(dictionary) > 0: persistence.clear_cache() keys = dictionary[0].keys() with open(persistence.CARDS_FILE, 'w', newline='') as output_file: dict_writer = csv.DictWriter(output_file, keys) dict_writer.writeheader() dict_writer.writerows(dictionary) else: f = open(persistence.CARDS_FILE, "w+") f.close()
def get_cards_for_board(board_id): persistence.clear_cache() all_cards = persistence.get_cards() matching_cards = [] for card in all_cards: if int(card['board_id']) == int(board_id): print(board_id) matching_cards.append(card) return matching_cards
def get_boards(name, password): """ Gather all boards :return: """ persistence.clear_cache() all_boards = persistence.get_boards() user = get_user(name, password) matching_boards = [] for board in all_boards: if user['user_id'] == all_boards['user_id']: matching_boards.append(board) return matching_boards
def get_cards_for_board(board_id): persistence.clear_cache() all_cards = persistence.get_cards() # to rewrite with SQL # matching_cards = [] # for card in all_cards: # if card['board_id'] == str(board_id): # card['status_id'] = get_card_status(card['status_id']) # Set textual status for the card # matching_cards.append(card) return matching_cards
def get_cards_for_board(board_id): persistence.clear_cache() all_cards = persistence.get_cards() matching_cards = [] for card in all_cards: if card['board_id'] == str(board_id): matching_cards.append(card) ordered_matching_cards = sorted( matching_cards, key=lambda card: (int(card['status_id']), int(card['order']))) for card in ordered_matching_cards: print(card) return ordered_matching_cards
def get_cards_for_board(board_id): persistence.clear_cache() all_cards = persistence.get_cards(board_id) return all_cards
def get_statuses(): persistence.clear_cache() return persistence.get_statuses()
def get_card_by_id(card_id): persistence.clear_cache() all_cards = persistence.get_cards(force=True) for card in all_cards: if card['id'] == str(card_id): return card
def get_cards(): persistence.clear_cache() return persistence.get_cards()
def get_user(name, password): persistence.clear_cache() all_users = persistence.get_users() for user in all_users: if user['name'] == str(name) and user['password'] == str(password): return user