laughingclouds / quizgame Goto Github PK

View Code? Open in Web Editor NEW

2.0 2.0 2.0 1.67 MB

A web based quiz game

License: MIT License

Go 26.51% Shell 0.89% JavaScript 69.85% HTML 1.23% CSS 1.52%

game gin golang postgres reactjs reactrouter6

quizgame's Introduction

quizgame

A Quiz Game written in golang.

Mini-Project made for the Summer Training program of my Uni

History

Working example using ncurses library and C++
Complete project using drogon framework
Now. Rewrite in golang

Acknowledgement

As a novice in Go programming and Gin framework (and web development in general) I frequently referred to the go-banking-api project by Devansh. Thanks for being awesome!

Database

We're going to need a postgres database to start. I've already included an SQL script to create the tables and add sample data into them.

cd into project directory
run the below script for user postgres who owns a database quizgame

Feel free to change these values to your liking

psql -U postgres -d quizgame -a -f backend/scripts/database.sql

Quiz game uses the following environment variables to connect to a database.

Environment Variables
QZ_HOSTNAME
QZ_USERNAME
QZ_PASSWORD
QZ_DBNAME

export QZ_HOSTNAME="localhost"
export QZ_USERNAME="postgres"
export QZ_PASSWORD="PASSWORD"
export QZ_DBNAME="quizgame"

Build

Run the build script after installing the dependencies (below)

sh build.sh

Install Dependencies

Frontend

cd into frontend
install dependencies

yarn install

npm install

Backend

cd into backend
download dependencies

go get

Alternative

You can also simply invoke individual build systems for both react and go.

quizgame's People

Contributors

Stargazers

Watchers

Forkers

vivelacode shreyanshi123

quizgame's Issues

Put user score besides user name in InformationList

Create Documentation for Team Members

Something new to learn

I knew it was possible but kudos to github for showing me how lacking in skills I am T_T

COMPLETE THE CSS AND THE QUIZ QUESTIONS

THE CSS OF LEFT OVER HTML PAGES IS LEFT SO PLEASE COMPLETE IT AND THE QUIZ QUESTIONS ARE ALSO LEFT
@JaGPR @laughingclouds @PrateekSarna-24 @Shreya220 @MadhaviGupta18

App saves duplicate values in the database

This is the data in the table "Solved"

At row 4 and 8, values of question_id and user_id is the same.
If I recall correctly, the code simply adds items to the database without checking whether an entry with the same values exist or not.
At the same time, it is not possible to change the database as both question_id and user_id cannot be unique (due to the nature of use-case for this table).

Hence this should be cross checked by the code, before new values are inserted.

Query the users that have the top 5 scores
Display the results on a view

This will require both back-end and front-end teams.

Back-team will query the results and insert the data into a view.
Front-end team will work on the view.

Potential for confusion with what handles what

People who didn't work on the controllers may not know what URL requests are handled by what controllers.

I suggest documenting this information somewhere.
It could also be put in the final project report.

We could even list the views associated with the various controllers.