Skip to content

Instantly share code, notes, and snippets.

View hoffmanc's full-sized avatar

Chris Hoffman hoffmanc

View GitHub Profile
library(foreign)
setwd("\\\\wrjfiler\\wgx\\07183 - UVM TRC\\Signature #2\\data\\rundata\\CarDataREADONLY")
geo_files <- list.files(pattern=".*GEO.csv", recursive=T)
geo_tables <- c()
for(idx in 1:length(geo_files)){
runid <- sub(".*RUN_(\\d+).*", "\\1", geo_files[idx], perl=T)
mode(runid) <- "integer"
@hoffmanc
hoffmanc / Rhino.Security.schema.sql
Created May 27, 2011 15:07
Rhino.Security on S# 1.9.6
/*
* Sets up the schema for support of Rhino.Security.
* This script assumes that you already have a Users table containing an int primary key of 'Id'
*/
USE Northwind
GO
/****** Object: ForeignKey FKBBE4029387CC6C80 Script Date: 03/12/2009 15:45:24 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'FKBBE4029387CC6C80') AND parent_object_id = OBJECT_ID(N'security_EntityReferences'))
# Chris Hoffman
# 2011-6-17
# Description: takes a
import pyodbc
import sys
import csv
import argparse
import glob
import os
@hoffmanc
hoffmanc / output.irb
Created August 3, 2011 14:48
Problems with awesome_nested_set
chris@ubuntu:~/hud-pinellas$ rails console
Loading development environment (Rails 3.0.9)
irb(main):001:0> task = TimesheetTask.where('parent_id is not null').first
=> #<TimesheetTask id: 11261534, name: "Community Meetings", description: "attendance at meetings with local service providers...", task_type: "Voucher", parent_id: 1065399318, created_at: "2011-07-08 15:48:17", updated_at: "2011-07-08 15:48:17", lft: nil, rgt: nil>
irb(main):002:0> task.ancestors
=> []
irb(main):003:0> task.parent
=> #<TimesheetTask id: 1065399318, name: "Customer Service", description: nil, task_type: "Voucher", parent_id: 600959503, created_at: "2011-07-08 15:48:17", updated_at: "2011-07-08 15:48:17", lft: nil, rgt: nil>
irb(main):004:0> TimesheetTask.rebuild!
=> [#<TimesheetTask id: 36577376, name: "Special Programs (FSS, H, Other)", description: nil, task_type: "Voucher", parent_id: nil, created_at: "2011-07-08 15:48:17", updated_at: "2011-08-03 14:59:37", lft: 1, rgt: 34>, #<TimesheetTask id: 56366788, name: "Staff Meetings",
@hoffmanc
hoffmanc / asdf.r
Created December 23, 2011 16:53
asdf.r
for(i in unique(mcg$runid)) {
png(paste("plots/greater_than_5_meters/",sprintf("%02d",i),".png",sep=""), width=1024, height=768)
df2 <- mcg[mcg$runid == i & mcg$distance > 5,] # remove the second condition for the "all" plots
plot(df2$lon.y, df2$lat.y, cex=0.1)
lines(c(df2$lon.x,df2$lon.y),c(df2$lat.x,df2$lat.y),col=1 + df2$runid %% 31)
title(main=paste("RUN", i), col.main=1+i%%31, font.main=3)
dev.off()
}
@hoffmanc
hoffmanc / profiling_tool.rb
Created April 5, 2012 16:44 — forked from ksarna/profiling_tool.rb
Profiling rails requests with ruby-prof
# You can use this class in your console. For example
# p = ProfilingTools.new
# p.profiled_request(:controller => :welcome, :action => :index)
# this will profile whole application stack and save file in your tmp/profiler folder
# You can also use +request+ method just to see the output for example:
#
# p.request(:controller => :offers, :action => :index)
#
# p.response.body
# p.response.cookies # and so on
@hoffmanc
hoffmanc / fiddle.css
Created April 24, 2012 01:31
Survey Designer
ul {
list-style: disc;
margin: 10px;
padding-left: 10px;
}​
@hoffmanc
hoffmanc / rtn.json
Created May 8, 2012 12:06
This represents the JSON.stringify-ed version of data fetched (via Mongoose) from the database.
[
{
"user_id": "105324781372784188083",
"email": "carmine.moleti@gmail.com",
"verified_email": true,
"name": "Carmine Moleti",
"given_name": "Carmine",
"family_name": "Moleti",
"link": "https://plus.google.com/105324781372784188083",
"picture": "https://lh6.googleusercontent.com/-IqhctvRS11k/AAAAAAAAAAI/AAAAAAAAATE/emxQvFOrhXk/photo.jpg",
@hoffmanc
hoffmanc / returned.sql
Created November 29, 2012 01:22
ActiveRecord tries to do this on update_attributes call
SELECT 1 FROM `models` WHERE
(`models`.`id` = BINARY 'd178546e-39bc-11e2-8b8b-40406f66ce3e'
AND `models`.`id` != 'd178546e-39bc-11e2-8b8b-40406f66ce3e') LIMIT 1
@hoffmanc
hoffmanc / Gemfile
Created December 7, 2012 21:00
Dwolla Active Merchant Integration Example
# added
gem 'activemerchant'