Skip to content

Instantly share code, notes, and snippets.

View johnnymo87's full-sized avatar

Jonathan Mohrbacher johnnymo87

View GitHub Profile
@johnnymo87
johnnymo87 / code_concatenator.bash
Last active April 22, 2024 00:50
Concatenates code files from a directory and its subdirectories into a single output file.
#!/usr/bin/env bash
: <<'END'
Script Name: code_concatenator.bash
Purpose:
This script is designed to concatenate all code files within a specified directory
and its subdirectories into a single output file. The output file will contain the
file paths and contents of each code file, separated by a delimiter (###). This
script is particularly useful for preparing code files for analysis or processing
@johnnymo87
johnnymo87 / compress_photos.bash
Last active April 16, 2024 13:10
Photo compression script to compress directory images under 25MB total
#!/usr/bin/env bash
: <<'END'
Script Name: compress_photos.bash
Purpose:
This script is designed to compress a directory of photos to ensure the total
size is under a specified limit (25 MB by default). It's particularly useful
for preparing image files for platforms with strict upload size limits or for
optimizing storage. The script iterates over a set of image files, applying
@johnnymo87
johnnymo87 / set-read-only.bash
Created February 27, 2024 21:51
Using the GitHub graphql API, set the read-only setting on an existing protection rule for a branch. When true, no one can merge pull requests to it.
#! /usr/bin/env bash
# Using the GitHub graphql API, set the read-only setting on an existing
# protection rule for a branch. When true, no one can merge pull requests to
# it.
#
# Dependencies:
# * gh (https://cli.github.com/)
# * A fine-grained GitHub personal access token, set as `GH_TOKEN` in the
# environment.
@johnnymo87
johnnymo87 / explanation.md
Last active December 22, 2023 16:52
Here's the fastest way to get raw SQL into an API endpoint, with minimal intervention from the model layer of the Rails framework.

To distill the essence of turning a raw SQL DB query into an API endpoint in Rails, we can abstract away the domain-specific details and focus on the general process. Here's a step-by-step guide that captures the technique:

Step 1: Define the SQL Query

Create a module with a method that encapsulates the raw SQL query. This method should accept parameters to filter or manipulate the data as needed and return the result set.

module Queries
  module CustomData
    def self.perform(params:)
 query = &lt;&lt;-SQL
number name
0 Black
1 Maroon
2 Green
3 Olive
4 Navy
5 Purple
6 Teal
7 Silver
8 Grey
@johnnymo87
johnnymo87 / plan.md
Last active April 24, 2023 13:52
How I pascal-cased a bunch screaming snake case variables
  • I am a neovim user and software engineer working on a rails 6.1 ruby 2.7 application.

  • All constants in the application use the SCREAMING_SNAKE_CASE naming convention.

  • The rubocop style guide suggests that I don't have to follow this convention when the constant refers to a class. For those that refer to a class, they can be PascalCased like classes normally are in ruby.

    image
  • I'm using ripgrep, and in vim I have a plugin where I can send search queries to ripgrep via the :Rg command.

  • I've written a ripgrep query to find all instances of where a class is assigned to a SCREAMING_SNAKE_CASE constant.

:Rg "[A-Z][A-Z0-9_]+\s+=\s+[A-Z][a-z]" -g "**/*.rb"

@johnnymo87
johnnymo87 / flip_flop_yard_doc.vim
Last active April 22, 2023 18:06
Vim script that I used to flip YARDoc from Java style to Ruby style
" Fix YARD documentation comments in one file.
function! FixYardComments()
" Search for incorrect @param syntax.
let search_pattern = '@param \[\(.*\)]\s\+\(\w\+\)'
" Replace incorrect syntax with correct one.
let replace_pattern = '@param \2 \[\1\]'
" Apply the replacement to the entire file.
execute '%s/' . search_pattern . '/' . replace_pattern . '/g'
@johnnymo87
johnnymo87 / .vimrc
Created April 21, 2023 15:50
How I converted all javascript files in a codebase from amd imports to commonjs
function! ReplaceRequireJS()
StripTrailingWhitespaces
normal gg
call search(')')
let @e= line('.')
call MaybeAddNewLineBelow()
call PrependModuleExports()
normal gg
normal @eJ
normal ^"aD
@johnnymo87
johnnymo87 / chatgpt-flyway-advice.md
Last active February 3, 2023 03:41
ChatGPT flyway advice

Prompt

Help me use flyway in python to define a postgresql schema for a coffee tasting application.

Response

Flyway is a database migration tool primarily designed for Java applications. It can also be used with other programming languages including Python, but requires a separate Flyway CLI component to be installed. To use Flyway in Python, you would need to write SQL scripts to define your database schema and manage its evolution over time.

Here's a simple example of how you could use Flyway to define a schema for a coffee tasting application:

  1. Install Flyway CLI: You can download the latest version of the Flyway CLI from the official Flyway website (https://flywaydb.org/).
@johnnymo87
johnnymo87 / auto-unit-cycle.diff
Created November 13, 2016 16:22
Expose 'Auto Unit Cycle' option in the UI
From 04157d2e3825baf4793e454076ffa0a12765bf6e Mon Sep 17 00:00:00 2001
From: johnnymo87 <johnnymo87@gmail.com>
Date: Sun, 13 Nov 2016 16:14:16 +0000
Subject: [PATCH] Expose 'Auto Unit Cycle' option in the UI
---
Text/en_US/FrontEndText.xml | 3 +++
UI/Options.lua | 5 +++++
UI/Options.xml | 4 ++++
3 files changed, 12 insertions(+)