Ejemplo n.º 1
0
    def create_and_store_purchase_option(self, temp_book, isbn, price):
        errors = []
        # Check if book has correct ISBN
        # Check DB for duplicate isbn entry.
        # If so just make purchase option

        book = Book.get(isbn=isbn)
        if not book:
            book = Book()
            book.author = temp_book.author
            if temp_book.subtitle is None:
                book.title = temp_book.title
            else:
                book.title = temp_book.title+': ' + temp_book.subtitle
            book.isbn = isbn
            book.save()

        # add purchaseChoice to DB
        p = PurchaseChoice()
        p.book_id = book.id
        p.price = price
        p.type = 'Hardcover'
        p.isRental = False
        p.link = ''  # TODO change to valid link
        p.local_seller_id = current_user.id
        p.isLocalSeller = True
        p.save()
        return errors
Ejemplo n.º 2
0
    def fill_list_by_bookid(self, option_list, book_id):
        def add_to_list(old_list, option):
            if not option:
                return old_list
            elif not option.price:
                return old_list
            option.price = "{:.2f}".format(float(option.price))
            if option.isLocalSeller:
                local_seller = User.get(id=option.local_seller_id)
                old_list.append({
                    'seller': local_seller.username,
                    'price': option.price,
                    'rental': option.isRental,
                    'book_type': option.type,
                    'link': option.link,
                    'purchaseID': option.id
                })
            else:
                old_list.append({
                    'seller': option.remoteSellerName,
                    'price': option.price,
                    'rental': option.isRental,
                    'book_type': option.type,
                    'link': option.link,
                    'purchaseID': option.id
                })
            return old_list

        query_return = PurchaseChoice.get(book_id=book_id)
        if isinstance(query_return, list):
            for option in query_return:
                option_list = add_to_list(option_list, option)
        else:
            option_list = add_to_list(option_list, query_return)
        return option_list
Ejemplo n.º 3
0
def store_book_info_for_user_and_isbn(user_id, isbn, isbns_to_retry):
    # add book object
    b = Book()  # create temp book object
    query_book = Book.get(
        isbn=isbn
    )  # check if Book object is already in DB
    if not query_book:
        temp_arr = get_books_for_book_title_using_google_books(
            'isbn:' + isbn
        )
        if len(temp_arr) == 0:
            AZ = AmazonScraper()
            amazon_dict = AZ.get_amazon_purchase_choices_for_keyword(isbn)
            if len(amazon_dict) == 0:
                isbn_info = {}
                isbn_info['isbn'] = isbn
                isbn_info['user_id'] = user_id
                isbn_info['retries'] = 0
                isbns_to_retry.append(isbn_info)
                return False
            temp_book = Book()
            temp_book.isbn = amazon_dict[0].get('isbn')
            temp_book.title = amazon_dict[0].get('title')
            temp_book.author = amazon_dict[0].get('author')
            temp_book.thumbnail_link = amazon_dict[0].get('thumbnail_link')
            temp_book.subtitle = ''
            temp_arr.append(temp_book)

        temp_var = temp_arr[0]
        b.isbn = temp_var.isbn
        b.author = temp_var.author
        if(temp_var.subtitle is None):
            b.title = temp_var.title  # check if subtitle is null
        else:
            b.title = (
                temp_var.title +
                ': ' + temp_var.subtitle  # check if subtitle is null
            )
        b.thumbnail_link = temp_var.thumbnail_link

        # Sometimes, the isbn found by the scraper differs from the one
        # in the file
        # In this case, a duplicate book would be created (same isbn)
        # Check for found isbn first before saving book
        possible_duplicate_book = Book.get(isbn=b.isbn)
        if possible_duplicate_book:
            b = possible_duplicate_book
        else:
            b.save()  # save book

    else:  # if book in DB, set b.id to id of DB book
        b.id = query_book.id

    # Make purchase choice
    p = PurchaseChoice()
    p.id = b.id
    p.price = randint(55, 250)  # default to 10
    p.type = 'Hardcover'
    p.isRental = False
    p.link = ''  # change to valid link
    p.local_seller_id = user_id  # change to user once login is created
    p.isLocalSeller = True
    p.save()

    booksV = BooksViewed()
    booksV.user_id = user_id
    booksV.book_id = b.id
    booksV.save()
    return True