bf4

# A script to migrate Sidekiq's redis to a new server.
# This obviously can work for any redis, but I only handled
# data types that Sidekiq uses.

require 'redis'

old_redis = Redis.new url: 'redis://old-redis:6379'
new_redis = Redis.new url: 'redis://new-redis:6379'

unknowns = []

bf4

on CI and local

export RUBYOPT="-W:deprecated" # show warnings, deprecations only

bf4

#!/usr/bin/env ruby

require(Dir.pwd + "/config/environment")

ActiveRecord::Base.configurations.configs_for(env_name: ActiveRecord::Tasks::DatabaseTasks.env).each do |db_config|
  ActiveRecord::Base.establish_connection(db_config.config)

  context = ActiveRecord::Base.connection.migration_context

  missing_migrations = []

bf4

require "active_record"

databases = ActiveRecord::Tasks::DatabaseTasks.setup_initial_database_yaml

db_namespace = namespace :db do
  if Rails.version.start_with?("6.0")

    # https://github.com/rails/rails/pull/38770/files
    namespace :rollback do
      ActiveRecord::Tasks::DatabaseTasks.for_each(databases) do |name|

bf4

#!/usr/bin/env ruby

# List all keys stored in memcache. 
# Credit to Graham King at http://www.darkcoding.net/software/memcached-list-all-keys/ for the original article on how to get the data from memcache in the first place.

require 'net/telnet'
require 'csv'

headings = %w(id expires bytes key)
rows = []

bf4

class DatabaseController < ApplicationController
  def database_dump
    database = Rails.configuration.database_configuration[Rails.env]["database"]
    send_file_headers!(:type => 'application/octet-stream', :filename => "#{database}_#{Time.now.to_s(:human)}.backup")

    pipe = IO.popen("pg_dump '#{database}' -F c")
    stream = response.stream
    while (line = pipe.read(1024)) # per https://gist.github.com/njakobsen/6257887#gistcomment-1238467
      stream.write line
      Thread.pass # per https://gist.github.com/njakobsen/6257887#gistcomment-1235792

bf4

#!/usr/bin/env bash

# Created by Benjamin Fleischer 2019
# Distributed under the MIT license
# 
# Usage:
#  MINUTE_RANGES="0...10 30...40" ./clock echo 'we done it'
#  DEBUG=true MINUTE_RANGES="0...10 30...40" ./clock echo 'we done it'
main() {
  local ranges

bf4

require './lib/adsjdbc-10.10.0.28.jar'
java_import java.sql.Driver
java_import java.sql.DriverManager
java_import 'com.extendedsystems.jdbc.advantage.ADSDriver'

class AdsAdapter

  def initialize(connect_string)
    @connect_string = connect_string
  end

bf4

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "description": "JSON:API Schema",
  "type": "object",
  "properties": {
    "link": { "$ref": "file://schemata/link.json#" },
    "meta": { "$ref": "file://schemata/meta.json#" }
  }
}

bf4

A collection of Linux commands and concepts I tend to forget