Skip to content

Instantly share code, notes, and snippets.

@bcamarda
bcamarda / gist:3127244
Created July 17, 2012 04:51
Active Record Query
Contact.joins(:addresses).includes(:addresses).where("first_name LIKE 'A%').each do |contact|
puts contact.address.inspect
end
@bcamarda
bcamarda / gist:3127234
Created July 17, 2012 04:50
Active Record Query
Contact.joins(:addresses).includes(:addresses).where("first_name LIKE 'A%').each do |contact|
puts contact.address.inspect
end
require 'active_record'
require 'sqlite3'
ActiveRecord::Base.establish_connection :adapter => 'sqlite3',
:database => 'db/address_book.db'
ActiveRecord::Base.connection.execute <<-SQL
-- Address book schema
CREATE TABLE contacts (
@bcamarda
bcamarda / gist:3126795
Created July 17, 2012 03:19
fun times
begin
ActiveRecord::Schema.define do
create_table :listings do |table|
table.column :url, :string
table.column :title, :string
table.column :authors_email, :string
table.column :emailed_at, :datetime
table.column :created_at, :datetime
table.column :updated_at, :datetime
end
@bcamarda
bcamarda / history.erb
Created July 12, 2012 19:35
history for sinatra app for senderbots
<!DOCTYPE html>
<html>
<head>
<h1>Senderbots Craigslist Crawler</h1>
<h3><p>History</p></h3>
</head>
<body>
</body>
@bcamarda
bcamarda / index.erb
Created July 12, 2012 19:35
index for sinatra app for craigslist crawler
<!DOCTYPE html>
<html>
<head>
<h1>Senderbots Craigslist Crawler</h1>
<h3><p>Instructions: Go to Craigslist and create your search, in any category. Copy the URL and paste it below.</p></h3>
<script src= "/bootstrap/js/bootstrap.min.js"></script>
<link rel="stylesheet" type="text/css" href="./bootstrap/css/bootstrap.css"/>
@bcamarda
bcamarda / sender_bots.rb
Created July 12, 2012 19:34
sinatra integration for craigslist crawler
require 'sinatra'
get '/' do
erb :index
end
get '/history' do
erb :history
end
@bcamarda
bcamarda / everlane.rb
Created June 30, 2012 23:31
Everlane Problem
def everlane(string)
new_string = string.gsub(/[bcdefghij]/, "a").gsub(/[MKP]/, "Q")
test_array = []
array = new_string.split(//)
status = "VALID"
array.length.times do
current_letter = array.pop
case current_letter
when "a"
@bcamarda
bcamarda / in_words.js
Created June 27, 2012 03:15
Numbers in Words in JS
var inWords = function(number){
var numberHash = {
0:"", 1:"one", 2:"two", 3:"three", 4: "four", 5: "five", 6: "six", 7: "seven", 8: "eight", 9: "nine", 10: "ten",
11: "eleven", 12: "twelve", 13: "thirteen", 14: "fourteen", 15: "fifteen", 16: "sixteen", 17: "seventeen", 18: "eighteen",
19: "nineteen", 20: "twenty", 30: "thirty", 40: "forty", 50: "fifty", 60: "sixty", 70: "seventy", 80: "eighty", 90: "ninety"
};
if(number <= 20){
return numberHash[number];
}
@bcamarda
bcamarda / sudoku.rb
Created June 26, 2012 19:31
Sudoku Solver - Not solving all yet
# module SudokuSolver
class Gameboard
attr_reader :board, :rows, :columns, :quadrants, :before_array, :after_array
def initialize(initial_values)
@board = []
@rows = []
@columns = []
@quadrants = []
generate_cells(initial_values)