Oct 17, 2014

Case insensitive LIKE in postgres (or why it's important to use the same DB for test and prod)

I recently ran into a production bug where a simple 'like' query wasn't working properly, even though I had passing tests which explicitly tested this case.

The problem, of course, is that I was using different databases: sqlite on my dev machine, and postgres on the production machine.

# case insensitive on sqlite
# BUT case sensitive on postgres
where(["description LIKE ?", like_value])

In postgres you need to use 'ILIKE' for case insensitive queries.

# case insensitive on postgres
where(["description ILIKE ?", like_value])

The more important takeaway, however, is to make sure that you use the same database in your test env as do in production!

Oct 2, 2014

Active Admin : Undefined Method `per' for #<ActiveRecord::Relation:> with will_paginate

If you are using both will_paginate and activeadmin, you may see an error like this:

Undefined Method `per' for #<ActiveRecord::Relation:0x.....>

This is because Active Admin uses kaminari for pagination. To fix this error make sure will_paginate and kaminari don't collide, as per : using active admin with will_paginate by adding some config to kaminari:

# create config/initializers/kaminari.rb
Kaminari.configure do |config|
  config.page_method_name = :per_page_kaminari
end

Google is likely to lead you to a github discussion that tells you to use a very specific version of will_paginate, but obviously the solution above is better.

Sep 4, 2014

Focusing your Guard

Guard is great for getting rapid feedback when you'd doing tdd/bdd.  By default, the guard plugins for spec and cucumber watch and run a lot.  Recently I've found myself wanting to just have guard only run the tests which I am focusing on.

After setting up guard-rspec and guard-cucumber I updated my Guardfile to:


def watch_cucumber
  watch(%r{^features/.+\.feature$})
  watch(%r{^features/support/.+$})          { 'features' }
  watch(%r{^features/step_definitions/(.+)_steps\.rb$}) { |m| Dir[File.join("**/#{m[1]}.feature")][0] || 'features' }
end

def watch_rspec
  watch(%r{^spec/.+_spec\.rb$})
  watch(%r{^lib/(.+)\.rb$})     { |m| "spec/lib/#{m[1]}_spec.rb" }
  watch('spec/spec_helper.rb')  { "spec" }

  # Rails example
  watch(%r{^app/(.+)\.rb$})                           { |m| "spec/#{m[1]}_spec.rb" }
  watch(%r{^app/(.*)(\.erb|\.haml|\.slim)$})          { |m| "spec/#{m[1]}#{m[2]}_spec.rb" }
  watch(%r{^app/controllers/(.+)_(controller)\.rb$})  { |m| ["spec/routing/#{m[1]}_routing_spec.rb", "spec/#{m[2]}s/#{m[1]}_#{m[2]}_spec.rb", "spec/acceptance/#{m[1]}_spec.rb"] }
  watch(%r{^spec/support/(.+)\.rb$})                  { "spec" }
  watch('config/routes.rb')                           { "spec/routing" }
  watch('app/controllers/application_controller.rb')  { "spec/controllers" }
  watch('spec/rails_helper.rb')                       { "spec" }

  # Capybara features specs
  watch(%r{^app/views/(.+)/.*\.(erb|haml|slim)$})     { |m| "spec/features/#{m[1]}_spec.rb" }

  # Turnip features and steps
  watch(%r{^spec/acceptance/(.+)\.feature$})
  watch(%r{^spec/acceptance/steps/(.+)_steps\.rb$})   { |m| Dir[File.join("**/#{m[1]}.feature")][0] || 'spec/acceptance' }
end


group :tests do
  guard :cucumber, cmd: 'spring cucumber' do
    watch_cucumber
  end

  guard :rspec, cmd: 'spring rspec' do
    watch_rspec
  end
end


# Run guard -g focus
# It will watch all the reguslar rspec and cucumber watches files
# but will only run:
# cucumber tests tagged with @focus
# rspec tests with :focus => true
group :focus do
  logger level: :warn
  logger template: ':message'

  guard :rspec, cmd: 'spring rspec --tag focus' do
    watch_rspec
  end

  guard 'cucumber', command_prefix: 'spring', bundler: false, cli: '--profile focus' do
    watch_cucumber
  end
end

This creates 2 groups ('focus' and 'tests'). The focus group only runs the tests that I have tagged as a focus. ('@focus' in cucumber and 'focus: true' in spec). The focus:cucumber guard file definition tells cucumber to use the profile 'focus'. Alternatively I could have used the focus_on option but a profile feels cleaner. In order to use a profile you need to set it up in cucumber.yml like so:


focus: --format progress --strict --tags @focus

Then, when I want guard to automatically run only the tests I've tagged with focus, I run:


guard -g focus

I find this really helps me get into the flow when writing code. If I'm doing something that could affect a to of areas, I can still run guard -g tests to fall back on the default guard behaviour.

Sep 5, 2012

Restarting iPhone with broken lock button

I ran into a situation where I needed to restart my iPhone, but unfortunately the lock button was broken.  Normally a restart requires holding the lock button and home button for 8 seconds.

Fortunately - you can use AssistiveTouch to get on screen versions of those buttons.

  1. Open the Settings app
  2. Tap "General"
  3. Tap "Accessibility"
  4. In the "Physical & Motor" section tap on "AssistiveTouch"
  5. Turn "AssistiveTouch" on
  6. A white circle will appear in the bottom right. Tap it.
  7. Tap on "Device".
  8. Hold the on screen "Lock Screen" icon and the real home button at the same time, for 8 seconds.
  9. Voila!

After your iphone restarts you'll want to go back an turn AssistiveTouch off.

Mar 31, 2012

On Techcrunch

Today I tweeted a screenshot of Tweetdeck when it was letting me access other people’s accounts.  Techcrunch (and now CNN, CNET, WSJ, MSNBC) picked up the story.  It’s nice to get on Techcrunch, I just wish it had been for Little Big Thinkers or MomentVille :-S

To be clear – I DID NOT HACK Tweetdeck (I’m looking at you WSJ).  All I did was log in and I saw and could post from the other accounts.

Mar 29, 2012

Rocket Speller is What’s Hot

We’re very pleased that Rocket Speller has been featured in the New and Noteworthy and What’s Hot sections of the iTunes App Store for the Education, Educational Games, and Kids Games sections.

We also hit a big milestone recently with over 1,000,000 words spelled!  If you haven’t got it yet, go get it now. It’s a FREE!

Sep 27, 2011

Unresolved Symbols CAKeyframeAnimation : iOS Animation

I was trying to do some stuff with CoreAnimation and ended up with this compile error:


Undefined symbols for architecture i386:
  "_OBJC_CLASS_$_CAKeyframeAnimation", referenced from:
      objc-class-ref in SpellPageViewController.o
ld: symbol(s) not found for architecture i386
collect2: ld returned 1 exit status

To fix it: Make sure you have linked the QuartzCore library.

Sep 2, 2011

UIActionSheet Cancel Button Not Working

I’m working on a app that has a tab bar with an “Add” button in the middle of that tab bar.

The first step when that “Add” button is hit is to display an UIActionSheet. I found, however, that they “Cancel” button on the action sheet was not clickable. After much confusion, this stack overflow post helped me.

How you display the UIActionSheet is very important. I had copied the Apple NavBar demo that uses it, which used the following code to launch it:


UIActionSheet *styleAlert = [[UIActionSheet alloc] initWithTitle:@"Choose a UIBarStyle:" delegate: self cancelButtonTitle:@"Cancel"
									   destructiveButtonTitle: nil
										otherButtonTitles: @"Default", @"BlackOpaque", @"BlackTranslucent", nil, nil];

[styleAlert showInView:self.view];
[styleAlert release];

The problem is that if you have a UITabBarController, it’s tab bar view takes precedence on the touch (even though the UIActionSheet appears on top), so the Cancel button isn’t actually clicked.

To fix it you need to launch the UIActionSheet differently:


UIActionSheet *styleAlert = [[UIActionSheet alloc] initWithTitle:@"Choose a UIBarStyle:" delegate: self cancelButtonTitle:@"Cancel"
									   destructiveButtonTitle: nil
										otherButtonTitles: @"Default", @"BlackOpaque", @"BlackTranslucent", nil, nil];

// The proper way to do it if there is a tab bar
[typeSelection showFromTabBar:self.tabBarController.tabBar];
[styleAlert release];
Aug 28, 2011

I’m Shopping – Don’t Kick Me Out of Your Store

You wouldn’t believe what happened to me the other. I was in the Apple store and I saw a trackpad and a mouse that I wanted to buy. I paid for the trackpad first which was very easy to do. But then, before I could buy the mouse one of the employees took me out to the street an began to unwrap my trackpad. I knew I wanted the mouse, so I had to go back in to the store, find the mouse all over again, and then buy it. I had thought of getting a new keyboard too, but decided it wasn’t worth the hassle of getting kicked out to the street again…

While this obviously didn’t happen at a real store – it happens everyday in the App Store. Especially on the iPhone! As soon you select an App you are taken to the home screen to see that it is being downloaded. It serves the purpose of informing people where there app is going, and that the purchase worked properly. A message within the App Store app itself would serve the same purpose and be far less intrusive.

One particularly painful point is when you download an app that you found after scrolling down a few pages in the search results. Searches in the App Store are reset to show only the first page (25 entries) when the App Store app exits.

There have times when i would have bought another app if i had been left in the store, but didn’t feel like putting in the effort to go back after being kicked out. That’s an extra 30c that Apple could have had from me but didn’t. Their loss…