smerchek

select t.table_schema,
       t.table_name,
       CASE WHEN EXISTS(SELECT *
       FROM information_schema.columns c 
       WHERE c.table_name = t.table_name 
                                and c.table_schema = t.table_schema
                                and c.column_name = t.table_name || '_id'
       ) THEN '✅' ELSE '❌' END
 AS has_matching_id_column,
       (SELECT c.column_name

smerchek

Keybase proof

I hereby claim:

• I am smerchek on github.
• I am smerchek (https://keybase.io/smerchek) on keybase.
• I have a public key ASCbCRQMa6fnJ3sJ14paAMNA63zd95yVF6OBZkXGuQl7Ugo

To claim this, I am signing this object:

smerchek

Abbrev	Direction
q	EVERY
qH	EVERY HOUR
qAM	EVERY MORNING
qPM	EVERY EVENING
qHS	EVERY BEDTIME
qD	EVERY DAY
qOD	EVERY OTHER DAY
qWK	EVERY WEEK

smerchek

Keybase proof

I hereby claim:

• I am smerchek on github.
• I am smerchek (https://keybase.io/smerchek) on keybase.
• I have a public key whose fingerprint is E304 46D8 1409 1FEC 7106 8F61 64AB 9A52 9682 653B

To claim this, I am signing this object:

smerchek

require 'rspec'
require 'blinky'

# Usage: rspec --require blink_formatter.rb --format BlinkFormatter

# fix issue where no light will cause lock-up
module Blinky
  class LightFactory
    class << self
      alias :original_detect_lights :detect_lights

smerchek

var list = $$("span.a-color-price.a-size-base");
var total=0;
for(i=0; i<list.length;i++){
  total += parseFloat(list[i].innerText.replace("$",""));
}
alert(list.length+" items for a total of: $"+total.toFixed(2));

smerchek

Putting the D&D in TDD (FULL DAY)

Guy Royse; George Walters

• Slides
• GitHub

I used Ruby and Minitest with my Blink(1) to TDD through this very big Kata. It was fun and a great learning experience. It did a good job of going slowly at first to get the basics and then ramping up. There is much left that I could do here for further practice.

Sweet Elixir! A Gentle Introduction to Erlang’s cute younger brother Elixir (FULL DAY)

Ryan Cromwell; Chris McCord

smerchek

Learning Rails for Fun and Nonprofit

There are a lot of nonprofits that need help building websites. While wordpress may suffice for many of these organizations, some have requirements that are better suited to an actual website. With free/cheap tools like Heroku and other database/logging services, quickly building a website that meets a nonprofit’s needs is very approachable. This is the perfect type project for learning Ruby on Rails.

In this session, Scott will talk about the benefits of using a Nonprofit web project to learn Rails and what he learned while building LoveKC.org. While this is not an in-depth introduction to Rails, expect to learn about various aspects of getting started with Rails like setting up user authentication and roles, geocoding, search with elasticsearch, mailings (Mailchimp and Mandrill), and image upload/manipulation. This is a good equipping session, showing you not only what is possible with Rails, but also how to start the journey yourself.

smerchek

Facility Permit #,Establishment Name,Facility Name,Facility Street No.,Facility Street Name,Facility Unit No,Facility City,Facility State,Facility Zip,Business Status,Facility Type,Permit Type,Web Site,Operational Status,Location 1
, Delaware Cafe, Delaware Cafe,300,Delaware,,Kansas City,MISSOURI,64105,Closed,Restaurant/Deli 0-5 Employees,,,Operational,"300 Delaware
Kansas City, MISSOURI 64105
(39.10926928022309, -94.58450117517305)"
,12TH & BALTIMORE,12TH & BALTIMORE,106 W 12TH ST,,Attn:  Accounting Department,KANSAS City,MISSOURI,64105,Open,Restaurant/Deli 0-5 Employees,,,Operational,"106 W 12TH ST Attn: Accounting Department
KANSAS City, MISSOURI 64105
(39.103149999772825, -94.58638000023666)"
,135TH ST. B B Q,135TH ST. B B Q,325 E. 135TH ST,,,KANSAS CITY,MISSOURI,64145,Closed,Restaurant/Deli 0-5 Employees,,,Operational,"325 E. 135TH ST
KANSAS CITY, MISSOURI 64145
(38.882631716603704, -94.59216179033736)"

smerchek

# This is the basic structure for a Windows project puppet module at Softek
# We found that the Package type as provided by Puppet was not quite sufficient for our needs.
# Instead, we transfer the file, exec msiexec when it changes (while logging install output), and then ensure the service is running.
class some_project {
  $installer = 'Project.Setup.msi'
  $url = "puppet:///release/${installer}"

  file { "c:/packages/${installer}":
    ensure => 'file',
    mode   => '1777',