To design, implement and test the Search and Book Page of the Harvard CS50 Project 1. - ndvssankar/Web-Programming GitHub Wiki

Welcome to the Web-Programming wiki!

Design:

The following are the UI fields with respect to search task:

  1. There will be an input box where the user can type his/her ISBN, title, author of the book.
  2. There will be a Search button and when clicked, the related books on the same page.

The following are the UI fields with respect to Book_page task: The details of the book will be displayed when the user selects the book from the search results. The details can be as follows

  1. Its title
  2. Author
  3. Publication year
  4. ISBN number
  5. Reviews that users have left for the book on your website.

Implementation:

The following are the things to be considered for implementation for search page: When the user enters the text and clicking on the button, it should redirect to /search app.route that routes to a search function.

  1. Get the data from the form
  2. Use SQLAlchemy to get the book results based on the search query (There will be a Book entity).
  3. Display the results in a tabular format with each book having the hyperlink as its ISBN number. /book_page?isbn_number=isbn_number can be used as a URL.
  4. The above URL can be used to redirect to Book_page that displays the book details.

The following are the things to be considered for implementation for Book_page. When the user clicks on the link that has displayed on the search results page, will redirects to /book_page app.route that routes to a book_page python function.

  1. Get the ISBN number from the URL.
  2. Issue the query to the database in order to get the book details.
  3. Render the HTML page (book_page.html) with the book details.

Testing:

Check for the following test cases on the search function.

  1. One test case with existing ISBN number
  2. One test case with book name
  3. One test case with author name
  4. One test case with invalid ISBN number
  5. One test case with invalid book name
  6. One test case with invalid author name
  7. One test case with valid publishing year
  8. One test case with invalid publishing year
  9. One test case with valid wild card characters and that has partial book / author name / ISBN number.
  10. One test case with no text in the text box and hit the search button. Then the user will asked to enter the valid text in the search text box.

The following is with Book_page test case that works on book_page function. 11. Check whether the URL has an ISBN Number.

Prepared by Siva and Manasa