This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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? |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--asignment 1 | |
select | |
e.emp_name, | |
d.dept_name | |
from | |
employee e | |
join | |
department d | |
on | |
e.department = d.id |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const ShoppingListService = { | |
getAllItems(knex) { | |
return knex | |
.select('*') | |
.from('shopping_list') | |
}, | |
getById(knex, id) { | |
return knex | |
.from('shopping_list') | |
.select('*') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
require('dotenv').config(); | |
const knex = require('knex'); | |
const knexInstance = knex({ | |
client: 'pg', | |
connection: process.env.DB_URL | |
}) | |
function searchName(searchTerm) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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}" /> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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.') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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())) { |