johnnymo87

johnnymo87

• 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.

  

• 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

" 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

function! ReplaceRequireJS()
  StripTrailingWhitespaces
  normal gg
  call search(')')
  let @e= line('.')
  call MaybeAddNewLineBelow()
  call PrependModuleExports()
  normal gg
  normal @eJ
  normal ^"aD

johnnymo87

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

From 04157d2e3825baf4793e454076ffa0a12765bf6e Mon Sep 17 00:00:00 2001
From: johnnymo87 <[email protected]>
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(+)

johnnymo87

SQL Server on Mac via virtualization
Goal: I want to be able to spin up generic instances of sql server on-demand

Assumptions:
* [Windows Server 2016 Technical Preview (Core) is installed on virtualbox](http://ezeeetm.github.io/Docker-Engine-for-Windows-Server-Walkthrough/)
  * Typical defaults: 4096MB RAM, 32 GB fixed space
  * The image name is "sql server"
  * The network is "bridged adapter"
  * Guest additions are installed via `D:\VBoxWindowsAdditions.exe`

johnnymo87

module ExercisesSpec where

import Test.Hspec
import Test.QuickCheck
import Control.Exception (evaluate)

import Exercises

main :: IO ()
main = hspec $ do

johnnymo87

require 'spec_helper'

describe 'WITH RECURSIVE' do

  # http://www.postgresql.org/docs/8.4/static/queries-with.html
  # http://www.cybertec.at/common-mistakes-union-vs-union-all/

  def query(n)
    ActiveRecord::Base.connection.exec_query(
      <<-SQL

johnnymo87

M-D to D-M
:%s:\(\d\{1,2}/\)\(\d\{1,2}/\):\2\1:g

Discard all but the last 4 digits
::%s:\v.*(\d{4}):\1:g