Bryce McDonnell brycemcd

Software Developer - Business Intelligence

Job Summary:

Innovation is our driving force at The Clymb, and a human-powered approach to creative technology and solutions is our passion. We’re seeking a software developer in our business intelligence (BI) division who will be instrumental in designing and implementing our data systems. This role will aggregate data from various sources to optimize our business intelligence in the form of efficient, functional systems. This is an opportunity to make a big impact by joining a high growth company early in its development.

#Terminal sorcery with tmux

by @brycemcd

Files used:

	-- AS ADMIN USER
	-- create extension, server and fdw

	CREATE EXTENSION mysql_fdw;

	CREATE SERVER mysql_svr
	FOREIGN DATA WRAPPER mysql_fdw
	OPTIONS (address 'localhost', port '3306');

	-- GRANTS

	-- create user:
	CREATE COLE user_name LOGIN PASSWORD 'password' SUPERUSER;

	-- create role:
	CREATE ROLE overlord;

	-- grant role to user:
	GRANT overlord TO user_name;

	-- Not very many privs

	" test the current file in the next tmux window
	nmap <leader>tt :!tmux send-keys -t 1 "rspec %" C-m <cr>
	" test the line from user input
	nmap <leader>tl :!tmux send-keys -t 1 "rspec %:<C-r>=line('.')<cr>" C-m <cr>

	# Yesterday's deploy tag:

	20120801

	# See what's been merged today, what's about to deploy:

	# https://github.com/TheClymb/theclymb/compare/20120801...HEAD

	# Tag the current release for deploy:

	1) MasterAsset validations after_create should fill in sha with the SHA1 of the file and the url with the url
	Failure/Error: mi.image = img
	AWS::Errors::Base:
	# /usr/local/rvm/gems/ruby-1.9.3-p125@theclymb3/gems/aws-sdk-1.3.3/lib/aws/core/client.rb:261:in `return_or_raise'
	# /usr/local/rvm/gems/ruby-1.9.3-p125@theclymb3/gems/aws-sdk-1.3.3/lib/aws/core/client.rb:323:in `client_request'
	# (eval):3:in `head_object'
	# /usr/local/rvm/gems/ruby-1.9.3-p125@theclymb3/gems/aws-sdk-1.3.3/lib/aws/s3/s3_object.rb:94:in `head'
	# /usr/local/rvm/gems/ruby-1.9.3-p125@theclymb3/gems/aws-sdk-1.3.3/lib/aws/s3/s3_object.rb:71:in `exists?'
	# /usr/local/rvm/gems/ruby-1.9.3-p125@theclymb3/gems/paperclip-2.5.2/lib/paperclip/storage/s3.rb:237:in `exists?'
	# /usr/local/rvm/gems/ruby-1.9.3-p125@theclymb3/gems/paperclip-2.5.2/lib/paperclip/attachment.rb:460:in `block in queue_existing_for_delete'

	" BAREBONES STUFF
	" sanity things
	set number
	syntax on
	"indent settings
	set shiftwidth=2
	set softtabstop=2
	set expandtab
	set autoindent

	has_attached_file :main, :styles => { :grid => "250x390>",
	:detail => "400x600>",
	:thumb => "75x75#",
	:trans => { :processors => [:trans_to_dark] }
	},
	:default_url => "/images/missing.png",
	:storage => :s3,
	:s3_credentials => "#{RAILS_ROOT}/config/s3.yml",
	:bucket => "mybuck",
	:path => "product_images/:id/main/:style.:extension"

	BEGIN;
	UPDATE inventories SET inventory_amount = 99;
	COMMIT;