floehopper’s gists

floehopper / download

Created November 16, 2024 10:52

Download file using multiple parallel Range requests

floehopper / liquid-templates-and-date-formats.rb

Created July 24, 2024 12:36 — forked from chrisroos/liquid-templates-and-date-formats.rb

Playing with date formatting in liquid templates - Useful in Harmonia task titles

floehopper / inspect-retrying-jobs-in-sidekiq.rb

Created June 14, 2023 11:13

Inspect retrying jobs in Sidekiq

	require 'sidekiq/monitor'

	Sidekiq::RetrySet.new.each do \|job\|
	p [job.display_class, job.display_args]
	end

floehopper / format_aldermore_bank_csv_for_upload_to_freeagent.rb

Last active June 9, 2023 12:30

Format Aldermore Bank CSV for upload to FreeAgent

	# See https://support.freeagent.com/hc/en-gb/articles/115001222564-How-to-format-a-CSV-file-to-upload-a-bank-statement#h_01FWZVYY1GEEGAPKJHG6FKV2HM

	require 'csv'

	CSV($stdin, headers: true, skip_blanks: true) do \|csv\|
	csv.each do \|row\|
	puts([
	Date.parse(row['Date']).strftime("%d/%m/%Y"),
	row['Amount'].gsub(/,/, ''),
	row['Description'].gsub(/,/, '')

floehopper / Rollbar.svelte

Last active January 6, 2023 10:50

Rollbar configuration in a SvelteKit app - both client-side & server-side

	<script>
	/* eslint-disable */

	import { mode } from "$app/env";
	import { onMount } from "svelte";

	const rollbarAccessToken = import.meta.env
	.VITE_ROLLBAR_POST_CLIENT_ITEM_ACCESS_TOKEN;

	const codeVersion = import.meta.env.VITE_LATEST_SHA;

floehopper / run-migration-from-rails-console.rb

Created September 6, 2022 19:55

Run migration from Rails console

	migration_context = ActiveRecord::Base.connection.migration_context

	migration_context.migrate(target_version = nil)
	migration_context.rollback(steps = 1)
	migration_context.forward(steps = 1)
	migration_context.up(target_version = nil)
	migration_context.down(target_version = nil)
	migration_context.current_version

floehopper / validate-parameters-against-method-signature.rb

Created August 14, 2022 11:22

Validate parameters against method signature

	def valid?(method, ...)
	signature = method.inspect
	pattern = %r{(?:\.\|#)#{method.name}$([^$]*)\)}
	params = signature.match(pattern)[1]
	params_with_nil_default_values = params.gsub('...', 'nil')
	klass = Class.new
	klass.class_eval "def self.#{method.name}(#{params_with_nil_default_values})\nend\n"
	klass.public_send(method.name, ...)
	true
	rescue ArgumentError => e

floehopper / display_changed_row_counts.rb

Created February 1, 2022 14:52

Display changed row counts using ActiveRecord

	def row_counts
	Hash[*ApplicationRecord.connection.execute(%{
	ANALYZE;
	SELECT
	pgClass.relname AS tableName,
	pgClass.reltuples AS rowCount
	FROM
	pg_class pgClass
	INNER JOIN
	pg_namespace pgNamespace ON (pgNamespace.oid = pgClass.relnamespace)

floehopper / flatten

Created December 27, 2021 11:26

Flatten files in sub-directories into single directory

	#!/usr/bin/env ruby

	require 'pathname'
	require 'fileutils'

	pwd = Pathname.pwd

	begin
	source = Pathname.new(ARGV[0].nil? ? pwd : ARGV[0]).realpath
	destination = Pathname.new(ARGV[1].nil? ? pwd: ARGV[1]).realpath

floehopper / zx81-print-hi.bas

Created November 22, 2020 11:39

ZX81 machine code program to print "HI"

	def valid?(method, ...)
	signature = method.inspect
	pattern = %r{(?:\.\|#)#{method.name}\(([^\)]*)\)}
	params = signature.match(pattern)[1]
	params_with_nil_default_values = params.gsub('...', 'nil')
	klass = Class.new
	klass.class_eval "def self.#{method.name}(#{params_with_nil_default_values})\nend\n"
	klass.public_send(method.name, ...)
	true
	rescue ArgumentError => e

James Mead floehopper