Skip to content

Latest commit

 

History

History
95 lines (48 loc) · 2.56 KB

README.md

File metadata and controls

95 lines (48 loc) · 2.56 KB

Content Sharing Platform

This is a place for Just Another Sand Game players to share maps, mods, and more!

image image

Documentation

https://kingtut10101.github.io/ContentSharingPlatform/

Setup Databases and Upload Mock Data

Make sure you have pgSQL and MongoDBCompass installed

SQL

Connect to the SQL Shell (psql)

Run "CREATE DATABASE ;", replacing with whatever you want to name your Database

Run "\c "

Run "\i <path/to/PostgreSQL_Project.sql>"

Run "\copy useraccount FROM '<path/to/ContentSharingPlatform/database/mockData/UserAcct.csv>' WITH DELIMITER ',' CSV HEADER;"

Run "\copy comment(UserEmail,CommentText,CreationDate,ContentId) FROM '<path/to/Comment.csv>' WITH DELIMITER ',' CSV HEADER;"

Run "\copy rating FROM '<path/to/Ranking.csv>' WITH DELIMITER ',' CSV HEADER;"

Navigate to ContentSharingPlatform/server/db/sqlConn.js

Change user, host, database, password, and port to your chosen SQL database settings

MongoDB

Connect to MongoDBCompass

Create Database and Collection titled "Content"

Click ADD DATA > Import JSON or CSV file

Navigate to ContentSharingPlatform/database/mockData/Content.json

Click Import

Navigate to ContentSharingPlatform/server/db/mongoConn.js

Change "connectionString" to your chosen MongoDB connection string if needed

Change "let db = conn.db("")" to your database name

Installation

Make sure NPM is installed

Run “git clone https://github.com/KINGTUT10101/ContentSharingPlatform.git”

Run “cd ContentSharingPlatform”

Run “npm install”

Run “cd client”

Run "npm install" again

Run "cd ../server"

Run "npm install" one last time

Running the project

Run “npm run dev” in the project's root directory

Connect to localhost:3000 in your browser

Running the frontend

Run “npm run client” in the project's root directory

Connect to localhost:3000 in your browser

Building the frontend

(It's recommended that you do this before running the backend. This will update the static frontend files that the backend will return to you)

Run "npm run build" in the project's root directory

Running the backend

Run “npm run server” in the project's root directory

Connect to localhost:5000 in your browser