psychicbologna

Using the same projects database from above write queries to answer the following questions:

How many people work in the Sales department?

SELECT
  count(e.emp_name) as emp_count,
  d.dept_name
FROM
  employee e
  JOIN department d ON e.department = d.id

psychicbologna

https://github.com/thinkful-ei-gecko/alex-capstone/settings - WIREFRAME

https://github.com/thinkful-ei-gecko/alex-capstone/blob/master/screen-inventory.md - SCREEN INVENTORY (.md)

psychicbologna

A deliciously simple recipe storage system, with built-in measurement conversions and scaling. Save, edit and delete multiple recipes for easy access.

psychicbologna

ROLE	TASK	IMPORTANCE
As a new user,	I want to sign up for an account	High
	I want to edit these recipes if I make a mistake inputting them.	High
	I want to delete these recipes if I change my mind about adding them.	High
	I want to upload recipes in my preferred format (metric vs US cooking)	Medium
	I want to optionally convert these recipes between measurement formats.	Medium
	I want to scale these recipes up or down.	Low
As a returning user,	I want to sign back into my account.	High
	I want to rate recipes I have tried.	Medium
	I want to organize and list my recipes by category as I accumulate them.	Medium

psychicbologna

drop table if exists bookmarks;

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

SELECT uuid_generate_v4();

create table bookmarks (
    id uuid DEFAULT uuid_generate_v4(),
    title text NOT NULL,
    link text NOT NULL,

psychicbologna

1. Choose Your Own Adventure
  Description: A simple visual novel/comic where the page layouts and story outcomes are affected by the choices the user makes. Inspired by text-based adventure games, browser games like the original Kingdom of Loathing and the expansive game genre of visual novels.
  
  Desired Functionalities:
  
  STARTING:
   - A starting screen with an introduction to the app and a 'start' button.
   - When 'start' is clicked, a menu prompt appears with a form input for the user to enter the character's name.
   - The form also allows the character to choose a 'class' from up to three options
   - 'Class' superficially changes how the character does certain things (eg. Wizard uses staff in combat, wherareas fighter uses sword; I am leaving out more complex combat stats and systems for simplicity's sake and may choose to implement them later).

psychicbologna

-What situations would be good to use context?

Data that would be considered 'global' in a React component tree, such as user information, preferred language, theme or permissions.

-If you need to pass a prop down 1 or 2 levels, is context necessary?

Context is only necessary when multiple components at different levels of the tree require access to it. Compponent composition may be a more elegant solution.

-Can you pass a component instance as a prop to avoid the need for context?

psychicbologna

https://courses.thinkful.com/ei-react-v1/checkpoint/10#technical-details

Components created as classes have more features, such as life-cycle methods.

Each component class has several “lifecycle methods” that you can override on the class. These methods allow us to add behavior when a component is created, mounted, updated or removed.

The only required method is render. The other methods are optional.

This is an incomplete list of the methods:

psychicbologna

Thanks for your time.

psychicbologna

Alexander Fukui is a web designer and developer.

I am a Minneapolis freelancer who spent hours and hours attempting to make Wordpress work. I enjoy working extensively with Sass to solve design problems and experimenting with new methods of displaying quality content. My favorite parts of this work include perfecting scripts, perusing well-written documentation and discussing persistent problems loudly with my cat. I have built apps using javascript with ES6, HTML5, CSS3 and Sass, jQuery, node and Webpack. My philosophy is that good design, solid content and organized structure are all critical parts of a good app.

Projects:
	name: Morbid History Quiz App
	description: A thrilling adventure through some dark parts of history, which rates your morbidity at the end. WARNING: may be educational.
	uses: HTML5, CSS, javascript, jQuery.
  link to app: https://thinkful-ei-gecko.github.io/Alexander-Preet-QuizApp/
  link to repo: https://github.com/thinkful-ei-gecko/Alexander-Preet-QuizApp