roshanjamkatel / gamevendor

An application where users can access game content online and learn more about a game before purchasing. This is a one-stop web application for a minimalistic and easy process.

GameVendor

Application where users can access game content online

This application is a mock style of a shopping store that is focused on knowing about the game rather than just buying the game. It utilizes PostgresSQL, MongoDB NoSQL, SpringBoot, Java, Thymeleaf, and Tailwindcss.

How to run

• cd database/docker
• docker-compose up -d
• if first time, docker exec -it data-postgres psql -Upostgres
• create DATABASE gamevendor;
• Go to GamevendorApplication and run
• visit http://localhost:8080/
• To see data you can use a tool like https://tableplus.com/

#Tables

• games (Sql) -> any game across any os/console
• users (Sql) -> authenticated user
• library (sql) -> users library of owned games
• wishlist (sql) -> users wishlist of games
• friends (sql) -> one to one relationship of users
• reviews (Sql) -> review of a game made by a user
• points (Sql) -> Points for a certain user
• stats (Sql) -> how many current players are online playing certain games
• genres (NoSql) -> types of games
• forum_topics (Nosql) -> forum topics (i.e. "Help")
• forum_posts (Nosql) -> forum posts made by users
• blog_posts (NoSql) -> updates for the community made by the GameVendor team
• shopping cart (Sql) -> Users can add/edit/remove games on the cart

gamevendor's Issues

Follow java code standards

As mentioned during first class, follow javacode standards such as https://google.github.io/styleguide/javaguide.html

eg package name should be lower case and the class name should start with upper case

Remove table names in code and table names defined in CreateTable does not match

For example, shopping cart and wish list. Be sure not to use @table if the table name and class name are the same.

Display Detailed Page

The detailed page does not pull in the information for the given game.

Images do not pull on detailed page

The images do not pull on the detailed page.