Code Monkey home page Code Monkey logo

akatheduelist / dsdb Goto Github PK

View Code? Open in Web Editor NEW
0.0 1.0 0.0 19.96 MB

The Doug Score Database uses the famous automotive journalist Doug DeMuro's iconic spreadsheet of 600+ vehicle reviews and turns it into a web app that can be used by automotive enthusiasts to search and sort vehicles by scores and other metrics, as well as adding their own information and scoring..

Home Page: https://dsdb.onrender.com

Python 43.67% Mako 0.30% HTML 0.49% CSS 6.26% Shell 0.02% JavaScript 49.26%

dsdb's Introduction

Welcome to DSDb - Automotive Ratings, Reviews, and The Place to Find the Best Quirks & Features

The Doug Score Database uses the famous automotive journalist Doug DeMuro's iconic spreadsheet of 600+ vehicle reviews and turns it into an IMDb style web app that can be used by automotive enthusiasts to search and sort vehicles by scores and other metrics. Users of DSDb can also add their own information and scoring to each vehicle to create their own community score..

FROM THIS

image

TO THIS

image

This project is a web app created to simulate the functionality of an IMDb style app. All data is parsed from the public DougScore spreadsheet of automotive reviews, it uses YouTube to produce thumbnail images for each review and the UnSplash API to generate a movie poster style image based on the make and model name of the vehicle.

add and remove tags for a specific vehicle, update the description

DSDb is built using

Give DSDb a try yourself.

...or check out a list of features listed below.

Features

Users or DSDb can search for any vehicle in the database using the provided search bar.

image

Update the tags or description of a specific vehicle in the database.

image

Add your own review to one of the cars

image

Note down one of the Quirks or Features of the car

image

Browse curated reviews

image

dsdb's People

Contributors

akatheduelist avatar

Watchers

 avatar

dsdb's Issues

Landing Page

  • Favicon & Logo
  • All Vehicles in state
  • Reviews for Vehicles in state
  • Title

Style Landing Page

  • Basic styling to landing page to match target site
  • Header with random review information and scrolling list
  • Various lists arranged like IMDb posters

Feature - Search

  • Create api route for search queries and test
  • Search component creates page for search results
  • Test and verify search results are working properly
  • Search results paginated
  • Search results styled

Feature 2 - Sign Up

  • Customize signup feature to database
  • Error handling frontend
  • Error handling backend

Feature 1 - Sign In

  • Customize sign in to users database model
  • Create demo user login button
  • Error handling frontend
  • Error handling backend

BUG - Cosmetic

  • Cosmetic Note: Would recommend removing the 'bullet' that is to the side of the User Dropdown.

BUG - Quirks

  • Quirks/Features: Noticing that if I submit a really long string, that I get a 500 error in the console and the form submits without any validation message. As above, would hammer down on the form validations.

Parse spreadsheet data

  • Find best way to parse data from Google sheet currently online
  • Export to CSV and use python to parse csv data into rows
  • Testing and verified working
  • Create seed data with parsed information

Enhancements

  • Review modal submit button push to bottom of page
  • Signup / Login page no nav white bg
  • 0 showing up on the left of login / signup validation
  • Check over routes and formatting of routes
  • YT title for videos in landing page carousels

Review Error Handling

  • Cannot post a review if not logged in
  • Review has minimum and maximum characters
  • Review is textarea
  • Review is related to specific vehicle

BUG - Reviews

  • Reviews: Noticing that when I enter a really long string for a review, it overflows the div and runs off of the page. Would make sure to add some MIN and MAX length requirements on the Reviews and I would not submit the form if the validations fail. Just render the appropriate error response.

BUG - Section Sorting

  • Section Zoom Zoom on home page is listing the wrong vehicles, it is showing bottom of the list instead of top
  • Section Ice Cold on home page is listing the wrong vehicles, it is showing bottom of the list instead of top

BUG - Sign Up

  • "SIgn Up: I was able to sign up as a new user using only a single character in each input. Would definitely set a minimum length of 8 for the password for basic security.
    Additionally, a general rule for form validations would be to ensure that ALL form input fields have both a MINIMUM and MAXIMUM value that is being tested for and that you should render the appropriate error messages when the user enters invalid data so that it is clear what they need to do to proceed! Ideally, each message would render above or below the input that it specifically refers to and should convey the bounds of that input."

BUG - Search Bar

  • Search bar is non-functional. You can use 'Feature Coming' or some such placeholder text to convey that it is not funcitoning to the user.

Style Vehicle Details Page

  • Style vehicle details page to match basic styling of IMDb movie page
  • Photos can be viewed
  • Reviews can be viewed & added
  • Quirks and Features can be viewed & added
  • Review information listed
  • Vehicle tags information

Vehicle Page

  • Create vehicle page that gets params by id
  • Vehicle page has details for vehicle id
  • Page loads reviews for vehicle
  • Page loads quirks for vehicle
  • Page loads images for vehicle

Footer Component

  • Footer component with links and icons to match target page
  • Style footer component

Delete Item Modal

  • Create delete item modal
  • Modal has confirm button to delete items
  • If review is being deleted delete review
  • If quirk or feature is being deleted delete QAF

Database routes

Reviews

  • Create Review
  • Read Reviews
  • Update Review
  • Delete Review

Quirks

  • Create Quirk
  • Read Quirks
  • Update Quirks
  • Delete Quirks

Tags

  • Add Tag to Vehicle
  • Update Tag
  • Delete Tag
  • Read Tags

Descriptions

  • Create vehicle description
  • Read vehicle description
  • Update vehicle description
  • Delete vehicle description

Navigation

  • Navigation features match target site
  • Search bar
  • Logo
  • Menu

Style Delete Modal

  • Style delete items modal to match basic styling
  • Delete items modal verified working

Create Seed Data

  • Users seed data
  • Vehicles seed data
  • Dougscores seed data
  • Reviews seed data
  • Vehicle image seed data
  • QAF seed data
  • Filming Locations seed data

Add profile page

  • Create profile page component
  • Link to profile page if logged in at menu bar
  • Image, Bio, Birthdate and other information visible on page
  • Profile information can be edited in page

Stretch

  • AWS image upload integration for profile images
  • List of contributions to the database with timeline

Review Modal

  • Create review modal for vehicle reviews
  • Review modal gets vehicle ID from prop
  • Review modal can determine if it is in update mode or new review mode
  • Review modal closes and page updates with new info

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.