Skip to content

Instantly share code, notes, and snippets.

View joshuastronomy's full-sized avatar

Joshua Flack joshuastronomy

View GitHub Profile
@joshuastronomy
joshuastronomy / todo.sql
Created June 27, 2017 18:09
TIY week 6 day 2 project
-- CREATE the table
CREATE TABLE todos (id SERIAL PRIMARY KEY, title VARCHAR(255) NOT NULL, details VARCHAR(8000), priority INTEGER NOT NULL DEFAULT 1, created_at TIMESTAMP NOT NULL, completed_at TIMESTAMP);
--INSERT five (5) todos, one completed
INSERT INTO todos (title, details, priority, created_at) VALUES ('Harder', 'WUB WUB WUB WUB', 1, current_timestamp);
INSERT INTO todos (title, details, priority, created_at) VALUES ('Better', 'BWOOOOOWOWOWOWOW', 1, current_timestamp);
INSERT INTO todos (title, details, priority, created_at) VALUES ('Faster', 'BOMP BOMP BOMP', 1, current_timestamp);
INSERT INTO todos (title, details, priority, created_at) VALUES ('Stronger', 'UNTZ UNTZ UNTZ UNTZ', 1, current_timestamp);
INSERT INTO todos (title, details, priority, created_at, completed_at) VALUES ('Daft', 'Punk', 1, current_timestamp, current_timestamp);
@joshuastronomy
joshuastronomy / index.html
Created June 1, 2017 19:37
week 2 day 4 proj
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Profile Setup</title>
<link rel="stylesheet" href="styles/main.css">
</head>
<body>
@joshuastronomy
joshuastronomy / index.html
Last active May 31, 2017 18:54
week 2 day 3 responsive layout project
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Responsive Layout</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
@joshuastronomy
joshuastronomy / index.html
Created May 25, 2017 20:00
css project day 4
<!DOCTYPE html>
<html class="no-js" lang="">
<head>
<meta charset="utf-8">
<meta content="IE=edge,chrome=1" http-equiv="X-UA-Compatible">
<title></title>
<meta content="" name="description">
<meta content="width=device-width, initial-scale=1" name="viewport">
<link charset="utf-8" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css" media=
"screen" rel="stylesheet" title="no title">
#!/bin/bash
mkdir project
cd project
touch index.html styles.css README.md
echo "<link rel='stylesheet' href='styles.css'><h1>Hello World!" > index.html
echo "h1{color:red;font-family:sans-serif;text-decoration:underline;}" > styles.css
echo "Hello World!" > README.md
sleep 2
read -p "Press [enter] to continue..."
echo "Congratulations!"