trendgame / uforu

Browse and filter university listings

TrendGame

Only the trendiest. Search Google Trends for any topic of interest and see news articles corresponding to spikes in interest.

Team

• Alex
• Eric
• Fu Fei
• Prateek

Usage

Go to URL: https://trend-game.herokuapp.com/

Requirements

• Node
• NPM
• API key for Aylien News API
• Postgres

Development

Installing dependencies

From the root directory:

npm install

Initializing the database

Deployed Heroku Postgres DB:

1. Provision your app with a Heroku Postgres db.
2. Find the db's url in the config vars for your app and copy it.
3. Paste it in setupDatabse.js as per the instructions in that file.
4. Use node to run setupDatabase.js. If you get 3 console log statements confirming table creation, you're good to go!

Local DB:

1. Install a local version of PostgreSQL. Recommend using brew to manage installation.
2. Create a db in your local PostgreSQL server cluster.
3. Follow the instructions in dbLocalConnection.DUMMY.js and populate it with the information for the db/user.
4. Edit setupDatabase.js to point at your local DB. NOTE: The instructions and structure in this file are intended for populating deployed Heroku Postgres dbs with the schema. For a local DB, just point the connection at your local db by setting the connection in require('knex') to your local db's information. You can find this information in dbLocalConnection.js (assuming you've made it as per step 3).
5. Use node to run setupDatabase.js. If you get 3 console log statements confirming table creation, you're good to go!

Running locally

From the root directory:

1. In one terminal window, run > npm run dev
2. In another terminal window, run > npm run start:watch
3. go to http://127.0.0.1:8080
4. Don't forget you'll need an Aylien News API key

Roadmap

View project roadmap

View app plan (includes schemas and architecture diagrams, etc)

Contributing

See CONTRIBUTING.md for contribution guidelines.

uforu's Issues

URLs that reflect current search params

Re-architect app for react router

Refactor banner and author pictures/descriptions to be responsive.

Make chat component

Add chat table to db

Remove hover img expansion

Redesign bottom navbar to be collapsible and responsive.

Implement WebSockets for comments

Tasks

• Render comments list on college page on load from the DB
• Capture user input to component state
• Submit handler to emit socket event and send data to server
• Server socket listener for new message to write message to DB
• On DB write complete, socket broadcast to all clients with comments table

Favorites (in session)

Refactor Major selection to look cleaner/ have better responsiveness to minimization.

Refactor layout to be responsive

Add Comments table to prod DB

done on prod via Sequel Pro connection. seeded comments to university with id 1

Deploy setup env

Implement cookies session

Comments per college (somehow)

Bug: Selecting only a major returns nothing

Repro

1. Go to home page
2. Select 1 major
3. Click submit
4. Check console

It's related to the queryHelper

Add react router routes for uni chat

To Dos

• Make a new <Route> for /college/:id in index.jsx
• Make sure ResultListEntry has access to university_id so it can render the right university banner and GET and POST comments for the correct university
• Make a new <Link> in ResultListEntry`

Add server routes for uni chat