This repository hosts the Database implementation for our SER322
Game Wiki Database.
To use our program, you will need:
Java 8 SDK
Postgres SQL Server with postgres user on default port 5432
Gradle installed
run from the command line using:
gradle rungui -Ppassword="['SQL_PASSWORD_HERE']"
This command will automatically start up a connection to postgress on the default
port using the entered password. It will search for an existing ser322 database with a
schema called gameschema and with all present tables and if not found will create them.
From there, the gui should start. Log in as a player. I suggest:
tcuprak
timCuprak
since he does not have alec as a friend (testing add friend).
From there view any panel. Including:
"My Profile"
Basic account info
"My Characters"
A breakdown of your characters
"Community"
Look for new friends and query info about your current ones
"Game Wiki"
Look up things about the game
Resource Documents:
These scripts are the sql versions of what the java generates. They are available inside the
resource page
There are 4 scripts that have to do with initializing/maintaining the db.
These are:
CreateDB.sql
This script creates the database. It should be run from postgres user
DropDB.sql
This script drops the database. It should be run after DropTableAndSchema.sql from
the postgres user.
DropTableAndSchema.sql
This script drops the table and the schema. It should be run from the postgres
user with a connection to the SER322_DB database (created by CreateDB.sql)
LoadDB.sql
This script loads the database which includes creating the tables and
providing example inserts to run queries against. It should be run as the
postgres user with a connection to the SER322_DB.
There are a number of SQL queries under Queries which can be run as examples.