Skip to content

Instantly share code, notes, and snippets.

View thomasmarren's full-sized avatar

Tom Marren thomasmarren

5 followers · 3 following
View GitHub Profile
@thomasmarren
thomasmarren / subscription-data-structure.json
Last active October 17, 2017 14:31
{
"twelve_month_total_kwh": {
"actual": 2342,
"forecast": 2144
},
"prev_total_kwh": {
"actual": 234,
"forecast": 212
},
"current_total_kwh": {
@thomasmarren
thomasmarren / gallery.html
Last active January 9, 2017 02:38
@thomasmarren
thomasmarren / countdown_timer.html
Last active November 8, 2016 01:28
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<div id="clockdiv"></div>
</body>
@thomasmarren
thomasmarren / after_init.rb
Created November 1, 2016 12:43
class User < ActiveRecord::Base
after_initialize :starting_balance
def starting_balance
self.balance ||= 100
end
end
@thomasmarren
thomasmarren / useful_active_record.rb
Last active October 18, 2016 12:32
User.find(10)
=> #<User id: 10, name: => "Tom">
User.find(1, 10) #or ([1, 10])
=> #[<User id: 1, name: => "Lifo">, #<User id: 10, name: => "Ryan">]
User.first
User.last
User.all
@thomasmarren
thomasmarren / piglatinize.rb
Last active October 18, 2016 00:55
@@vowels = %w{a e i o u}
def piglatinize(name)
letters_array = name.split("")
first_letter = letters_array[0]
first_cons = []
if !@@vowels.include?(first_letter.downcase)
first_cons << letters_array.shift until @@vowels.include?(letters_array[0])
letters_array += first_cons
end
@@vowels.include?(first_letter.downcase) ? letters_array << "way" : letters_array << "ay"
@thomasmarren
thomasmarren / delete.rb
Last active October 18, 2016 00:53
#Ruby
def self.delete_by_name(name)
sql = "DELETE FROM users WHERE name = ?"
DB[:conn].execute(sql,name)
end
#Active Record
user = User.find_by(name: 'David')
user.destroy
@thomasmarren
thomasmarren / update.rb
Created October 17, 2016 14:03
#Ruby
def self.new_from_db(row)
new_student = self.new(row[1],row[2])
new_student.id = row[0]
new_student
end
def self.find_by_name(name)
sql = "SELECT * FROM users WHERE name = ?"
@thomasmarren
thomasmarren / read.rb
Created October 17, 2016 13:43
#Ruby
class User
def initialize (id = nil, name, grade)
self.name = name
self.grade = grade
@@all << self
end
def self.all
@all
@thomasmarren
thomasmarren / create.rb
Created October 17, 2016 13:34
#Ruby:
def save
sql = "INSERT INTO users (name, age) VALUES (?, ?)"
DB[:conn].execute(sql, self.name, self.age)
@id = DB[:conn].execute("SELECT last_insert_rowid() FROM users")[0][0]
end
user = User.new(name: "Tom", age: 26)
user.save
#Active Record: