Tom Lord tom-lord

## "A dark room" save file
eyJ2ZXJzaW9uIjoxLjMsImZlYXR1cmVzIjp7ImxvY2F0aW9uIjp7InJvb20iOnRydWUsIm91dHNpZGUiOnRydWUsIndvcmxkIjp0cnVlLCJzcGFjZVNoaXAiOnRydWV9fSwic3RvcmVzIjp7Indvb2QiOjY1MjUsIm1lYXQiOjU2MzAsImJhaXQiOjczOSwic2NhbGVzIjo2NywidGVldGgiOjUwNCwiZnVyIjoyMzAwNCwiY2xvdGgiOjIzNywiY2hhcm0iOjYsImN1cmVkIG1lYXQiOjQzMCwiY29tcGFzcyI6MSwibGVhdGhlciI6MTAxOCwibWVkaWNpbmUiOjUsImJvbmUgc3BlYXIiOjEsInRvcmNoIjo5NSwibCBhcm1vdXIiOjEsIndhdGVyc2tpbiI6MSwicnVja3NhY2siOjEsImlyb24iOjU4MiwiaXJvbiBzd29yZCI6MCwiY2FzayI6MSwid2Fnb24iOjEsInN0ZWVsIHN3b3JkIjoyLCJzdGVlbCI6NDU4LCJpIGFybW91ciI6MSwiY29hbCI6MjgzLCJidWxsZXRzIjo0NjcsImJvbGFzIjoyLCJzIGFybW91ciI6MSwiY29udm95IjoxLCJ3YXRlciB0YW5rIjoxLCJyaWZsZSI6NSwiYmF5b25ldCI6MCwic3VscGh1ciI6NDE0LCJhbGllbiBhbGxveSI6MCwiZW5lcmd5IGNlbGwiOjEyLCJsYXNlciByaWZsZSI6MX0sImNoYXJhY3RlciI6eyJwdW5jaGVzIjo0MCwic3RhcnZlZCI6MSwicGVya3MiOnsic3RlYWx0aHkiOnRydWUsInNjb3V0Ijp0cnVlfX0sImluY29tZSI6eyJnYXRoZXJlciI6eyJkZWxheSI6MTAsInN0b3JlcyI6eyJ3b29kIjoyNX0sInRpbWVMZWZ0Ijo4fSwiYnVpbGRlciI6eyJkZWxheSI6MTAsInN0b3JlcyI6eyJ3b29kIjoyfSwidGltZUxlZnQi

## edd_cow.rb
class Cow
  def 🔪
    "🥩 "
  end
end

🐄 = Cow.new

puts 🐄.🔪 # => 🥩

## edd_cow_test.rb
require 'minitest/autorun'
require 'minitest/emoji'

module MiniTest
  class Emoji
    add_utf_theme :carwow,  0x1f3ce, 0x1f694, 0x1f690, 0x1f6b6
  end
end

describe Cow do

## lease_deal_expire_all_1.rb
class LeaseDeal < ApplicationRecord
  def self.expire_all(time: Time.current)
    update_all(expired_at: time)
  end
end

## lease_deals_error_1.sql
UPDATE "lease_deals"
SET    "expired_at" = '2018–10–08 23:50:50.138061'
WHERE  "lease_deals"."expired_at" IS NULL
       AND "lease_deals"."dealership_id" = 1234
       AND ( updated_at < '2018–10–08 23:47:32.862470' )

## lease_deal_expire_all_2.rb
class LeaseDeal < ApplicationRecord
  def self.expire_all(time: Time.current, batch_size: 1000)
    in_batches(of: batch_size).update_all(expired_at: time)
  end
end

## lease_deals_error_2.sql
SELECT "lease_deals"."id"
FROM   "lease_deals"
WHERE  "lease_deals"."expired_at" IS NULL
       AND "lease_deals"."dealership_id" = 1234
       AND ( updated_at < '2018-10-09 09:34:11.818701' )
ORDER  BY "lease_deals"."id" ASC
LIMIT  1000

