jenny-codes

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
	<key>scraps</key>
	<array>
		<dict>
			<key>image</key>
			<dict>
				<key>source_url</key>

jenny-codes

# 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

Question

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

Solutions

# 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;

jenny-codes

for i in {0..255}; do                                                                                              feature/3026-start-feed-support-ab-testing-api
  printf "\x1b[38;5;${i}mcolour${i}\x1b[0m\n"
done

jenny-codes

# 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

require 'path/to/test_helper'

class ExampleTest
  test 'this should trigger 1 database query' do
    assert_db_queries(1) do
      # ... code
    end
  end
end

jenny-codes

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

%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 ? block.call(i + 1) : i + 1
  end
end

def plus(second)
  lambda { |first| first + second }
end

jenny-codes

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

jenny-codes

# 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, 
        [CategoryType],
        null: false,
        resolver: Resolvers::RelatedCategoryResolver