psenger

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

• Mac /usr/local/mysql/bin
• Windows /Program Files/MySQL/MySQL version/bin
• Xampp /xampp/mysql/bin

Add mysql to your PATH

psenger

// not sure I understand this
let a=1, b=2;
a = a+b;
b = a-b;
a = a-b;

psenger

const curry = function curry(func) {
    return function curried(...args) {
        if (args.length >= func.length) {
            return func.apply(this, args);
        } else {
            return function(...args2) {
                return curried.apply(this, args.concat(args2));
            }
        }
    };

psenger

const target = {};
const handler = {
    get: (tar, prop) => {
        console.log('get',tar, prop)
        return tar[prop];
    },
    set: (tar, prop, val) => {
        console.log('set', tar, prop, val);
        tar[prop] = val;
    },

psenger

/**
 * Use a useEffect for a single purpose 
 **/

function App() {
  const [varA, setVarA] = useVarA();
  const [varB, setVarB] = useVarB();

  return (
    <span>

psenger

Specificity Hierarchy

There are four categories defining the level of specificity.

1. Inline styles - An inline style is attached directly to the element. EG. <h1 style="color: #ffffff;">.
2. IDs - An element ID is a unique identifier for an element in a DOM. EG. #navbar.
3. Classes, attributes and pseudo-classes - This category includes .classes, [attributes] and pseudo-classes like :hover, :focus etc.
4. Elements and pseudo-elements - This category includes element names and pseudo-elements, such as h1, div, :before and :after.

Specificity Calculatation

psenger

Common Links

• JQuery Playground
• JQuery Selector Docs

Selector Characters

• # for ID Selections
• . for class Selections
• ^ for attributes start with a value

psenger

let sad = {
    data: '"Wazzzzzzup"',
    // As you can see this is a Arrow funciton
    sayGoGo: () => {
        console.log(`Mr Monkey says ${this.data}`);
    }
};

// This will NOT work. `this` ( the context )

psenger

// Buckets of Data, with two Items appearing at the top of the list.
//    note that OOO and AAA are at the top, whilst everything else is sorted
// Desired outcome: 
// -------------------------------------------------------------------------------------------------
// OOO [ { type: 'OOO', attributes: {} }, { type: 'OOO', attributes: {} } ]
// AAA [ { type: 'AAA', attributes: {} } ]
// BBB [ { type: 'BBB', attributes: {} }, { type: 'BBB', attributes: {} } ]
// ZZZ [ { type: 'ZZZ', attributes: {} }, { type: 'ZZZ', attributes: {} } ]

const desiredFirstItem = 'OOO'

psenger

// Creates a Dictionary / Index Object for all the objects based on the passed attribute value.

/**
 * Create an object with keys based on a passed attribute within the array of values
 * @param {[*]} objects - array of objects
 * @param {string} attributeName - the attribute name
 * @return {*}
 */
var indexByAttribute = function indexByAttribute ( objects, attributeName ) {
    return (objects||[])