Skip to content

Instantly share code, notes, and snippets.

View cluesque's full-sized avatar

Bill Kirtley cluesque

View GitHub Profile
@cluesque
cluesque / gist:8439915
Created January 15, 2014 16:52
I have a table where I have a row that cannot be found by id. If I go around the PK index, the row is found. If I drop the index, the row is found. If I add a new index, row not found.
d5toqvrtbm8bbu=> SELECT id, created_at FROM widgets WHERE id = 1155301;
id | created_at
---------+----------------------------
1155301 | 2014-01-10 02:59:47.856214
(1 row)
d5toqvrtbm8bbu=> CREATE UNIQUE INDEX widgets_pkey ON widgets(id);
CREATE INDEX
d5toqvrtbm8bbu=> SELECT id, created_at FROM widgets WHERE id = 1155301;
id | created_at
@cluesque
cluesque / gist:7207500
Created October 29, 2013 00:58
traceroute -q1 216.81.59.173
traceroute to 216.81.59.173 (216.81.59.173), 64 hops max, 52 byte packets
...
8 100gigabitethernet11-1.core1.ash1.he.net (184.105.223.165) 14.978 ms
9 10gigabitethernet1-2.core1.atl1.he.net (184.105.213.110) 33.392 ms
10 216.66.0.26 (216.66.0.26) 29.782 ms
11 *
12 episode.iv (206.214.251.1) 120.330 ms
13 a.new.hope (206.214.251.6) 73.192 ms
14 it.is.a.period.of.civil.war (206.214.251.9) 98.692 ms
15 rebel.spaceships (206.214.251.14) 68.083 ms
# Include this in your development and test environments
# if you want to run all Resque processors inline
# (avoiding the need for Redis and a separate worker process)
# In config/environments/{development,test}.rb:
# config.after_initialize do
# require 'resque_inline'
# end
module Resque
# A migration that will continue to work after refactoring
class FutureProofMigration < ActiveRecord::Migration
# Redefine models used in the migration as empty inner classes. This removes all validations and magic.
class Model < ActiveRecord::Base; end
# Either don't rely on associations or declare them as referring to the new inner class
class DependentModel < ActiveRecord::Base
belongs_to :model, :class_name => "FutureProofMigration::Model"
end