wdhowe

DO $$
DECLARE
i TEXT;
BEGIN
  FOR i IN (
    SELECT 'SELECT SETVAL('
        || quote_literal(quote_ident(PGT.schemaname) || '.' || quote_ident(S.relname))
        || ', COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1) ) FROM '
        || quote_ident(PGT.schemaname)|| '.'||quote_ident(T.relname)|| ';'
      FROM pg_class AS S,

wdhowe

-- List all sequences and their current values, excluding system schemas
SELECT 
    n.nspname as schema,
    s.relname as sequence_name,
    t.relname as table_name,
    a.attname as column_name,
    pg_sequence_last_value(s.oid) as last_value
FROM pg_class s
JOIN pg_namespace n ON n.oid = s.relnamespace
JOIN pg_depend d ON d.objid = s.oid 

wdhowe

Git: Pull Request CLI

Some github cli example commands to open pull requests.

Remove --dry-run to create.

With a Template

Opens a pull reqest to merge SOURCEBRANCH into DESTBRANCH, using a markdown formatted template for the body.

wdhowe

Git: Checkout a single directory from a git repo

Setup Directory

mkdir myrepo && cd myrepo
git init

Configure Repo

wdhowe

Git: Move files and history from oldrepo to newrepo

Example commands show moving the "data" directory from oldrepo to newrepo and includes all history.

oldrepo (the source)

• Clone a fresh copy of oldrepo.

git clone [email protected]:USERHERE/oldrepo.git

wdhowe

parse_git_branch() {
     git branch 2> /dev/null | sed -e '/^[^*]/d' -e 's/* \(.*\)/(\1)/'
}

# color prompt example: "user@host:~/path(git-branch)$"
PS1='\[\033[01;32m\]\u@\h\[\033[00m\]:\[\033[01;34m\]\w\[\033[00m\]\[\e[91m\]$(parse_git_branch)\[\e[00m\]\$'

wdhowe

Analyze Clojure Docs Locally

Analyzing your project via the cljdoc-analyzer locally will ensure that when your project is pushed to clojars, the API docs will have a much better chance of successfully generating.

Install the cljdoc-analyzer.

clojure -Ttools install io.github.cljdoc/cljdoc-analyzer '{:git/tag "RELEASE"}' :as cljdoc

wdhowe

Extend your GPG key expiry

• Find the ID of the expiring key. Note your key ID.

  gpg --list-secret-keys

• Start editing the key.

wdhowe

Git Commands Cheat Sheet

Configuration

List Current Global Settings

git config --global --list

wdhowe

#!/bin/bash

url=$1

echo | \
openssl s_client -showcerts -servername ${url} -connect ${url}:443 2>/dev/null | \
openssl x509 -inform pem -noout -text