Adam Crownoble adamcrown

I'm a Sr Software Engineer at Instructure with over 20 years of experience as a programmer. I love open source software and beautiful code

adamcrown / gist:662782

Created November 4, 2010 17:11

Minecraft server init file

We couldn’t find that file to show.

adamcrown / .irbrc

Last active November 7, 2023 06:34

My Bundler proof .irbrc file including wirble, awesome_print, hirb, console logging and route helpers

	require 'rubygems' unless defined? Gem # rubygems is only needed in 1.8

	def unbundled_require(gem)
	loaded = false

	if defined?(::Bundler)
	Gem.path.each do \|gems_path\|
	gem_path = Dir.glob("#{gems_path}/gems/#{gem}*").last
	unless gem_path.nil?
	$LOAD_PATH << "#{gem_path}/lib"

adamcrown / time_string_validator.rb

Created May 8, 2012 23:40

Rails validator for time strings

	class TimeStringValidator < ActiveModel::EachValidator
	def validate_each(record, attribute, value)
	require 'chronic'
	record.errors[attribute] << "doesn't seem to be a valid time" unless Chronic.parse(value)
	end
	end

adamcrown / uri_exists_validator.rb

Created May 8, 2012 23:42

Rails validator for URI existence

	# Original credits: http://blog.inquirylabs.com/2006/04/13/simple-uri-validation/
	# HTTP Codes: http://www.ruby-doc.org/stdlib/libdoc/net/http/rdoc/classes/Net/HTTPResponse.html
	require 'net/http'

	class UriExistsValidator < ActiveModel::EachValidator
	def validate_each(record, attribute, value)
	begin # check header response
	url = URI.parse(value)
	request = Net::HTTP.new(url.host, url.port)
	response = request.request_head(url.path.empty? ? '/' : url.path)

adamcrown / absolute_uri_validator.rb

Created May 10, 2012 19:17

Absolute URI validator

	require 'uri'

	class AbsoluteUriValidator < ActiveModel::EachValidator
	def validate_each(record, attribute, value)
	begin
	unless URI.parse(value).absolute?
	record.errors[attribute] << 'is not an absolute URL'
	end
	rescue URI::InvalidURIError => error
	record.errors[attribute] << 'is not a valid URL'

adamcrown / relative_uri_validator.rb

Created May 10, 2012 19:19

Relative URI Validator

	require 'uri'

	class RelativeUriValidator < ActiveModel::EachValidator
	def validate_each(record, attribute, value)
	begin
	unless URI.parse(value).relative?
	record.errors[attribute] << 'is not a relative URL'
	end
	rescue URI::InvalidURIError => error
	record.errors[attribute] << 'is not a valid URL'

adamcrown / validation_helpers.rb

Created May 10, 2012 19:24

RSpec Rails Validation Helper

	# Examples:
	# test_valid_attribute Link, :url => 'http://example.com'
	# test_invalid_attribute Link, :url => 'OH NOES!!!1!'

	module ValidationHelpers
	def test_valid_attribute(model, attr_val_hash)
	test_attribute(:valid, model, attr_val_hash)
	end

	def test_invalid_attribute(model, attr_val_hash)

adamcrown / printing_from_an_oracle_function.sql

Created June 28, 2012 00:19

Printing the results of an Oracle function

	-- Must me NUMBER or CHAR if you want to print it. Printing a VARCHAR is too complex for expensive databases like Oracle.
	VARIABLE r CHAR (1000);

	BEGIN
	-- := is for assignment. vs = for equality
	-- bind variables are prefixed with a colon
	-- BANIST1 is the instance
	-- BSK_INFO_REQUEST is the package
	-- get_prel_codes() is the function
	:r := BANINST1.BSK_INFO_REQUEST.get_prel_codes();

adamcrown / white_pages-template.html

Created January 5, 2013 01:18

A simple Liquid template for "White Pages" reports with the applyfor app

adamcrown / active_record_sessions_batch_delete.rb

Last active December 11, 2015 00:18

Deleting a large batch of session records can really overload the DB (at least MySQL). This script paces it out a bit.

	def batch_session_prune(keep_after = 1.month.ago, batch_by = 1.day, pause_time = 10)
	time = ActiveRecord::SessionStore::Session.order(:updated_at).first[:updated_at]

	while time < keep_after
	time = time + batch_by

	puts "Deleting sessions from #{time.to_s(:short)}"
	ActiveRecord::SessionStore::Session.where('updated_at < ?', time).delete_all

	sleep pause_time