## lease_deals_explain_1.sql
 Bitmap Heap Scan on lease_deals  (cost=172.99..18520.04 rows=5903 width=205)
   Recheck Cond: (dealership_id = 1234)
   Filter: ((expired_at IS NULL) AND (updated_at < '2018-10-09 09:34:11.818701'::timestamp without time zone))
   ->  Bitmap Index Scan on index_lease_deals_on_dealership_id  (cost=0.00..172.70 rows=9724 width=0)
         Index Cond: (dealership_id = 1234)

## lease_deals_index_migration.rb
class AddPartialIndexOnDealershipIdAndExpiredAtToLeaseDeals < ActiveRecord::Migration[5.2]
  def change
    add_index :lease_deals, %i[dealership_id expired_at], where: 'expired_at IS NULL', algorithm: :concurrently
  end
end

## lease_deals_explain_2.sql
 Bitmap Heap Scan on lease_deals  (cost=448.02..903.13 rows=5903 width=205)
   Recheck Cond: ((dealership_id = 1234) AND (expired_at IS NULL))
   Filter: ((updated_at < '2018-10-09 09:34:11.818701'::timestamp without time zone))
   ->  Bitmap Index Scan on index_lease_deals_on_dealership_id_and_expired_at  (cost=0.00..411.04 rows=6724 width=0)
         Index Cond: (dealership_id = 1234)
	class Cow
	def 🔪
	"🥩 "
	end
	end

	🐄 = Cow.new

	puts 🐄.🔪 # => 🥩
	require 'minitest/autorun'
	require 'minitest/emoji'

	module MiniTest
	class Emoji
	add_utf_theme :carwow, 0x1f3ce, 0x1f694, 0x1f690, 0x1f6b6
	end
	end

	describe Cow do
	class LeaseDeal < ApplicationRecord
	def self.expire_all(time: Time.current)
	update_all(expired_at: time)
	end
	end
	UPDATE "lease_deals"
	SET "expired_at" = '2018–10–08 23:50:50.138061'
	WHERE "lease_deals"."expired_at" IS NULL
	AND "lease_deals"."dealership_id" = 1234
	AND ( updated_at < '2018–10–08 23:47:32.862470' )
	class LeaseDeal < ApplicationRecord
	def self.expire_all(time: Time.current, batch_size: 1000)
	in_batches(of: batch_size).update_all(expired_at: time)
	end
	end
	SELECT "lease_deals"."id"
	FROM "lease_deals"
	WHERE "lease_deals"."expired_at" IS NULL
	AND "lease_deals"."dealership_id" = 1234
	AND ( updated_at < '2018-10-09 09:34:11.818701' )
	ORDER BY "lease_deals"."id" ASC
	LIMIT 1000
	Bitmap Heap Scan on lease_deals (cost=172.99..18520.04 rows=5903 width=205)
	Recheck Cond: (dealership_id = 1234)
	Filter: ((expired_at IS NULL) AND (updated_at < '2018-10-09 09:34:11.818701'::timestamp without time zone))
	-> Bitmap Index Scan on index_lease_deals_on_dealership_id (cost=0.00..172.70 rows=9724 width=0)
	Index Cond: (dealership_id = 1234)
	class AddPartialIndexOnDealershipIdAndExpiredAtToLeaseDeals < ActiveRecord::Migration[5.2]
	def change
	add_index :lease_deals, %i[dealership_id expired_at], where: 'expired_at IS NULL', algorithm: :concurrently
	end
	end
	Bitmap Heap Scan on lease_deals (cost=448.02..903.13 rows=5903 width=205)
	Recheck Cond: ((dealership_id = 1234) AND (expired_at IS NULL))
	Filter: ((updated_at < '2018-10-09 09:34:11.818701'::timestamp without time zone))
	-> Bitmap Index Scan on index_lease_deals_on_dealership_id_and_expired_at (cost=0.00..411.04 rows=6724 width=0)
	Index Cond: (dealership_id = 1234)