midwire

certbot certonly --agree-tos --email <email> --webroot -w /var/lib/letsencrypt/ -d <domain> -d www.<domain>

midwire

# will need to supply passwords through stdin
pfx_to_crt_key() {
  openssl pkcs12 -in $@ -nocerts -out extracted_encrypted.key
  openssl pkcs12 -in $@ -clcerts -nokeys -out extracted.crt
  openssl rsa -in extracted_encrypted.key -out extracted_decrypted.key
}

midwire

[Interface]
PrivateKey = <KEY-HERE>
Address = <IP-HERE>, <IP6-HERE>
DNS =  <ETC>

# Customize to taste:

PostUp = route add -net 192.168.107.0 netmask 255.255.255.0 gw 192.168.1.1 metric 600 dev wlp5s0
PreDown = route del -net 192.168.107.0/24

midwire

-- https://stackoverflow.com/questions/3800551/select-first-row-in-each-group-by-group
-- Can be a good way to find the oldest duplicate records et. al.

SELECT DISTINCT ON (customer)
       id, customer, total
FROM   purchases
ORDER  BY customer, total DESC, id;

midwire

git -C "$(rbenv root)"/plugins/ruby-build pull

midwire

<template>
<h1>Create an event</h1>
<div class="form-container">
  // Vue form
  <form @submit.prevent="onSubmit">
    <label>Select a category: </label>
    <select v-model="event.category">
      <option
        v-for="option in categories"
        :value="option"

midwire

# Stub and Call the original
expect(object).to receive(:some_method).and_call_original
expect(object).to receive(:some_method).with(2,3),and_call_original
expect(object).to receive(:some_method).at_least(3).times.with(2,3),and_call_original

# Counts
expect(object).to receive(:some_method).once
expect(object).to receive(:some_method).twice
expect(object).to receive(:some_method).exactly(n).times
expect(object).to receive(:some_method).at_least(n).times

midwire

# Create a new Vue app
vue create APPNAME

midwire

sudo su - postgres
psql -d template1
alter user postgres with password 'new password';
exit # psql

exit # postgres login shell

systemctl restart postgresql

midwire

allow_any_instance_of(ActionController::TestRequest).to receive(:referrer) { 'whatever' }