phette23

# backup the mdl_data_records table before we modify it
gcloud sql export sql mysql-prod-1 gs://cca-manual-db-dumps/(dt)-mdl_data_records.sql -d m_prod1 -t mdl_data_records

phette23

#!/usr/bin/env fish
# download ALL live vault items to item.json and metadata.xml files
# 47283 total items, we can download 50 at a time
set total (eq search -l 1 | jq '.available')
set length 50
set pages (math floor $total / $length)
for i in (seq 0 $pages)
  set start (math $i \* $length)
  echo "Downloading items $start to" (math $start + $length)
  eq search -l $length --info metadata --start $start > .tmp/$i.json

phette23

// check if these sections appear on EQUELLA search results page
const sections = [
    'GELCT-6700-2',
    'LITPA-2000-10',
    'WRITE-6000-2',
]
console.log(`Checking for ${sections.length} section codes`)

// return list of missing sections
const missing = sections.filter(s => {

phette23

#!/usr/bin/env fish

# used for Art Practical site

# fill in credentials
set USER username
set PASS password
set COLLECTION 15633
# destination files
set JSONFILE data.json

phette23

document
	.querySelector('history-app').shadowRoot
	.querySelector('history-list').shadowRoot
	.querySelectorAll('history-item').forEach((hi, i) => {
		const cbox = hi.shadowRoot.querySelector('cr-checkbox')
		// merely setting checked = true doesn't work, chrome wants you to click them
		if (!cbox.checked) cbox.click()
	})

phette23

The How to Open a Homebrew Pull Request documentation is great. This doc assumes you've already created a fork of homebrew-core named after your user and a branch tracking the master of the fork.

cd (brew --repository homebrew/core)
brew update
git checkout phette23 # tracks master branch of fork
git pull # might need to sync fork to homebrew?
set FORMULA marcli # name of the project you're bumping
set VERSION 1.1.0 # semantic version
brew bump-formula-pr --no-fork --url https://github.com/account/$FORMULA/archive/refs/tags/v$VERSION.tar.gz project

phette23

from email.message import EmailMessage
import smtplib

from reminders.config import config


from_address = 'ephetteplace@cca.edu'
to_address = 'ephetteplace@cca.edu'

msg = EmailMessage()

phette23

#!/usr/bin/env fish
if ! git status 2&>/dev/null
    echo "Must be run inside a git repo, run 'git init' first if need be" >&2
    exit 1
end

begin
    if ! test -f LICENSE.txt
        echo "Downloading license text"
        wget https://raw.githubusercontent.com/cca/koha_snippets/main/LICENSE.txt

phette23

'''
Translate KBART file from OAPEN into Serials Solutions Client Center aka 360
Core database format. See the DatabaseTemplate.txt file for details.
'''
import csv


def get_first_isbn(isbns):
    """ return the first in a list of semicolon-separated ISBNs

phette23

#!/usr/bin/env bash
# accepts three files that are just the copy-pasted email column from a Google Sheet
# some of the rows can be empty, also note that the course shortnames change year to year
FRESH=$1
GRAD=$2
TRSFR=$3

# delete empty lines, remove "cca.edu" from emails
sed -e '/^$/d' -e 's|@cca\.edu||' -i '.bak' $FRESH
sed -e '/^$/d' -e 's|@cca\.edu||' -i '.bak' $GRAD