SSKM

What are you looking at?

A centralized place where you can add and review different types of technology / software mentioned on the course.

User journies:

• User can see a flexbox grid of everything added to db
• User can add entry to db
• When you click on a technology you'll redirect to /technology/:nameOfTech to view that specific technology post.

How to view on Heroku

https://sskm-tech.herokuapp.com/

How to install locally (so you can run db_tests):

1. Clone the project and run npm install

2. Create a config.env file in the root of the directory

3. Set up a local database on your machine and add the DB_URL to the config.env file in the format:

DB_URL = postgres://username:password@localhost:5432/techdatabase

4. Alter the database to make your user role the owner

5. Be sure to grant all permissions on the database/tables to the user role you are using

6. Run this code from the command line to build the database:

node db/db_build.js

7. Run your server:

npm run dev

8. In your browser, navigate to

http://localhost:8001

Database includes:

A technologies table called: tech

• id
• name
• description
• language (can remain empty)
• rating: boolean/ blank: happy face, sad face, neutral
• author

Stretch goals:

• Sorting alphabetically
• Filtering recommendations
• Search bar
• Login page
• Fonts according to user rating
• Add multiple posts per tech

To dos:

• Build express server
• Build handlebar hbs pages:
  • home (ul of all techs)
  • add-tech (form)
  • tech-info (info about specific tech)
• Build partials:
  • [x]header
  • [ ]footer
• Build controllers
  • get all data
  • get tech data
  • post tech data
• Build helpers: ?
• Test helpers: ?
• Build a form for add-tech
• Build a local db
• Set up Heroku db + app
• Testing
  • [x]on local db
  • [partial] routes
• [partial] Set up Travis
• Set up CodeCov
• Keep README updated
• Add README badges:
  • Travis
  • CodeCov
• [partial] Add styling for pages (grid, choosing fonts...)

Getting TRAVIS to work with database testing (****WE NEED HELP)

Paste into YML file

services:
  - postgresql
  
env:
  - DB=postgres
  - DB_URL=postgres://admin:password@localhost:5432/superbase
  - TEST_DB_URL=postgres://admin:password@localhost:5432/superbaseTest

language: node_js
node_js :
 - "node"
after_success: npm run coverage

before_script:
  - psql -c "CREATE DATABASE superbase;" -U postgres
  - psql -c "CREATE DATABASE superbaseTest;" -U postgres
  - psql -c "CREATE USER admin WITH PASSWORD 'password';" -U postgres
  - psql -c "ALTER DATABASE superbase OWNER TO admin;" -U postgres
  - psql -c "ALTER DATABASE superbaseTest OWNER to admin;" -U postgres

Design Inspiration

Color palette: #F0F0F0 (background) #E7D8D4 (light pink) #EEA095 (medium pink) #455AFB (blue)

Potential color palettes

Fonts

<link href="https://fonts.googleapis.com/css?family=Lato:400,400i,700,700i|PT+Sans:400,400i,700,700i" rel="stylesheet">
	.	font-family: 'PT Sans', sans-serif;
	.	font-family: 'Lato', sans-serif;

Database cheatsheet: https://hackmd.io/yTktI4TtQ825ZKj0x-m4qw?view

SCHOOLS OUT!