Skip to content

Instantly share code, notes, and snippets.

jenny-codes / collage_struct_template.plist
Created December 10, 2021 05:00
Simulate race condition during backup collage upload
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "">
<plist version="1.0">
jenny-codes / list_records_with_duplicate_fields.sql
Created June 1, 2021 03:15
SQL query to list records with duplicate fields
# table: _TABLE_
# possibly duplicated field: _FIELD_
select id, _FIELD_, duplicate_count from (
select id, _FIELD_,
count(_FIELD_) over (partition by _FIELD_) as duplicate_count
from _TABLE_ where _FIELD_ is not null
) as processed_table
where duplicate_count > 1
order by duplicate_count DESC, _FIELD_;
jenny-codes /
Last active May 30, 2021 08:42
SQL query with arbitrary order


Fetch all the columns from table artists with id among (1, 2, 3) and with the arbitrary order (2, 3, 1)


# Option 1
select * from artists join (values(1, 2), (2, 3), (3, 1)) as t (id, ordering) using (id) order by ordering;

# Option 2
select * from artists join unnest(array[2, 3, 1]) WITH ORDINALITY t(id, ordering) using (id) order by ordering;
for i in {0..255}; do feature/3026-start-feed-support-ab-testing-api
printf "\x1b[38;5;${i}mcolour${i}\x1b[0m\n"
jenny-codes / unit-testing-example-restaurtant-test.rb
Created August 30, 2020 06:04
The Example in A Field Guide to Unit Testing series in
# frozen_string_literal: true
require 'rspec'
require_relative 'restaurant'
RSpec.describe Restaurant::Server do
describe '#take_order' do
it 'with French toast passes the order to Cook' do
expect_any_instance_of(Restaurant::Cook).to receive(:make_french_toast)
jenny-codes / assert_database_queries_example.rb
Last active March 9, 2020 00:17
Asserting the number of database queries or cache lookups performed for tests
require 'path/to/test_helper'
class ExampleTest
test 'this should trigger 1 database query' do
assert_db_queries(1) do
# ... code
jenny-codes / custom_graphql_newrelic_tracing.rb
Last active February 21, 2020 13:20
a code example that enables custom GraphQL tracing on NewRelic
class CustomGraphqlNewrelicTracing < GraphQL::Tracing::NewRelicTracing
# We need to create a singleton method here that inherit from the original/parent class.
self.platform_keys = GraphQL::Tracing::NewRelicTracing.platform_keys
# This is the only method we need to overwrite.
def platform_trace(platform_key, key, data)
if key == 'execute_query'
operation = data[:query].selected_operation
# Possible type: 'query', 'mutation', 'subscription'
jenny-codes / literal_calculation.rb
Created December 5, 2019 23:50
an interface that allows basic calculations with strings
%i(one two three four five six seven eight nine ten).each_with_index do |num_literal, i|
define_method(num_literal) do |block = nil|
block ? + 1) : i + 1
def plus(second)
lambda { |first| first + second }
module Resolvers
class RecommendedItems < GraphQL::Schema::Resolver
# Return type and arguments can be specified either here or in the field arguments.
# Uncomment the following if you want to put them here.
# type [CategoryType], null: false
# argument :order_by, Types::ItemOrder, required: false
# argument :category, Types::ItemCategory, required: false
# app/graphql/types/category_type.rb
class CategoryType < GraphQL::Schema::Object
field :key, String, null: true
field :name, String, null: false
field :icon_url, String, null: true
field :related_categories,
null: false,
resolver: Resolvers::RelatedCategoryResolver