Skip to content

Instantly share code, notes, and snippets.

View bobbravo2's full-sized avatar

Bob Gregor bobbravo2

View GitHub Profile
#!/bin/bash
# @Link to the teams docs / confluence / etc.
main() {
if [[ $1 == "-h" ]]; then
print_usage
exit 0
fi
OS=$1
docker_authenticate

Requirements

  1. brew install packer
  2. VMWare Fusion pro

Install

  1. git clone https://github.com/StefanScherer/packer-windows
  2. cd packer-windows
  3. Install the windows guest

SQL (Pre) Warm-up

  1. Is MySQL running?
  2. Are you able to log-in to mysql on the terminal?
  3. Remember to copy/paste as you test your SQL from VSCode into the MySQL console.

SQL Warm-up

  1. Create a new database named games
  2. Create a new table called titles
@bobbravo2
bobbravo2 / warmup.md
Last active September 22, 2017 17:09

Warmup

  1. Create a new GitHub repo called justins-mom-is-once-twice-three-times-a-lady
  2. Add a .gitignore
  3. Add node (group / preset) to .gitignore
  4. Clone the new repo
  5. Add a package.json with 2 requirements
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
</head>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=<device-width>, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
</head>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Captain Planet: The Game</title>
<!-- Bootstrap File -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
<!-- JQuery -->

Look at script_lines.character_id == characters.id AND script_lines.episode_id == episodes.id which gives us the title and original_air_date

Query multiple tables (episodes, characters) - Find when the character moe szyslak first appears.

Part 2

Refactor our SQL to use JOINS

 SELECT * FROM `script_lines`, `characters`, `episodes`
	WHERE `characters`.`name` = 'moe szyslak'
	AND `characters`.`id` = `script_lines`.`character_id`
// Load the NPM Package inquirer
var inquirer = require("inquirer");
// Create a "Prompt" with a series of questions.
inquirer.prompt([
// Here we create a basic text prompt.
{
type: "input",
message: "What is your name?",