David J. Burger dburger

dburger / gist:116992

Created May 24, 2009 07:05

	class AddSetPositionsStoredProc < ActiveRecord::Migration

	STORED_PROC_NAME = 'set_positions'

	CREATE_STORED_PROC_SQL = %Q{
	CREATE PROCEDURE #{STORED_PROC_NAME}()
	BEGIN
	DECLARE done INT DEFAULT 0;
	DECLARE pid INT;
	DECLARE curs CURSOR FOR SELECT DISTINCT parent_id FROM units;

dburger / gist:116982

Created May 24, 2009 06:22

	require 'active_record/fixtures'

	namespace :data do

	# pipe separated values and yaml for now
	EXTENSIONS = ['psv', 'yml']

	desc 'Truncate and load tables with seed data'
	task :seed => :environment do
	EXTENSIONS.each do \|ext\|

dburger / gist:110320

Created May 12, 2009 05:12

	database_name:
	adapter: sqlserver
	mode: ODBC
	dsn: 'DRIVER=FreeTDS;TDS_Version=8.0;SERVER=Your_Server_Name;DATABASE=Your_Database_Name;Port=1433;uid=Your_UID;pwd=Your_PWD;'

dburger / gist:110317

Created May 12, 2009 05:04

	database_name:
	adapter: sqlserver
	mode: ODBC
	dsn: 'DRIVER=/usr/local/lib/libtdsodbc.so;TDS_Version=8.0;SERVER=Your_Server_Name;DATABASE=Your_Database_Name;Port=1433;uid=Your_UID;pwd=Your_PWD;'

dburger / gist:109454

Created May 10, 2009 00:18

	SELECT
	CASE WHEN GROUPING(
	CASE WHEN service_grade_code IN ('E01','E02','E03','E04','E05','E06','E07','E08','E09','O01','O02','O03','O04','O05','O06','O07','O08','O09','W01','W02','W03','W04','W05') THEN
	service_grade_code
	ELSE
	'Unknown'
	END
	) = 1 THEN
	'All Ranks'
	ELSE

dburger / gist:109453

Created May 10, 2009 00:17

	SELECT
	CASE WHEN GROUPING(service) = 1 THEN 'All' ELSE service END service,
	SUM(CASE WHEN mm.service_grade_code = 'E01' THEN 1 ELSE 0 END) e01,
	100 * ROUND(CASE WHEN SUM(1) = 0 THEN 0 ELSE SUM(CASE WHEN mm.service_grade_code = 'E01' THEN 1 ELSE 0 END) / CAST(SUM(1) AS FLOAT) END, 4) e01_percentage,
	-- ... lots more service grade codes here
	SUM(CASE WHEN mm.service_grade_code = 'W05' THEN 1 ELSE 0 END) w05,
	100 * ROUND(CASE WHEN SUM(1) = 0 THEN 0 ELSE SUM(CASE WHEN mm.service_grade_code = 'W05' THEN 1 ELSE 0 END) / CAST(SUM(1) AS FLOAT) END, 4) w05_percentage,
	SUM(CASE WHEN mm.service_grade_code NOT IN ('E01','E02','E03','E04','E05','E06','E07','E08','E09','O01','O02','O03','O04','O05','O06','O07','O08','O09','W01','W02','W03','W04','W05') OR mm.service_grade_code IS NULL THEN 1 ELSE 0 END) unknown,
	100 * ROUND(
	CASE WHEN SUM(1) = 0 THEN

dburger / gist:107584

Created May 6, 2009 16:07

	<Location />
	AuthType Basic
	AuthName "Fabulous Demo"
	AuthUserFile /path/to/htaccess/file
	Require valid-user
	</Location>

dburger / gist:107568

Created May 6, 2009 15:50

flash[:notice] = render_to_string(:partial => 'foo_deleted')

dburger / gist:107445

Created May 6, 2009 08:55

fetchmail -d 300 --smtpname [email protected] -p POP3 -u dburger 172.16.100.7

dburger / gist:107442

Created May 6, 2009 08:45