Capncavedan

SELECT whatever
  FROM tableName 
WHERE columnToCheck <> CONVERT(columnToCheck USING ASCII)

Capncavedan

OK, it's two weird old tricks.

First, use their bundle caching feature. It's one line added to your .travis.yml file, and significantly speeds up test runs where you haven't changed your gem bundle - which is most of the time for most people.

See more here: http://blog.travis-ci.com/2013-12-05-speed-up-your-builds-cache-your-dependencies/

Second, do some experimentation with your Ruby garbage collection settings to speed up your local test suite runs. Examples from our development environment:

Capncavedan

transaction codes for Texas
For Texas:
1 = CANCEL - Insured's option
2 = CANCEL – Non-payment of premium
3 = CANCEL - Company option
4 = Other (miscellaneous adjustments)
5 = Endorsements
6 = Audit premiums
7 = Reinstatements

Capncavedan

----------------------------------------------------------------------
Goals
----------------------------------------------------------------------

Few steps as possible to “done” & downloadable PDF

Fast! (webpage steps specifically)

Tools to prevent errors:
  live previews

Capncavedan

105th St
L on Vintage
R on 120th
L on Upland
BR on 133rd Ct
R on Kimber Ridge Ave
L on 105th
L on Badger Creek
R on 140th
R on R16 / Quail Ridge

Capncavedan

this guide: https://wiki.postgresql.org/wiki/Alter_column_position#Add_columns_and_move_data


alter table financial_statements add column new_years_in_business integer, add column new_other_net_worth integer;

update financial_statements set new_years_in_business = years_in_business;
update financial_statements set new_other_net_worth = other_net_worth;

alter table financial_statements drop column years_in_business cascade, drop column other_net_worth cascade;

Capncavedan

@http://www.pivotaltracker.com/story/show/9610041
Feature: agent orders theft guard bond
  As an agent I should be able to order a theft guard bond
  with only valid rider combinations

  Background:
    Given the fidelity bond templates
    Given I'm an authenticated agent belonging to an agency
    When I go to the Theft Guard products page
    

Capncavedan

module Enumerable
  def to_histogram
    result = Hash.new(0)
    each { |x| result[x] += 1 }
    result
  end

  def most_popular
    h = self.to_histogram
    max_by { |x| h[x] }

Capncavedan

env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config

Capncavedan

# UPDATED May 16 2012 for ImageRight v5

# How to generate a set of diary items for agencies
# Use rails console, paste list of agency ids into %w below
# Adjust other parameters as appropriate

# IMPORTANT: left pad with zeros to make agency ids 5 digits
agency_ids = %w(  ).map{|a| a.to_s.rjust(5, '0')}.uniq.sort

diary_items = []