Skip to content

Instantly share code, notes, and snippets.

View RaneWallin's full-sized avatar
💭
Sprinting

Rane Wallin RaneWallin

💭
Sprinting
View GitHub Profile
@RaneWallin
RaneWallin / error.html
Created April 2, 2017 02:56
Error updating category
<!DOCTYPE html>
<html lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>rane-app - Development Environment</title>
<!-- General META -->
<meta charset="utf-8">
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
@RaneWallin
RaneWallin / index.html
Created April 7, 2017 17:57
Markdown Previewer
<div class="page">
<header>
<h1>Hello I'm The Header</h1>
</header>
<div class="content">
<div class="input-area">
fffff
</div>
<div class="preview-area">
ffffff
@RaneWallin
RaneWallin / TapControlledScrollView.js
Last active June 28, 2017 19:49
A React Native component that allows the user to control the scrolling content by tapping up and down icons.
/**
* Created by rane on 6/28/17.
* TapControlledScrollView
* This component allows the user to scroll through content using
* up and down icons. The default scroll behavior is disabled.
*
* scrollDistance property determines how far the view scrolls. Default is 30
*
* Usage:
* <TapControlledScrollView
@RaneWallin
RaneWallin / rane-wallin-resume.md
Last active December 10, 2020 04:12
Rane Wallin's Resume in Markdown

Rane Wallin

25811 W St Kateri Dr
Buckeye, AZ 85326

(623) 498-7649

Rane is a full stack web developer and Java engineer
@RaneWallin
RaneWallin / index.pug
Last active July 23, 2019 22:35
Freddie Mercury in CSS (Day 1)
head
title Freddie Mercury in CSS
body
div.frame
div.hair
@RaneWallin
RaneWallin / hello_epaper1.py
Created August 30, 2019 18:06
First program for the Waveshare 2.7" ePaper HAT
import sys
sys.path.insert(1, "./lib")
import epd2in7b
from PIL import Image, ImageDraw, ImageFont
epd = epd2in7b.EPD() # get the display
epd.init() # initialize the display
print("Clear...") # prints to console, not the display, for debugging
epd.Clear(0xFF) # clear the display
@RaneWallin
RaneWallin / hello_epaper2.py
Created August 30, 2019 18:37
A demo project for the 2.7" ePaper HAT from Waveshare, using the display and the buttons
import sys
sys.path.insert(1, "./lib")
import epd2in7b
from PIL import Image, ImageDraw, ImageFont
from gpiozero import Button
btn = Button(5)
epd = epd2in7b.EPD()
@RaneWallin
RaneWallin / hello_epaper3.py
Last active February 2, 2024 14:03
Complete demo project for the Waveshare 2.7" HAT on Raspberry Pi
import sys # import sys
sys.path.insert(1, "./lib") # add the lib folder to sys so python can find the libraries
import epd2in7b # import the display drivers
from PIL import Image,ImageDraw,ImageFont # import the image libraries
import time
from gpiozero import Button # import the Button control from gpiozero
btn1 = Button(5) # assign each button to a variable
btn2 = Button(6) # by passing in the pin number
<html>
<head>
<meta charset="utf-8">
<title>Page Title</title>
<meta name="description" content="Webpage for xxxx">
<!-- http://meyerweb.com/eric/tools/css/reset/ -->
<link rel="stylesheet" href="css/reset/reset.css">
<!--[if lt IE 9]>
<script src="//html5shiv.googlecode.com/svn/trunk/html5.js" type="text/javascript"></script>
<![endif]-->
Which column is the departments table is intended to be uniquely identifying data?
> id
Which column is being used as a foreign key? Why might we be using a foreign key here rather than storing the data directly in this table?
> Department. It makes more sense to store on a separate table since that multiple tables may need that data
Look at the remaining table schemas in this database. Whiteboard each of the 5 tables, representing them as simple spreadsheet like grids, using arrows to indicate where a particular column is referring to data stored in another table.