jcharles22

New User       | Play the game without signing in                                               | High
New User       | set number of players                                                          | High
New User       | give players nickname                                                          | High
New User       | register account                                                               | High
Returning User | Login                                                                          | High
Returning User | Add Cards to the Database                                                      | Medium
Returning User | Remove cards that only this user added                                         | Low
Returning User | toggle cards to be play with                                                   | Low
Returning User | Login/logout                                                                   | High
Returning User | Notification of all the new cards added to the database since last login       |

jcharles22

A drinking game where the user's asked how many player and names then gets a random card from the database with 
what the players have to do and just flip through the cards till a set of cards have been flipped through and 
ask if they want to play again.

a user can login to add cards to the database and see all cards that are in there
also they can pick and choose which cards they want to play with. 

jcharles22

Should the client or the server take more security precautions?
  Server
  
What's the difference between local storage and session storage?
  session storage gets cleared when the page session ends.

What problem does a JWT expiry time solve?
  that JWTs are valid forever
  
Is a refresh endpoint protected or public?

jcharles22

--asignment 1
select 
    e.emp_name, 
    d.dept_name 
from 
    employee e 
join 
    department d
on 
    e.department = d.id 

jcharles22

const ShoppingListService = {
    getAllItems(knex) {
      return knex
        .select('*')
        .from('shopping_list')
    },
    getById(knex, id) {
      return knex
       .from('shopping_list')
       .select('*')

jcharles22

require('dotenv').config();
const knex = require('knex');


const knexInstance = knex({
    client: 'pg',
    connection: process.env.DB_URL
})

function searchName(searchTerm) {

jcharles22

drop table if exists bookmarks;

CREATE table bookmarks (
  id primary key , 
  title text not null,
  rating INTEGER not null, 
  description text not null,
  url text not null,
  imgUrl text,

jcharles22

<meta prefix="og: http://ogp.me/ns#" property="og:title" content="{Your content}" />
<meta prefix="og: http://ogp.me/ns#" property="og:type" content="{Your content}" />
<meta prefix="og: http://ogp.me/ns#" property="og:description" content="{Your content}" />
<meta prefix="og: http://ogp.me/ns#" property="og:image" content="{Your content}" />
<meta prefix="og: http://ogp.me/ns#" property="og:url" content="{Your content}" />

jcharles22

const express = require('express');
const playstore = require('./playstore');
const app = express();

app.get('/apps', (req, res, next) => {
   
    let { sort, genres='' } = req.query 
    if(sort) {
        if(!['rating', 'app'].includes(sort.toLowerCase())) {
            res.status(400).send('Sort has to be rating or app.')

jcharles22

const express = require('express');
//data to import
const playstore = require('./playstore');
const app = express();

app.get('/apps', (req, res, next) => {
   
    let { sort, genres='' } = req.query 
    if(sort) {
        if(!['rating', 'app'].includes(sort.toLowerCase())) {