gistfile1.txt

# -----------This works!-------------------------------

book_search_variable= searchString
y=mydb['bookDataset'].find({"Book-Title":{"$regex":book_search_variable}}).limit(5)
bookSearched=list(y)
print(bookSearched)

#----------------trying to change Book-Author to bookAuthor-----------------------------
#----------------didn't work---------------------------
#-----------book_search_data = [] always------------------------

book_search_variable= searchString
y=mydb['bookDataset'].find({"Book-Title":{"$regex":book_search_variable}}).limit(5)
bookSearched=list(y)
w=mycol.aggregate([{"$match":{"Book-Title":{"$in":bookSearched}}},
            {"$project":{'_id':0,'ISBN':'$ISBN', 'bookTitle':'$Book-Title','bookAuthor':'$Book-Author','genres':'$genres','imageURL':'$Image-URL','averageRating':'$average_rating','publicationYear':'$publication_year','description':'$description'} }])
book_search_data = list(w)