BookHunter

Transcript

1. Alyssa Rodriguez, Yizhou Li, Kenneth Knox, Aditya Kuppa, Aman Kumar, Revanth Muppana Summer 2022 CS 373: Bookhunters Find any book you want.
2. “There is no friend as loyal as a book.” ― Ernest Hemingway Key to Human Development Provide an impeccable collection of books, authors, genres Dive deep into the world of books
3. Group Members
4. Mission and Vision Mission: Provide a great experience to the users -> Everything from front end, layouts, database designs, apis. Create awareness of new genres, authors, and books Vision: Become a key resource for book enthusiasts and those that want to try new things. Provide an experience in finding new books that is both user friendly, intuitive and simple.
5. Books Authors Genres 03 02 01
6. A View Into Our Frontend
7. Frontend Issues: NPM/Pipeline implementation, Connecting to backend, Sorting, and Searching, small amount of trouble with styling the website, YouTube videos not displaying properly (backend), linking categories Features We Want For the Future: Global search (not category specific), Better Aesthetics, Categories properly linked What We Learned: Knowledge of JS and CSS, Connecting frontend and backend code, More to do than expected Things We Would Do Differently: Communicate Better with the group, Assign tasks earlier, Make sure correct packages are installed
8. Let’s dive deep into the Backend
9. Backend Overview Genres Phase 1 • Hard coding data into our website • Setting up Postman • Set up general structure Phase 2 • Utilization of APIs to get info • Start working with Database • Further work on Postman Phase 3 • Proper use of SQL Alchemy and Database connectivity • Filtration, Search, Pagination, Sort functionality • Additional API work and Models/Visualization Authors Books
10. Backend Demo A closer look at our work…
11. Data Scraping - general logic Step 1: Mapping (genre -> authors -> books)
12. Step 2: Input: wiki link; Output: the author list
13. Step 3: • Input: - the author list • Logic: - each_author -> each_page -> each_book in each_page
14. Output: authors and their top 2 genres What we need next? The books (ids) written by these authors that fit these genres
15. Step 4: (1) • Input: - author and top 2 genres • Logic: - each_author -> each_page -> each_book
16. Step 4: (2) if book satisfies condition, add into dic
17. Step 4: (3) Output: - dictionary of book id and its genre
18. Summary: we get 2 things: - authors and their top 2 genres - Book ids in each author and its genre mapping
19. Data Scraping - Book
20. input: book_id genre mapping
21. sample output
22. Data Scraping for Authors Display Attributes • Name of Author • Display Photo • Sample Books • Known for Genres • Nationality • Education • General Description
24. Data Scraping for Authors
25. Genres
26. Models, UML
27. DB data loading (create_db) Sequence
30. Genre_author association table
32. Book table result
34. find books and genres to show up for each author by using the genres_showup and books_showup fields in the author’s object
36. Backend - general
37. Searching
38. Filtering
39. Sorting, Pagination
40. Hosting • Namecheap • Google Cloud Platform ◦ App Engine
41. Issue Tracker Stats Yizhou: 49 (responsible for issues) Revanth: 8 Kenneth: 6 Alyssa: 1 Aditya: 1 Aman: 1 Total Issues: 66 Resolved: 60 Unresolved: 6
42. Run Unit Tests Coverage Not Working Properly
43. Run Postman Tests
44. Our Group: IDB4 | Critiquing Well Done • Utility based selection of Models and their connectivity (Books, Authors, Genres) • About page; Drop down usage and tests display Learnings • Gained knowledge about SQL, Database access/population • Frontend-Backend interactions and relations; being on the same page (metaphorically and physically) Suggestions / Future additions • Further work on the Models/visualizations pages • Intuitive display of model data (space out each of the listings) • Work/Time management improvements; more frequent meetings Puzzling Question: Why npm start keeps failing and why is GCP so volatile?
45. Group 1 : IDB1 | Critiquing Well Done • Aesthetic Design; Intuitive UI for a music application • Creative Visualizations; Top Artists per Genre Pie chart • Great Color Scheme (black & white + ombre violet) Learnings • Fonts and Color Scheme Consistency • Effect of Rounded edges on buttons (Apple’s stylistic features) Suggestions / Future additions • More clickability options (like for each Artist’s genres) • Having a “Sort by” visible button option • Embedded media (linking the spotify/apple music link to each song, artist, album) Puzzling Question: Why did you guys choose a music based website? Apple music or Spotify, which is better?
46. Thank You For you Time!